sho_db_param.ksh


sho_db_param()
{

sqlplus -s "/ as sysdba" <<EOF
set echo on
set feedback on
set linesize 500

show parameter sga_max_size
show parameter sga_target

-- alter system set sga_max_size=4G scope=spfile sid='*';
-- alter system set sga_target=4G scope=spfile sid='*';

show parameter ldap

-- alter system set ldap_directory_access=PASSWORD scope=both sid='*';

show parameter ldap

-- CREATE USER NBKGYQP IDENTIFIED GLOBALLY AS 'cn=nbkgyqp,cn=Users,dc=bankofamerica,dc=com'
--   DEFAULT TABLESPACE users
--   TEMPORARY TABLESPACE temp
--   PROFILE password_profile;

-- GRANT CREATE SESSION TO NBKGYQP;

show parameter cpu_count
show parameter db_block_size

show parameter statistics_level

show parameter nls

EOF

}

Leave a Reply

Your email address will not be published. Required fields are marked *