database_oracle_asm_basic

show parameter instance_name;
show parameter db_unique_name;
show parameter asm_power_limit;
show parameter asm_diskstring;
show parameter asm_diskgroups;
show parameter 
show parameter large_pool_size;
desc V$ASM_OPERATION;
desc V$ASM_DISK(_STAT);
desc V$ASM_DISKGROUP(_STAT);

export ORACLE_SID=SID<db_unique_name>
sqlplus /nolog
connect / as sysdba
startup;


show parameter instance_type;
show parameter spfile;
show sga;
show parametr sga_max_size;
show parameter db_block_zie;
show parameter db_cache_size;
show parameter db_keep_cache_size;
show parameter db_recycle_cache_size;
show parameter db_cache_advice;
show parameter log_buffer;
show parameter large_pool_size;
show parameter java_pool_size;
show parameter db_create_file_dest;
show paramter db_create_online_log_dest;
show parameter local_listener;
show parameter open_cursors;
show
alter system set param_name=value;
alter system switch logfile;
altre system checkpoint;
alter session set sql_trace=true;
alter system flush shared_pool;
tkprof xx.trc new_xx_file
set autotrace on explain

v$sql
v$sga_dynamic_components
v$process
v$session
v$parameter
v$lock
v$locked_object
dba_objects
nls_session_parameters
nls_database_parameters
nls_instance_parameters