# lists jobs in current session $ jobs # start job 1 (sleeps for 200 seconds) $ sleep 200 # suspended job 1 using control-z [1] + Stopped sleep 200 # start job 2 (sleeps for 400 seconds) $ sleep 400 # suspended job 2 using control-z [2] + Stopped sleep 400 # lists jobs … Continue reading process control
Tag: control
Restoring controlfile scenario?
Scenario when all control files for some reason have been lost. The following scenario shows how to restore controlfile and open the database. -- 1) Try to shutdown database which will fail as the control file(s) doesn't exists so one needs to perform shutdown abort SQL> shutdown immediate; ORA-00210: cannot open the specified control file … Continue reading Restoring controlfile scenario?
How to install Oracle Enterprise Manager Grid Control 11GR1?
The following document lists step how to install EM GridControl 11GR1 http://www.whopatooli.com/disquisitivedba/library/Joe_Johnson_Installing_EM_Grid_11gR1_11.1.0.1.pdf
Different options to display execution plan and statistics from SQL*Plus?
-- Turn off display of execution plan and statistics SET AUTOTRACE OFF -- show user query output, execution plan SET AUTOTRACE ON EXPLAIN -- display output from query and statistics SET AUTOTRACE ON STATISTICS -- show user query output, execution plan and statistics SET AUTOTRACE ON -- set trace on but suppress output from query, … Continue reading Different options to display execution plan and statistics from SQL*Plus?
alexlima.com 