http://www.adp-gmbh.ch/ora/tuning/tkprof/query_current.html http://www.google.com/search?q=how+to+read+tkprof http://www.dbspecialists.com/presentations/use_explain.html http://www.iselfschooling.com/mc4articles/mc4recovery.htm http://www.idevelopment.info/data/oracle/dba_tips/rman_9i/rman9_50.shtml http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html dba tasks users acc details select username, lock_date, account_status from dba_users; select username, lock_date, account_status from dba_users; sequence creation ***************** -- select formid.nextval -- alter sequence formid -- select formid.nextval -- alter sequence formid
from dual; increment by -&inc minvalue 0; from dual; increment by 1;
flashback on/off *************** sql> alter database flashback off; this wil clear all logs form flashback folder... to start flashback sql>shutdonw immediate sql>startup mount sql> alter database flashback on; sql> alter database open ***************************** error ora-16038: log 1 sequence# 140 cannot be archived ora-19809: limit exceeded for recovery files ora-00312: online log 1 thread 1: 'c:\oracle\product\10.2.0\oradata\ruby\redo01.log' sql>show parameter sql>alter system set db_recovery_file_dest_size =6g; archiveing the current log file ***************** --alter system archive log current; archive /noarchive log ********************** -- select log_mode from v$database; configure for multiple archiver processes
exp -- select value from gv$parameter where name = 'log_archive_max_processes'; -- alter system set log_archive_max_processes=3; -- select value from gv$parameter where name = 'log_archive_max_processes'; database in archivemode *********************** -- shutdown; -- startup mount exclusive; -- alter database archivelog; -- alter database open; database in noarchivemode **************************** -- shutdown; -- startup mount exclusive; -- alter database noarchivelog; -- alter database open; archiving logging failure ******************** -- shutdown; -- startup; -- archive log start; -- archive log all; start archive logging :- alter system archive log start; stop archive logging :- alter system archive log stop; force archiving of all log files :- alter system archive log all; force archiving of the current log file :- alter system archive log current; shutdowing db if in problem mode ********************** -- alter system checkpoint; -- shutdown abort -- startup restrict -- shutdown immediate rman clean old archive log file ************************** --http://terrencemiao.com/webmail/msg00776.html rman> connect target / connected to target database: instant (dbid=3145087615) rman> crosscheck archivelog all; rman> show retention policy; rman> report obsolete; rman> delete noprompt archivelog until time 'sysdate - 4'; rman> crosscheck archivelog all; rman>list backup of archivelog all summary;list backup of database summary - list backup of archivelog all summary ? - list backup of archivelog until time 'sysdate -4' summary
=========== scene : when db was in problm & create spfile from pfile, archiveing probm created used this below cmd..worked fined alter system archive log all to '/oracle/flash_recovery_area/orabase/archivelog';