Step by Step oracle database 10gR2 upgrade to 11.2.0.2(二)

2014-11-24 08:58:48 · 作者: · 浏览: 1
ct count(*) from system.aud$ where dbid is null

*

ERROR at line 1:

ORA-00942:table or view does not exist

=============================================================================

count of records in the sys.fga_log$ when dbid is null,Fine Grained Auditing

=============================================================================

0

==========================================

Oracle Label Security is installed or not

==========================================

Oracle Label Security is NOT installed at database level

================

Number of AQ Records in Message Queue Tables

================

SYS - ALERT_QT - 28968

SYS - AQ$_MEM_MC - 0

SYS - AQ_EVENT_TABLE - 0

SYS - AQ_SRVNTFN_TABLE - 0

SYS - KUPC$DATAPUMP_QUETAB - 0

SYS - SCHEDULER$_EVENT_QTAB - 0

SYS - SCHEDULER$_JOBQTAB - 0

SYS - SYS$SERVICE_METRICS_TAB - 0

SYSMAN - MGMT_NOTIFY_QTABLE - 0

SYSTEM - DEF$_AQCALL - 0

SYSTEM - DEF$_AQERROR - 0

WMSYS - WM$EVENT_QUEUE_TABLE - 0

================

Time Zone version

================

4

================

Local Listener

================

================

Default and Temporary Tablespaces By User

================

USERNAME TEMPORARY_TABLESPACE DEFAULT_TABLESPACE

---------------------------- ---------------------- ----------------------

PERFSTAT TEMP_TS STATSPACK

BHMCCRM TEMP_TS DMSB_TS01

DMSB01 TEMP_TS DMSB_TS01

KCHC01 TEMP_TS USERS

BMC TEMP_TS USERS

BHMCIT TEMP_TS USERS

SCOTT TEMP_TS USERS

MDDATA TEMP_TS USERS

TSMSYS TEMP_TS USERS

DIP TEMP_TS USERS

ORACLE_OCM TEMP_TS USERS

DBSNMP TEMP_TS SYSAUX

SYSMAN TEMP_TS SYSAUX

EXFSYS TEMP_TS SYSAUX

DMSYS TEMP_TS SYSAUX

WMSYS TEMP_TS SYSAUX

ORDSYS TEMP_TS SYSAUX

XDB TEMP_TS SYSAUX

SI_INFORMTN_SCHEMA TEMP_TS SYSAUX

ORDPLUGINS TEMP_TS SYSAUX

MDSYS TEMP_TS SYSAUX

CTXSYS TEMP_TS SYSAUX

ANONYMOUS TEMP_TS SYSAUX

MGMT_VIEW TEMP_TS SYSTEM

SYS TEMP_TS SYSTEM

SYSTEM TEMP_TS SYSTEM

OUTLN TEMP_TS SYSTEM

DRS DRS_TMP DRS_SPA

DRS_BACKUP TBST_BTEP TBSD_TDEF

================

Component Status

================

Comp ID Component Status Version