[code language=”sql”]

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

}

[/code]