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
}