Installing SQLcl

SQLcl is the new command line tool from Oracle, more specifically from the SQL Developer team. It is currently an Early Adopter (EA) release and you can download it from: http://www.oracle.com/technet Source: Installing SQLcl  

List all running jobs

SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PAGESIZE 60 SET LINESIZE 300 SET VERIFY OFF SELECT a.job “Job”, a.sid, a.failures “Failures”, Substr(To_Char(a.last_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “Last Date”, Substr(To_Char(a.this_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “This Date” FROM dba_jobs_running a /

How to create manualy the AWR reports

Not everyone has a GUI to extract the AWR reports from an Oracle database, hence here is what you need to do: SCOTT@DB_TEST> @$ORACLE_HOME/rdbms/admin/awrrpt.sql Current Instance ~~~~~~~~~~~~~~~~    DB Id    DB Name      Inst Num Instance ———– ———— ——– ————  3621956494 DB_TEST              1 DB_TEST Elapsed: 00:00:00.03 Elapsed: 00:00:00.01 Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ Would you like…

How to create manualy the AWR reports

Not everyone has a GUI to extract the AWR reports from an Oracle database, hence here is what you need to do: SCOTT@DB_TEST> @$ORACLE_HOME/rdbms/admin/awrrpt.sql Current Instance ~~~~~~~~~~~~~~~~    DB Id    DB Name      Inst Num Instance ———– ———— ——– ————  3621956494 DB_TEST              1 DB_TEST Elapsed: 00:00:00.03 Elapsed: 00:00:00.01 Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ Would you like…