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: [email protected]_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…

Dataguard missing archivelog

Below you can find one of the available solutions that can be applied to solve this issue: PRI select max(sequence#) from v$archived_log where applied=’YES’; STBY select max(sequence#) from v$archived_log where applied=’YES’; SQL> select * from v$archive_gap;    THREAD# LOW_SEQUENCE# HIGH_SEQUENCE# ———- ————- ————–          1          285           285 RMAN> list ARCHIVELOG FROM SEQUENCE 286 until SEQUENCE…

Where is the TEMP space used?

The following statements should give us more indication about the TEMP usage and what is using it: col username format a10 col osuser format a8 col SID_SERIAL format a8 col PROCESS format 9999999 col tablespace format a7 col status format a9 col size_mb format 9999999999999 set lin 300 SELECT   b.TABLESPACE        –, b.segfile#        –,…

Get the list of patches

set lin 600 col action format a10 col namespace format a7 col version format a10 col bundle_series format a30 col comments format a30 select id,action,namespace,version,bundle_series,comments from registry$history; Another solution: cat /u01/app/oracle/product/11.2.0.3/.patch_storage/record_inventory.txt