sqlplus /nolog

conn / as sysdba;

set linesize 200;   --宽

set pagesize 100; --高

set num 50;          --数字长度

col SEG_OWNER format a10;   文本字段宽度

col table_name format a30;

col operation_code format 999;  数字字段格式

col x format 9999999;

exec sys.dbms_logmnr.add_logfile(logfilename =>'/oracle/oraarc/kyosfcs/1_11924_870522699.dbf'); --载入log,绝对路径.

exec sys.dbms_logmnr.start_logmnr(options => sys.dbms_logmnr.dict_from_online_catalog); --使用当前db的字典

select seg_owner,count(*)  from v$logmnr_contents group by seg_owner;

select seg_owner,table_name,operation_code,count(*) as x from v$logmnr_contents group by seg_owner,table_name,operation_code  order by x desc;

select sql_undo,sql_redo from v$logmnr_contents where scn in (select max(scn) from v$logmnr_contents);

execute dbms_logmnr.end_logmnr ;--结束

SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

Current Instance

~~~~~~~~~~~~~~~~

   DB Id    DB Name Inst Num Instance

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

  257816635 KYOSFCS 1 kyosfcs

Specify the Report Type

~~~~~~~~~~~~~~~~~~~~~~~

Would you like an HTML report, or a plain text report?

Enter 'html' for an HTML report, or 'text' for plain text

Defaults to 'html'

Type Specified:  html

Instances in this Workload Repository schema

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     Inst Num DB Name    Instance Host

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

  257816635     1 KYOSFCS    kyosfcs kyo-sfcs02-l

inux

* 257816635     1 KYOSFCS    kyosfcs ksyod01

  257816635     1 KYOSFCS    kyosfcs ksyod01.youn

goptics.com

  257816635     1 KYOSFCS    kyosfcs ksyod011

  257816635     1 KYOSFCS    kyosfcs kyo-sfcs01-l

inux.youngop

tics.com

  257816635     1 KYOSFCS    kyosfcs KSYOD01.youn

goptics.com

Using  257816635 for database Id

Using        1 for instance number

Specify the number of days of snapshots to choose from

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Entering the number of days (n) will result in the most recent

(n) days of snapshots being listed.  Pressing without

specifying a number lists all completed snapshots.

Listing the last 7 days of Completed Snapshots

Snap

Instance     DB Name     Snap Id    Snap Started    Level

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

kyosfcs      KYOSFCS       60750 25 5?  2018 00:00    1

      60751 25 5?  2018 01:00    1

      60752 25 5?  2018 02:01    1

      60753 25 5?  2018 03:01    1

Specify the Begin and End Snapshot Ids

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Enter value for begin_snap: 60902

Begin Snapshot Id specified: 60902

Enter value for end_snap: 60903

End   Snapshot Id specified: 60903

Specify the Report Name

~~~~~~~~~~~~~~~~~~~~~~~

The default report file name is awrrpt_1_60902_60903.html.  To use this name,

press to continue, otherwise enter an alternative.

Enter value for report_name: 

Using the report name awrrpt_1_60902_60903.html

.dba_开头表 

   dba_users           用户信息     dba_segments    表段信息     dba_extents        数据区信息     dba_objects        数据库对象信息     dba_tablespaces 数据库表空间信息     dba_data_files     数据文件设置信息     dba_temp_files    临时数据文件信息     dba_rollback_segs         回滚段信息     dba_ts_quotas               用户表空间配额信息     dba_free_space              数据库空闲空间信息     dba_profiles                    数据库用户资源限制信息     dba_sys_privs                用户的系统权限信息     dba_tab_privs                 用户具有的对象权限信息     dba_col_privs                用户具有的列对象权限信息     dba_role_privs                用户具有的角色信息     dba_audit_trail                审计跟踪记录信息     dba_stmt_audit_opts       审计设置信息     dba_audit_object             对象审计结果信息     dba_audit_session