DB스토리

질의. col ksppinm form a40; col ksppstvl form a40; select ksppinm,ksppstvl from x$ksppi x,x$ksppcv y where(x.indx=y.indx) and (translate(ksppinm,'_','#') like '%&1%') / Show_param 으로 저장

메모리 보기 S SYS> show sga Total System Global Area 268435456 bytes Fixed Size 1218920 bytes Variable Size 201328280 bytes Database Buffers 62914560 bytes Redo Buffers 2973696 bytes S SYS> show parameter db_cache_size S SYS> show parameter sga_max; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 256M S SYS> show parameter pool;..

통상적인 parameter 파일 백업 create pfile='/home/oracle/_setting/initorcl.ora.090519_1' from spfile; 고장내기-- [oracle@orcl ~]$ rm /u01/app/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora S SYS> shutdown abort ORACLE instance shut down. S SYS> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora' 백업한 paramete..