Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3303902
  • 博文数量: 631
  • 博客积分: 10716
  • 博客等级: 上将
  • 技术积分: 8397
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-01 22:35
文章分类

全部博文(631)

文章存档

2020年(2)

2019年(22)

2018年(4)

2017年(37)

2016年(22)

2015年(1)

2013年(12)

2012年(20)

2011年(19)

2010年(20)

2009年(282)

2008年(190)

分类: Oracle

2012-01-20 00:00:00

[oracle@RAC2 ~]$ ls -l
total 304
-rw-r--r--  1 oracle oinstall     62 Jan  9  2011 afiedt.buf
drwxr-xr-x  2 oracle oinstall   4096 Jan  9 01:15 backup
drwxr-xr-x  2 oracle oinstall   4096 Oct 25  2009 Desktop
-rw-r--r--  1 oracle oinstall  49481 Jul 16  2011 dict.lst
-rw-r--r--  1 root   root         46 Jan  9  2011 find
-rw-r--r--  1 oracle oinstall 132635 Jul 21 11:59 fixed_table.lst
-rw-r--r--  1 oracle oinstall    197 Aug 24 06:04 free.sql
-rw-r--r--  1 oracle oinstall    292 Jan 17 00:21 get_sql_bypid.sql
-rw-r--r--  1 oracle oinstall  64709 Jul 16  2011 log.lst
-rw-r--r--  1 oracle oinstall   3626 Jul 16  2011 oracle_check.sh
-rwxr-xr-x  1 oracle oinstall   1324 Aug 20  2010 racdb2.ora
-rwxr-xr-x  1 oracle oinstall    470 Jan  6  2010 res.rcv
drwxr-xr-x  4 oracle oinstall   4096 Jan  9 07:45 SQL
-rw-r--r--  1 oracle oinstall    248 Jan  9  2011 while
[oracle@RAC2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 19 00:45:22 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> get get_sql_bypid
  1  select a.sql_text from v$sqltext a where (a.hash_value,a.address) in (
  2  select decode (sql_hash_value,0,prev_hash_value,sql_hash_value),
  3  decode (sql_hash_value,0,prev_sql_addr,sql_address)
  4  from v$session b
  5  where b.paddr=(select addr from v$process c where c.spid='&pid'))
  6* order by piece asc
SQL> select count(*) from tabs;
  COUNT(*)
----------
       708
SQL> @get_sql_bypid
Enter value for pid: 5923
old   5: where b.paddr=(select addr from v$process c where c.spid='&pid'))
new   5: where b.paddr=(select addr from v$process c where c.spid='5923'))
SQL_TEXT
----------------------------------------------------------------
select a.sql_text from v$sqltext a where (a.hash_value,a.address
) in ( select decode (sql_hash_value,0,prev_hash_value,sql_hash_
value), decode (sql_hash_value,0,prev_sql_addr,sql_address) from
 v$session b where b.paddr=(select addr from v$process c where c
.spid='5923')) order by piece asc
SQL> @get_sql_bypid
Enter value for pid: 5922
old   5: where b.paddr=(select addr from v$process c where c.spid='&pid'))
new   5: where b.paddr=(select addr from v$process c where c.spid='5922'))
no rows selected
SQL> select L.sid ssid,substr(OPNAME,1,15) opname,target,trunc((sofar/totalwork)*100) pct,
  2  to_char(60*sofar*8192/(24*60*(last_update_time - start_time))/1024/1024/60,'9999.0')
  3  Rate,
  4  elapsed_seconds/60 es,
  5  time_remaining/60 tr,PROGRAM,MACHINE
  6  from v$session_longops L,v$session S
  7  where time_remaining > 0 and L.SID=S.SID
  8  order by start_time
  9  /
no rows selected
SQL>  @get_sql_bypid
Enter value for pid: 5923
old   5: where b.paddr=(select addr from v$process c where c.spid='&pid'))
new   5: where b.paddr=(select addr from v$process c where c.spid='5923'))
SQL_TEXT
----------------------------------------------------------------
select a.sql_text from v$sqltext a where (a.hash_value,a.address
) in ( select decode (sql_hash_value,0,prev_hash_value,sql_hash_
value), decode (sql_hash_value,0,prev_sql_addr,sql_address) from
 v$session b where b.paddr=(select addr from v$process c where c
.spid='5923')) order by piece asc
SQL>  @get_sql_bypid
Enter value for pid: 5922
old   5: where b.paddr=(select addr from v$process c where c.spid='&pid'))
new   5: where b.paddr=(select addr from v$process c where c.spid='5922'))
no rows selected
SQL>  @get_sql_bypid
Enter value for pid: 5682
old   5: where b.paddr=(select addr from v$process c where c.spid='&pid'))
new   5: where b.paddr=(select addr from v$process c where c.spid='5682'))
no rows selected
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> @get_sql_bypid
Enter value for pid: 5923
old   5: where b.paddr=(select addr from v$process c where c.spid='&pid'))
new   5: where b.paddr=(select addr from v$process c where c.spid='5923'))
SQL_TEXT
----------------------------------------------------------------
select a.sql_text from v$sqltext a where (a.hash_value,a.address
) in ( select decode (sql_hash_value,0,prev_hash_value,sql_hash_
value), decode (sql_hash_value,0,prev_sql_addr,sql_address) from
 v$session b where b.paddr=(select addr from v$process c where c
.spid='5923')) order by piece asc
SQL> desc dba_data_files;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_NAME                                          VARCHAR2(513)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                                    VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             VARCHAR2(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER
 ONLINE_STATUS                                      VARCHAR2(7)
SQL> select  TABLESPACE_NAME,sum(bytes/1024/1024) MB,status from dba_data_files group by TABLESPACE_NAME;
select  TABLESPACE_NAME,sum(bytes/1024/1024) MB,status from dba_data_files group by TABLESPACE_NAME
                                                *
ERROR at line 1:
ORA-00979: not a GROUP BY expression

SQL> select TABLESPACE_NAME,sum(bytes/1024/1024) MB,status from dba_data_files group by TABLESPACE_NAME;
select TABLESPACE_NAME,sum(bytes/1024/1024) MB,status from dba_data_files group by TABLESPACE_NAME
                                               *
ERROR at line 1:
ORA-00979: not a GROUP BY expression

SQL> select TABLESPACE_NAME,sum(bytes/1024/1024) MB from dba_data_files group by TABLESPACE_NAME;
TABLESPACE_NAME                        MB
------------------------------ ----------
SYSAUX                                250
UNDOTBS1                              215
USERS                                   5
SYSTEM                                480
NBS                                   220
SQL> select sql_id from v$sql where sql_text like 'select TABLESPACE_NAME,sum(bytes/1024/1024) MB from dba_data_files group by TABLESPACE_NAME';
SQL_ID
-------------
ajru4r5m2djwt
SQL> select plan_table_output from table(dbms_xplan.display_cursor('ajru4r5m2djwt'));
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
SQL_ID  ajru4r5m2djwt, child number 0
-------------------------------------
select TABLESPACE_NAME,sum(bytes/1024/1024) MB from dba_data_files group by TABL
ESPACE_NAME

Plan hash value: 4060413641
--------------------------------------------------------------------------------
----------------------

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
| Id  | Operation                         | Name             | Rows  | Bytes | C
ost (%CPU)| Time     |
--------------------------------------------------------------------------------
----------------------
|   0 | SELECT STATEMENT                  |                  |       |       |
   5 (100)|          |
|   1 |  HASH GROUP BY                    |                  |     2 |    60 |
   5  (20)| 00:00:01 |
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
|   2 |   VIEW                            | DBA_DATA_FILES   |     2 |    60 |
   4   (0)| 00:00:01 |
|   3 |    UNION-ALL                      |                  |       |       |
          |          |
|   4 |     NESTED LOOPS                  |                  |     1 |   355 |
   2   (0)| 00:00:01 |
|   5 |      NESTED LOOPS                 |                  |     1 |   340 |
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
   1   (0)| 00:00:01 |
|   6 |       NESTED LOOPS                |                  |     1 |   327 |
   1   (0)| 00:00:01 |
|*  7 |        FIXED TABLE FULL           | X$KCCFN          |     1 |   310 |
   0   (0)|          |
|*  8 |        TABLE ACCESS BY INDEX ROWID| FILE$            |     1 |    17 |
   1   (0)| 00:00:01 |

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
|*  9 |         INDEX UNIQUE SCAN         | I_FILE1          |     1 |       |
   0   (0)|          |
|* 10 |       FIXED TABLE FIXED INDEX     | X$KCCFE (ind:1)  |    17 |   221 |
   0   (0)|          |
|  11 |      TABLE ACCESS CLUSTER         | TS$              |     1 |    15 |
   1   (0)| 00:00:01 |
|* 12 |       INDEX UNIQUE SCAN           | I_TS#            |     1 |       |
   0   (0)|          |
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
|  13 |     NESTED LOOPS                  |                  |     1 |   399 |
   2   (0)| 00:00:01 |
|  14 |      NESTED LOOPS                 |                  |     1 |   386 |
   2   (0)| 00:00:01 |
|  15 |       NESTED LOOPS                |                  |     1 |   377 |
   1   (0)| 00:00:01 |
|  16 |        NESTED LOOPS               |                  |     1 |   362 |
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
   0   (0)|          |
|* 17 |         FIXED TABLE FULL          | X$KCCFN          |     1 |   310 |
   0   (0)|          |
|* 18 |         FIXED TABLE FIXED INDEX   | X$KTFBHC (ind:1) |     1 |    52 |
   0   (0)|          |
|  19 |        TABLE ACCESS CLUSTER       | TS$              |     1 |    15 |
   1   (0)| 00:00:01 |

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
|* 20 |         INDEX UNIQUE SCAN         | I_TS#            |     1 |       |
   0   (0)|          |
|* 21 |       TABLE ACCESS BY INDEX ROWID | FILE$            |     1 |     9 |
   1   (0)| 00:00:01 |
|* 22 |        INDEX UNIQUE SCAN          | I_FILE1          |     1 |       |
   0   (0)|          |
|* 23 |      FIXED TABLE FIXED INDEX      | X$KCCFE (ind:1)  |    17 |   221 |
   0   (0)|          |
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------------------

Predicate Information (identified by operation id):
---------------------------------------------------
   7 - filter(("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE
') AND

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
              BITAND("FNFLG",4)<>4))
   8 - filter("F"."SPARE1" IS NULL)
   9 - access("FNFNO"="F"."FILE#")
  10 - filter("FE"."FENUM"="F"."FILE#")
  12 - access("F"."TS#"="TS"."TS#")
  17 - filter(("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE
') AND
              BITAND("FNFLG",4)<>4))
  18 - filter("FNFNO"="HC"."KTFBHCAFNO")
  20 - access("HC"."KTFBHCTSN"="TS"."TS#")
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
  21 - filter("F"."SPARE1" IS NOT NULL)
  22 - access("FNFNO"="F"."FILE#")
  23 - filter("FE"."FENUM"="F"."FILE#")

52 rows selected.
SQL> get get_sql_bypid
  1  select a.sql_text from v$sqltext a where (a.hash_value,a.address) in (
  2  select decode (sql_hash_value,0,prev_hash_value,sql_hash_value),
  3  decode (sql_hash_value,0,prev_sql_addr,sql_address)
  4  from v$session b
  5  where b.paddr=(select addr from v$process c where c.spid='&pid'))
  6* order by piece asc
SQL> @get_sql_bypid
Enter value for pid: 5923
old   5: where b.paddr=(select addr from v$process c where c.spid='&pid'))
new   5: where b.paddr=(select addr from v$process c where c.spid='5923'))
SQL_TEXT
----------------------------------------------------------------
select a.sql_text from v$sqltext a where (a.hash_value,a.address
) in ( select decode (sql_hash_value,0,prev_hash_value,sql_hash_
value), decode (sql_hash_value,0,prev_sql_addr,sql_address) from
 v$session b where b.paddr=(select addr from v$process c where c
.spid='5923')) order by piece asc
SQL> desc v$sql;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SQL_TEXT                                           VARCHAR2(1000)
 SQL_FULLTEXT                                       CLOB
 SQL_ID                                             VARCHAR2(13)
 SHARABLE_MEM                                       NUMBER
 PERSISTENT_MEM                                     NUMBER
 RUNTIME_MEM                                        NUMBER
 SORTS                                              NUMBER
 LOADED_VERSIONS                                    NUMBER
 OPEN_VERSIONS                                      NUMBER
 USERS_OPENING                                      NUMBER
 FETCHES                                            NUMBER
 EXECUTIONS                                         NUMBER
 PX_SERVERS_EXECUTIONS                              NUMBER
 END_OF_FETCH_COUNT                                 NUMBER
 USERS_EXECUTING                                    NUMBER
 LOADS                                              NUMBER
 FIRST_LOAD_TIME                                    VARCHAR2(38)
 INVALIDATIONS                                      NUMBER
 PARSE_CALLS                                        NUMBER
 DISK_READS                                         NUMBER
 DIRECT_WRITES                                      NUMBER
 BUFFER_GETS                                        NUMBER
 APPLICATION_WAIT_TIME                              NUMBER
 CONCURRENCY_WAIT_TIME                              NUMBER
 CLUSTER_WAIT_TIME                                  NUMBER
 USER_IO_WAIT_TIME                                  NUMBER
 PLSQL_EXEC_TIME                                    NUMBER
 JAVA_EXEC_TIME                                     NUMBER
 ROWS_PROCESSED                                     NUMBER
 COMMAND_TYPE                                       NUMBER
 OPTIMIZER_MODE                                     VARCHAR2(10)
 OPTIMIZER_COST                                     NUMBER
 OPTIMIZER_ENV                                      RAW(797)
 OPTIMIZER_ENV_HASH_VALUE                           NUMBER
 PARSING_USER_ID                                    NUMBER
 PARSING_SCHEMA_ID                                  NUMBER
 PARSING_SCHEMA_NAME                                VARCHAR2(30)
 KEPT_VERSIONS                                      NUMBER
 ADDRESS                                            RAW(4)
 TYPE_CHK_HEAP                                      RAW(4)
 HASH_VALUE                                         NUMBER
 OLD_HASH_VALUE                                     NUMBER
 PLAN_HASH_VALUE                                    NUMBER
 CHILD_NUMBER                                       NUMBER
 SERVICE                                            VARCHAR2(64)
 SERVICE_HASH                                       NUMBER
 MODULE                                             VARCHAR2(64)
 MODULE_HASH                                        NUMBER
 ACTION                                             VARCHAR2(64)
 ACTION_HASH                                        NUMBER
 SERIALIZABLE_ABORTS                                NUMBER
 OUTLINE_CATEGORY                                   VARCHAR2(64)
 CPU_TIME                                           NUMBER
 ELAPSED_TIME                                       NUMBER
 OUTLINE_SID                                        NUMBER
 CHILD_ADDRESS                                      RAW(4)
 SQLTYPE                                            NUMBER
 REMOTE                                             VARCHAR2(1)
 OBJECT_STATUS                                      VARCHAR2(19)
 LITERAL_HASH_VALUE                                 NUMBER
 LAST_LOAD_TIME                                     VARCHAR2(38)
 IS_OBSOLETE                                        VARCHAR2(1)
 CHILD_LATCH                                        NUMBER
 SQL_PROFILE                                        VARCHAR2(64)
 PROGRAM_ID                                         NUMBER
 PROGRAM_LINE#                                      NUMBER
 EXACT_MATCHING_SIGNATURE                           NUMBER
 FORCE_MATCHING_SIGNATURE                           NUMBER
 LAST_ACTIVE_TIME                                   DATE
 BIND_DATA                                          RAW(2000)
SQL> select sql_text,SQL_ID from v$sql;
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
update sys.job$ set this_date=:1 where job=:2
aq8yqxyyb40nn
SELECT NVL(DISPLAY_NAME, :B1 ) FROM MGMT_PERFORMANCE_NAMES WHERE IS_DBMSJOB='Y'
AND :B1 LIKE (DBMS_JOBNAME||'%') AND ROWNUM = 1
6k825qt9n816u
select streams_pool_size_for_estimate s,           streams_pool_size_factor * 10
0 f,           estd_spill_time + estd_unspill_time, 0  from v$streams_pool_advic
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
e
g6gu1n3x0h1h4
select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by i
ntcol# asc
9g485acn2n30m
select a.obj# OBJOID, a.class_oid CLSOID,    decode(bitand(a.flags, 16384), 0, a
.next_run_date, a.last_enabled_time) RUNTIME,    (2*a.priority +     decode(bita
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
nd(a.job_status, 4), 0, 0,            decode(a.running_instance, :1, -1, 1))) PR
I,    1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT,    decode(a.running_i
nstance, NULL, 0, a.running_instance) INST,    decode(bitand(a.flags, 16384), 0,
 0, 1) RUNNOW,    decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM  fro
m sys.scheduler$_job a  where bitand(a.job_status, 515) = 1    and ((bitand(a.fl
ags, 134217728 + 268435456) = 0) or         (bitand(a.job_status, 1024) <> 0))
  and bitand(a.flags, 4096) = 0    and (a.next_run_date <= :2       or bitand(a.
flags, 16384) <> 0)    and a.class_oid is not null    and a.class_oid in (select
 b.obj# from scheduler$_class b                        where bitand(b.flags, :4)
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 <> 0 and b.affinity = :5) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
7mvdhsu3d43ag
SELECT DECODE(PARAMETER_VALUE, :B3 , 3, :B2 , 2, :B1 , 1, 0) FROM MGMT_PARAMETER
S WHERE PARAMETER_NAME = 'system_error_log_level'
dm39phkdf04ug
select timestamp, flags from fixed_obj$ where obj#=:1
asvzxj61dc5vs
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnb
as,NVL(spare1,0) from file$ where file#=:1
19g6x6d7nh669
select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnb
as,NVL(spare1,0) from file$ where file#=:1
19g6x6d7nh669

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select o.owner#, u.name,        o.name,            o.namespace,    o.obj#,   d.d
_timestamp, nvl(d.property,0), o.type#, o.subname, d.d_attrs  from dependency$ d
, obj$ o, user$ u  where d.p_obj#=:1  and   (d.p_timestamp=:2 or d.property=2)
and   d.d_obj#=o.obj#  and   o.owner#=u.user#  order by o.obj#
9p1um1wd886xb
insert into wrh$_sql_summary    (snap_id, dbid, instance_number,     total_sql,
total_sql_mem, single_use_sql, single_use_sql_mem)  values (:snap_id, :dbid, :in
stance_number,          :total_sql, :total_sql_mem,          :single_use_sql, :s
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
ingle_use_sql_mem)
c70vdnhx5w8sw
select /* EXEC_FROM_DBMS_XPLAN */ case when upper(sql_text) like '%DBMS_XPLAN%'
then 0 else 1 end case, SQL_ID, child_number from v$sql where SQL_ID ='ajru4r5m2
djwt' and child_number =0
8v64bny1ds96r
INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KE
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
Y_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , NULL, :B1 )
6d64jpfzqc9rv
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;  broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6gvch1xu9ca3g
select size_for_estimate,                      size_factor * 100 f,
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
       estd_physical_read_time,                estd_physical_reads
from v$db_cache_advice where id = '3'
aykvshm7zsabd
SELECT TO_CHAR(COUNT(D.TARGET_NAME)) FROM MGMT_DUPLICATE_TARGETS D, MGMT_TARGETS
 T, MGMT_TARGETS CA WHERE D.TARGET_GUID = T.TARGET_GUID (+) AND D.DUPLICATE_EMD_
URL = CA.EMD_URL AND CA.TARGET_TYPE = :B1
f1xz06vk5sah4

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
insert into wrh$_sql_bind_metadata   (snap_id, dbid,    sql_id, name, position,
dup_position,    datatype, datatype_string,    character_sid, precision, scale,
max_length)  SELECT /*+ ordered use_nl(b) index(b sql_id) */      :lah_snap_id,
:dbid,      bnd.sql_id, name, position, dup_position,      datatype, datatype_st
ring,      character_sid, precision, scale, max_length    FROM      x$kewrattrne
w      new,      x$kewrsqlidtab     tab,      v$sql_bind_capture bnd     WHERE n
ew.str1_kewrattr     = tab.sqlid_kewrsie      AND tab.sqlid_kewrsie     = bnd.sq
l_id      AND tab.childaddr_kewrsie = bnd.child_address
cga1vwr4jcb1d
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfre
e$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt
, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$
 where bo# = :1 order by part#
130dvvr5s8bgn
insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas,  num
_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
6cxqh7mktnbjm
select inst_id, java_size, round(java_size / basejava_size, 4),  kgljsim_size, k
gljsim_objs, kgljsim_timesave,  decode(kgljsim_basetimesave, 0, to_number(null),
         round(kgljsim_timesave / kgljsim_basetimesave, 4)),  kgljsim_parsetime,
 decode(kgljsim_baseparsetime, 0, to_number(null),         round(kgljsim_parseti
me / kgljsim_baseparsetime, 4)),  kgljsim_hits from x$kgljsim
85sxp7kypwbx6

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
UPDATE WRH$_SQL_PLAN SET snap_id = :lah_snap_id  WHERE dbid = :dbid    AND (SQL_
ID, PLAN_HASH_VALUE) IN (SELECT STR1_KEWRATTR, NUM1_KEWRATTR FROM X$KEWRATTRSTAL
E)
2dxssy6a18cpa
SELECT C.TARGET_GUID, C.METRIC_GUID, C.STORE_METRIC, C.SCHEDULE, C.COLL_NAME, M.
METRIC_NAME, M.EVAL_FUNC FROM MGMT_METRIC_COLLECTIONS_REP R, MGMT_METRIC_COLLECT
IONS C, MGMT_METRICS M WHERE C.SUSPENDED = 0 AND C.IS_REPOSITORY = 1 AND (C.LAST
_COLLECTED_TIMESTAMP IS NULL OR C.LAST_COLLECTED_TIMESTAMP + C.SCHEDULE / 1440 <
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 SYSDATE) AND C.METRIC_GUID = M.METRIC_GUID AND R.TARGET_GUID = C.TARGET_GUID AN
D R.METRIC_GUID = C.METRIC_GUID AND R.COLL_NAME = C.COLL_NAME
19v5guvsgcd1v
SELECT STRING_VALUE FROM MGMT_CURRENT_METRICS WHERE TARGET_GUID = :B3 AND METRIC
_GUID = :B2 AND KEY_VALUE = :B1
444ygb1fcndkz
select sga_size, sga_size_factor, estd_db_time,                  estd_db_time_fa
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
ctor, estd_physical_reads                         from gv$sga_target_advice wher
e inst_id = userenv('instance')
1gxfv64zt0f56
select inst_id,          kqlfxpl_phad,          kqlfxpl_hash,          kqlfxpl_s
qlid,          kqlfxpl_plhash,          kqlfxpl_hadd,          kqlfxpl_chno,
      kqlfxpl_timestamp,          substr(kqlfxpl_oper, 1, 30),          substr(k
qlfxpl_oopt, 1, 30),          substr(kqlfxpl_tqid, 1, 40),          to_number(de
code(kqlfxpl_objn, 0, NULL, kqlfxpl_objn)),          kqlfxpl_objowner,
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
              kqlfxpl_objname,                         kqlfxpl_alias,
                substr(kqlfxpl_objtype, 1, 20),          substr(kqlfxpl_opti, 1,
 20),          kqlfxpl_opid,          to_number(decode(kqlfxpl_opid, 0, NULL, kq
lfxpl_paid)),          kqlfxpl_depth,          to_number(decode(kqlfxpl_pos, 0,
                          decode(kqlfxpl_cost, 4294967295, NULL,
                   kqlfxpl_cost),                           kqlfxpl_pos)),
    kqlfxpl_scols,          to_number(decode(kqlfxpl_cost, 4294967295, NULL,
                       kqlfxpl_cost)),
cb294yybsngtb
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select inst_id,kglnaobj,kglfnobj,kglobt03, kglobhs0+kglobhs1+kglobhs2+kglobhs3+k
globhs4+kglobhs5+kglobhs6+kglobt16, kglobt08+kglobt11, kglobt10, kglobt01, decod
e(kglobhs6,0,0,1), decode(kglhdlmd,0,0,1), kglhdlkc, kglobt04, kglobt05, kglobt4
8, kglobt35, kglobpc6, kglhdldc, substr(to_char(kglnatim,'YYYY-MM-DD/HH24:MI:SS'
),1,19), kglhdivc, kglobt12, kglobt13, kglobwdw, kglobt14, kglobwap, kglobwcc, k
globwcl, kglobwui, kglobt42, kglobt43, kglobt15, kglobt02, decode(kglobt32,
   0, 'NONE',        1, 'ALL_ROWS',        2, 'FIRST_ROWS',        3, 'RULE',
     4, 'CHOOSE',           'UNKNOWN'), kglobtn0, kglobcce, kglobcceh, kglobt17,
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 kglobt18, kglobts4, kglhdkmk, kglhdpar, kglobtp0, kglnahsh, kglobt46, kglobt30,
 kglobt09, kglobts5, kglobt48, kglobts0, kglobt19, kglobts1, kglobt20, kglobt21,
 kglobts2, kglobt06, kglobt07, decode(kglobt28, 0, to_number(NULL), kglobt28), k
glhdadr, kglobt29, decode(bitand(kglobt00,64),64, 'Y', 'N'), decode(kglobsta,
     1, 'VALID',        2, 'VALID_AUTH_E
bb162j634whf5
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
f8pavn1bvsj7t
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select  SQL_TEXT , SQL_FULLTEXT , SQL_ID,  SHARABLE_MEM , PERSISTENT_MEM , RUNTI
ME_MEM , SORTS , LOADED_VERSIONS , OPEN_VERSIONS , USERS_OPENING , FETCHES , EXE
CUTIONS , PX_SERVERS_EXECUTIONS , END_OF_FETCH_COUNT, USERS_EXECUTING , LOADS ,
FIRST_LOAD_TIME, INVALIDATIONS, PARSE_CALLS , DISK_READS , DIRECT_WRITES , BUFFE
R_GETS , APPLICATION_WAIT_TIME, CONCURRENCY_WAIT_TIME, CLUSTER_WAIT_TIME, USER_I
O_WAIT_TIME, PLSQL_EXEC_TIME, JAVA_EXEC_TIME, ROWS_PROCESSED , COMMAND_TYPE , OP
TIMIZER_MODE , OPTIMIZER_COST, OPTIMIZER_ENV, OPTIMIZER_ENV_HASH_VALUE, PARSING_
USER_ID , PARSING_SCHEMA_ID , PARSING_SCHEMA_NAME, KEPT_VERSIONS , ADDRESS , TYP
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
E_CHK_HEAP , HASH_VALUE, OLD_HASH_VALUE, PLAN_HASH_VALUE, CHILD_NUMBER, SERVICE,
 SERVICE_HASH, MODULE, MODULE_HASH , ACTION , ACTION_HASH ,  SERIALIZABLE_ABORTS
 , OUTLINE_CATEGORY, CPU_TIME, ELAPSED_TIME, OUTLINE_SID, CHILD_ADDRESS, SQLTYPE
, REMOTE, OBJECT_STATUS, LITERAL_HASH_VALUE, LAST_LOAD_TIME, IS_OBSOLETE, CHILD_
LATCH, SQL_PROFILE, PROGRAM_ID, PROGRAM_
bb44z0rhssjar
select default$ from col$ where rowid=:1
47r1y8yn34jmj
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
update sys.scheduler$_job set  next_run_date = :1, run_count = :2, retry_count =
 :3, running_instance = :4, running_slave = :5, job_status = :6, last_end_date =
 :7 where  obj# = :8
2g9qjuvr2hju9
select u.name, o.name, a.interface_version#, o.obj#      from association$ a, us
er$ u, obj$ o                     where a.obj# = :1
             and a.property = :2                                      and a.stat
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
stype# = o.obj#                                and u.user# = o.owner#
2syvqzbxp4k9z
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 f
rom obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null an
d linkname is null and subname is null
04xtrk7uyhknh
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 f
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
rom obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null an
d linkname is null and subname is null
04xtrk7uyhknh
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 f
rom obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null an
d linkname is null and subname is null
04xtrk7uyhknh

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select user#,type# from user$ where name=:1
5wc2915k44m38
insert into wrh$_sga_target_advice   (snap_id, dbid, instance_number,    SGA_SIZ
E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS)  select    :snap_id, :dbi
d, :instance_number,    SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R
EADS  from    v$sga_target_advice
bunssq950snhf

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_N
AME = 'DROP_USER'
d8mayxqw0wnpv
SELECT TRIM(METRIC_NAME) FROM MGMT_METRICS WHERE METRIC_GUID = :B1
fsm2qvmrhnp6u
insert into wrh$_log        (snap_id, dbid, instance_number, group#, thread#,
      sequence#, bytes, members, archived,         status, first_change#, first_
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
time)   select :snap_id, :dbid, :instance_number,          group#, thread#, sequ
ence#, bytes,          members, archived, status, first_change#, first_time
from v$log
f318xdxdn0pdc
update sys.col_usage$ set   equality_preds    = equality_preds    + decode(bitan
d(:flag,1),0,0,1),   equijoin_preds    = equijoin_preds    + decode(bitand(:flag
,2),0,0,1),   nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0
,1),   range_preds       = range_preds       + decode(bitand(:flag,8),0,0,1),
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
like_preds        = like_preds        + decode(bitand(:flag,16),0,0,1),   null_p
reds        = null_preds        + decode(bitand(:flag,32),0,0,1),  timestamp = :
time where obj# = :objn and intcol# = :coln
3c1kubcdjnppq
select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.
pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.o
bj# = :1 order by l.intcol# asc
6qz82dptj0qr7
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis
ts,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) fro
m seg$ where ts#=:1 and file#=:2 and block#=:3
2ym6hhaq30r73
select a.sql_text from v$sqltext a where (a.hash_value,a.address) in ( select de
code (sql_hash_value,0,prev_hash_value,sql_hash_value), decode (sql_hash_value,0
,prev_sql_addr,sql_address) from v$session b where b.paddr=(select addr from v$p
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
rocess c where c.spid='5923')) order by piece asc
aw4nshw930r9r
DELETE FROM RECENT_RESOURCE_INCARNATIONS$ WHERE DB_UNIQUE_NAME <> :B2 OR DB_DOMA
IN <> :B1
8un1u4spqwrn1
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=
:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
4m7m0t6fjcs5x
select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ wher
e obj#=:1 and part=:2 and version=:3 order by piece#
cvn54b7yz0s8u
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n
ext_date < :2))    or  ((last_date is null) and (next_date < :3))) and (field1 =
 :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, jo
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
b
803b7z0t84sq7
SELECT DECODE(METRIC_TYPE, 6, 0, 7, 1, METRIC_TYPE), METRIC_GUID, METRIC_LABEL,
COLUMN_LABEL FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND
 METRIC_COLUMN = :B1
b9yqu954vwt73
select o.obj#, t.flags from tab$ t, obj$ o, user$ u where  u.user# = :1 and u.us
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
er# = o.owner# and o.name = :2 and o.obj# = t.obj#
52kfqq6q4ntj5
select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc
f3g84j69n0tjh
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#
,o.flags from obj$ o where o.obj#=:1
5ngzsfstg8tmy
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select distinct inst_id, mttr_v,                                         decode(
status, 0, 'OFF', 4, 'ON', 'READY'),                              decode(dirty_l
imit, 0, to_number(NULL), dirty_limit),                    decode(factored_sim_w
rites, -1, to_number(NULL), factored_sim_writes),   decode(base_real_nondirect_w
rites, 0, to_number(NULL),                          decode(factored_sim_writes,
-1, to_number(NULL),                                round((factored_sim_writes /
 base_real_nondirect_writes),                      4))),
                        decode(total_writes, -1, to_number(NULL), total_writes),
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
                 decode(base_total_writes, 0, to_number(NULL),
                 decode(total_writes, -1, to_number(NULL),
                 round((total_writes / base_total_writes), 4))),            deco
de(total_ios, -1, to_number(NULL), total_ios),                       decode(base
_total_ios, 0, to_number(NULL),
57b02428xnu9f
SELECT snap_id , SQL_ID FROM   (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.sn
ap_id , t1.SQLID_KEWRSIE  SQL_ID FROM X$KEWRSQLIDTAB t1, WRH$_SQL_BIND_METADATA
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
t2      WHERE t2.dbid(+)  = :dbid  AND t2.SQL_ID(+) = t1.SQLID_KEWRSIE AND t2.PO
SITION(+) = 1) WHERE nvl(snap_id, 0) < :snap_id
bv35bq4sdcuf1
select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause
,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,rowid from
trigger$ where obj# =:1
5tfb2qxbtwujg

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
UPDATE MGMT_METRIC_THRESHOLDS SET NUM_WARNINGS = :B4 , NUM_CRITICALS = :B3 WHERE
 METRIC_GUID = :B2 AND KEY_VALUE = :B1
d1t1qk6thsvw9
UPDATE MGMT_METRIC_THRESHOLDS SET NUM_WARNINGS = :B4 , NUM_CRITICALS = :B3 WHERE
 METRIC_GUID = :B2 AND KEY_VALUE = :B1
d1t1qk6thsvw9
SELECT snap_id , SQL_ID, PLAN_HASH_VALUE FROM   (SELECT /*+ ordered use_nl(t2) i
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
ndex(t2) */ t2.snap_id , t1.SQLID_KEWRSPE  SQL_ID, t1.PLANHASH_KEWRSPE  PLAN_HAS
H_VALUE FROM X$KEWRTSQLPLAN t1, WRH$_SQL_PLAN t2      WHERE t2.dbid(+)  = :dbid
 AND t2.SQL_ID(+) = t1.SQLID_KEWRSPE AND t2.PLAN_HASH_VALUE(+) = t1.PLANHASH_KEW
RSPE AND t2.ID(+) = 0) WHERE nvl(snap_id, 0) < :snap_id
aq1vwa734ww0j
SELECT * FROM V$SQL
6vfrwcuaqhwwx

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),ro
wid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1
a73wbv1yu8x5c
select shared_pool_size_for_estimate s,          shared_pool_size_factor * 100 f
,          estd_lc_load_time l, 0             from v$shared_pool_advice
772s25v1y0x8k
update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2,  next_dat
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
e = greatest(:3, sysdate),  total=total+(sysdate-nvl(this_date,sysdate)) where j
ob=:4
47a50dvdgnxc2
select max(procedure#) from procedureplsql$ where obj#=:1
2xgubd6ayhyb1
select max(procedure#) from procedureplsql$ where obj#=:1
2xgubd6ayhyb1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
SELECT /*+ RULE */ STATUS, EXECUTION_ID FROM MGMT_JOB_EXEC_SUMMARY E WHERE STATU
S IN (:B2 , :B1 ) AND SUSPEND_TIMEOUT > 0 AND (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP
) AS DATE)-SUSPEND_TIME) > (SUSPEND_TIMEOUT/(24*60))
6nf6bgxvghzq9
UPDATE WRH$_OPTIMIZER_ENV SET snap_id = :lah_snap_id  WHERE dbid = :dbid    AND
(OPTIMIZER_ENV_HASH_VALUE) IN (SELECT NUM1_KEWRATTR FROM X$KEWRATTRSTALE)
a44d3zpqvt12z
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
SELECT NVL(AVG((VALUE*1000.0)/DURATION),0), NVL((((SUM(DURATION)/(60*1000))/60)*
100),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 =
 B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.
IS_TOTAL='Y' AND A.DURATION > 0
fcb5u7n0r523m
SELECT /*+ RULE */ STEP_ID FROM MGMT_JOB_EXECUTION E, MGMT_JOB J WHERE E.JOB_ID=
J.JOB_ID AND STEP_STATUS IN (:B6 , :B5 , :B4 , :B3 , :B2 ) AND STEP_TYPE=:B1 AND
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 J.EXECUTION_TIMEOUT > 0 AND (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE)-E.STAR
T_TIME) > (J.EXECUTION_TIMEOUT/24)
3z6cvmt9w5292
select ADDRESS, HASH_VALUE, SQL_ID, CHILD_ADDRESS,                 CHILD_NUMBER,
 NAME,                                                        POSITION, DUP_POSI
TION, DATATYPE, DATATYPE_STRING,                         CHARACTER_SID, PRECISIO
N, SCALE, MAX_LENGTH, WAS_CAPTURED,                 LAST_CAPTURED, VALUE_STRING,
 VALUE_ANYDATA                          from go$sql_bind_capture
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
                                   where inst_id = USERENV('Instance')
32wu055d4t2tg
SELECT NVL(TO_CHAR(MAX(B.OCCUR_DATE), 'Mon DD, YYYY HH:MI:SS AM'),'No errors') F
ROM MGMT_PERFORMANCE_NAMES A, MGMT_SYSTEM_ERROR_LOG B WHERE A.JOB_NAME = B.MODUL
E_NAME(+) AND LOG_LEVEL = :B2 AND :B1 = A.DISPLAY_NAME AND B.OCCUR_DATE > SYSDAT
E - 1
fgrptggxq9307

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B
1
c8h3jdwaa532q
select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 =
 0 and 'Y' = :3))
f9u3p2bz694dd
SELECT /*+ opt_param('parallel_execution_enabled', 'false') */
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
      /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, objec
t_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition
_start, partition_stop, object_node, other_tag, distribution, null, access_predi
cates, filter_predicates, other, null, null, other_xml, null, null, null, null,
null, null, null,                         null, null, null, null, null, null, nu
ll, null, null from (select /*+ no_merge */                            id, depth
, position, operation, options,                           cost, time, cardinalit
y, bytes, object_node,                           object_name, other_tag, partiti
on_start,                           partition_stop, distribution, temp_space, io
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
_cost,                           cpu_cost, filter_predicates, access_predicates,
 other,                           projection, qblock_name, object_alias, other_x
ml,  0 starts, 0 outrows, 0 crgets, 0 cu
brsm03vgrj4qv
select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled  from obj$ o,us
er$ u,trigger$ t  where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user#
and bitand(property,16)=0 and bitand(property,8)=0  order by o.obj#
fasvw7q199577
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled  from obj$ o,us
er$ u,trigger$ t  where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user#
and bitand(property,16)=0 and bitand(property,8)=0  order by o.obj#
fasvw7q199577
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(proper
ty,0),subname,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#
(+) order by order#
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
cqgv56fmuj63x
SELECT snap_id , SQL_ID FROM   (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.sn
ap_id , t1.SQLID_KEWRSIE  SQL_ID FROM X$KEWRSQLIDTAB t1, WRH$_SQLTEXT t2      WH
ERE t2.dbid(+)  = :dbid  AND t2.SQL_ID(+) = t1.SQLID_KEWRSIE) WHERE nvl(snap_id,
 0) < :snap_id
dbycq2n43t7n5
select max(procedure#) from procedurec$ where obj#=:1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
8wutkrpf8j81q
select max(procedure#) from procedurec$ where obj#=:1
8wutkrpf8j81q
select  INSTANCE_NUMBER , INSTANCE_NAME , HOST_NAME , VERSION , STARTUP_TIME , S
TATUS , PARALLEL , THREAD# , ARCHIVER , LOG_SWITCH_WAIT , LOGINS , SHUTDOWN_PEND
ING, DATABASE_STATUS, INSTANCE_ROLE, ACTIVE_STATE, BLOCKED from GV$INSTANCE wher
e inst_id = USERENV('Instance')
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
5r4jv9ywsx8gh
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(sc
ale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,s
cale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,proper
ty, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ wh
ere obj#=:1 order by intcol#
83taa7kaw59c1

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select map.inst_id, map.extid, map.sname, sysv.kewsval  from x$kewssmap map, x$k
ewssysv sysv  where map.offst = sysv.indx and map.aggid = 1 and  (map.stype = 2
or map.stype = 3)
4wvm9d0mvp9jh
SELECT PLAN_TABLE_OUTPUT FROM TABLE(CAST(DBMS_XPLAN.PREPARE_RECORDS(:B1 , :B2 )
AS SYS.DBMS_XPLAN_TYPE_TABLE))
g3f3cw3zy5aat

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
DELETE FROM MGMT_JOB_EMD_STATUS_QUEUE
6t7007dkc1abh
select  THREAD# , STATUS , ENABLED , GROUPS , INSTANCE , OPEN_TIME , CURRENT_GRO
UP# , SEQUENCE# , CHECKPOINT_CHANGE# , CHECKPOINT_TIME , ENABLE_CHANGE# , ENABLE
_TIME , DISABLE_CHANGE# , DISABLE_TIME, LAST_REDO_SEQUENCE#, LAST_REDO_BLOCK, LA
ST_REDO_CHANGE#, LAST_REDO_TIME from GV$THREAD where inst_id = USERENV('Instance
')
bkfdm19n1dauk
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
insert into sys.col_usage$ values (   :objn, :coln,   decode(bitand(:flag,1),0,0
,1),   decode(bitand(:flag,2),0,0,1),   decode(bitand(:flag,4),0,0,1),   decode(
bitand(:flag,8),0,0,1),   decode(bitand(:flag,16),0,0,1),   decode(bitand(:flag,
32),0,0,1),   :time)
53btfq0dt9bs9
DELETE FROM RECENT_RESOURCE_INCARNATIONS$ WHERE RESOURCE_TYPE = 'INSTANCE' AND R
ESOURCE_NAME = :B4 AND DB_UNIQUE_NAME = :B3 AND DB_DOMAIN = NVL(:B2 , '==N/A==')
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 AND STARTUP_TIME < SYS_EXTRACT_UTC(:B1 )
6902r7gvu1c5p
select scheduler$_instance_s.nextval from dual
1m590r6adtcrv
select count(*) from resource_group_mapping$ where attribute = :1 and status = '
ACTIVE'
3fvb5afth9g3n
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select ownername,classname,methodname,signature,flags from procedurejava$ where
obj#=:1 and procedure#=:2 order by procedure#
83cq1aqjw5gmg
SELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP > (HEARTB
EAT_INTERVAL*4)/(24*60*60)
cchx5kcx6tgmz

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select INST_ID,                 KQLFBC_PADD,                 KQLFBC_HASH,
          KQLFBC_SQLID,                 KQLFBC_CADD,                 KQLFBC_CHNO
,                 substr(KQLFBC_NAME, 1, 30),                 KQLFBC_POS,
          to_number(decode(KQLFBC_DUPPOS, 65535, NULL, KQLFBC_DUPPOS)),
        KQLFBC_OACDTY,                 substr(KQLFBC_DTYSTR, 1, 15),
     decode(KQLFBC_OACCSI, 0, to_number(null), KQLFBC_OACCSI),                 d
ecode(KQLFBC_OACPRE, 0, to_number(null), KQLFBC_OACPRE),                  decode
(KQLFBC_OACSCL, 0, to_number(null), KQLFBC_OACSCL),                  KQLFBC_OACM
XL,                 decode(KQLFBC_WCAP, 0, 'NO', 'YES'),                 decode(
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
KQLFBC_WCAP, 0, to_date(NULL), KQLFBC_LCAP),                 KQLFBC_STRVAL,
             decode(KQLFBC_WCAP, 0, NULL,                                      s
ys.sys$rawtoany(KQLFBC_BINVAL, KQLFBC_OACDTY,
     KQLFBC_OACCSF, KQLFBC_OACCSI))
cxvtjxwj0xgrb
select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, de
finitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextp
ct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(t
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
runc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpar
tcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# =
:1
8hd36umbhpgsz
select intcol#, col# , type#, spare1, segcol#, charsetform from partcol$  where
obj# = :1 order by pos#
cbdfcfcp1pgtp

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
LOCK TABLE RECENT_RESOURCE_INCARNATIONS$ IN EXCLUSIVE MODE
6nusggcc7jhcu
SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ extractvalue(xmlv
al, '/*/info[@type = "sql_profile"]'), extractvalue(xmlval, '/*/info[@type = "ou
tline"]'), extractvalue(xmlval, '/*/info[@type = "dynamic_sampling"]'), extractv
alue(xmlval, '/*/info[@type = "index_size"]'), extractvalue(xmlval,'/*/info[@typ
e = "plan_hash"]') from (select xmltype(:v_other_xml) xmlval from dual)
035rdsw0h9hfk
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select sum(SYSDATE - cast(NVL(qt.delay, qt.enq_time) as date))  from   "SYSMAN".
"MGMT_NOTIFY_QTABLE" qt, "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_I" iot  where  ((iot.s
ubscriber# != 0 and           iot.subscriber# in (select subscriber_id
                     from   "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S"
              where  queue_name = :1 and (bitand(subscriber_type, 1) = 1)))
    or (iot.subscriber# = 0 and iot.queue# = :2)) and          qt.msgid = iot.ms
gid
gd5vqxjfdthks
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select sum(SYSDATE - cast(NVL(qt.delay, qt.enq_time) as date))  from   "SYSMAN".
"MGMT_NOTIFY_QTABLE" qt, "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_I" iot  where  ((iot.s
ubscriber# != 0 and           iot.subscriber# in (select subscriber_id
                     from   "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S"
              where  queue_name = :1 and (bitand(subscriber_type, 1) = 1)))
    or (iot.subscriber# = 0 and iot.queue# = :2)) and          qt.msgid = iot.ms
gid
gd5vqxjfdthks
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select procedure#,ownerlength,classlength,methodlength,siglength, flagslength,co
okiesize from procedurejava$ where obj#=:1 order by procedure#
5j4c2v06qdhqq
select procedure#,ownerlength,classlength,methodlength,siglength, flagslength,co
okiesize from procedurejava$ where obj#=:1 order by procedure#
5j4c2v06qdhqq

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select ADDRESS, HASH_VALUE, SQL_ID, PLAN_HASH_VALUE, CHILD_ADDRESS,          CHI
LD_NUMBER,  TIMESTAMP, OPERATION,                                         OPTION
S, OBJECT_NODE, OBJECT#, OBJECT_OWNER, OBJECT_NAME,                    OBJECT_AL
IAS, OBJECT_TYPE, OPTIMIZER,                                        ID, PARENT_I
D, DEPTH, POSITION, SEARCH_COLUMNS, COST, CARDINALITY,           BYTES, OTHER_TA
G, PARTITION_START, PARTITION_STOP, PARTITION_ID,             OTHER, DISTRIBUTIO
N, CPU_COST, IO_COST, TEMP_SPACE,                          ACCESS_PREDICATES, FI
LTER_PREDICATES, PROJECTION, TIME, QBLOCK_NAME,         REMARKS, OTHER_XML
                                                     from GV$SQL_PLAN
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
                                                  where inst_id = USERENV('Insta
nce')
853rcj6s59jtk
select TABLESPACE_NAME,sum(bytes/1024/1024) MB from dba_data_files group by TABL
ESPACE_NAME
ajru4r5m2djwt
SELECT A.TARGET_NAME, A.TARGET_TYPE FROM MGMT_TARGETS A, MGMT_CURRENT_AVAILABILI
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
TY B WHERE A.TARGET_GUID = B.TARGET_GUID AND B.CURRENT_STATUS = :B3 AND A.TARGET
_TYPE NOT IN (:B2 , :B1 ) AND A.LAST_LOAD_TIME < ((SYSDATE - ((TO_NUMBER(TO_CHAR
(SYSTIMESTAMP, 'TZH'))* 60 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP, 'TZM'))) / (24 * 60
)) + (A.TIMEZONE_DELTA / (24 * 60))) - 1 / 12)
bdy1u1u231m7b
select sql_text,SQL_ID from v$sql
36pvuugzz5m8d

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select decode(bitand(a.flags, 16384), 0, a.next_run_date,                a.last_
enabled_time),         a.obj#, decode(bitand(a.flags, 16384), 0, 0, 1)  from sys
.scheduler$_job a  where bitand(a.job_status, 3) = 1    and ((bitand(a.flags, 13
4217728 + 268435456) = 0) or         (bitand(a.job_status, 1024) <> 0))    and b
itand(a.flags, 4096) = 0    and a.class_oid is not null    and a.class_oid in (s
elect b.obj# from sys.scheduler$_class b                        where bitand(b.f
lags, :1) <> 0 and b.affinity = :2)    and decode(bitand(a.flags, 16384), 0, a.n
ext_run_date,                a.last_enabled_time) =  (select min(decode(bitand(c
.flags, 16384), 0, c.next_run_date,             c.last_enabled_time))   from sys
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
.scheduler$_job c  where bitand(c.job_status, 3) = 1    and ((bitand(c.flags, 13
4217728 + 268435456) = 0) or         (bitand(c.job_status, 1024) <> 0))    and b
itand(c.flags, 4096) = 0    and c.class_oid is not null    and c.class_oid in (s
elect d.obj# from sys.scheduler$_class d
c9rhad6z3xmhx
INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KE
Y_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 , NULL)
2txg6sm725mn6
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
SELECT COUNT(BROKEN) FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEV
ERITIES'
2rq8p9b3f1n82
BEGIN  dbms_ha_alerts_prvt.clear_instance_resources(   :dbdomain, :dbuniquename,
 :instance_name, :event_time);END;
6mqvntr9ytnga

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ w
here obj#=:1 and part=:2 and version=:3 order by piece#
c6awqs517jpj0
SELECT NVL(AVG(VALUE) ,0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME='Notif
ication Delivery' AND NAME='Delivery Time' AND TIME>(SYSDATE-(1/24))
1t0vfvhmyjq5c
update wrm$_snapshot set status = 0,      flush_elapsed =         greatest((cast
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
(SYSDATE as TIMESTAMP) - end_interval_time),                 interval '00.10' se
cond)  where snap_id = :snap_id and dbid = :dbid and      instance_number = :ins
tance_number
5ms1dhxbadq64
select count(*) from vtable$ where obj#=:1
8r5sp8cjcpqan
UPDATE WRH$_SQLTEXT SET snap_id = :lah_snap_id  WHERE dbid = :dbid    AND (SQL_I
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
D) IN (SELECT STR1_KEWRATTR FROM X$KEWRATTRSTALE)
8dqa7bn175qhu
select  tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay,   tab.expirat
ion, tab.retry_count, tab.exception_qschema,   tab.exception_queue, tab.chain_no
, tab.local_order_no, tab.enq_time,   tab.time_manager_info, tab.state, tab.enq_
tid, tab.step_no,   tab.sender_name, tab.sender_address, tab.sender_protocol,
tab.dequeue_msgid, tab.user_prop, tab.user_data  from "SYS"."ALERT_QT" tab  wher
e msgid = :1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
a1u69wxgrjqmq
select mttr_target_for_estimate, advice_status, dirty_limit,            estd_cac
he_writes, estd_cache_write_factor, estd_total_writes,          estd_total_write
_factor,                                                estd_total_ios, estd_tot
al_io_factor from gv$mttr_target_advice         where inst_id = userenv('instanc
e')
fvfu1q214xrk5

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select sum(used_blocks), ts.ts#   from GV$SORT_SEGMENT gv, ts$ ts   where gv.tab
lespace_name = ts.name and   ts.bitmapped  <> 0   group by ts.ts#
a1xgxtssv5rrp
SELECT T.WARNING_OPERATOR, T.WARNING_THRESHOLD, T.CRITICAL_OPERATOR, T.CRITICAL_
THRESHOLD, T.NUM_OCCURENCES, T.NUM_WARNINGS, T.NUM_CRITICALS, T.MESSAGE, T.MESSA
GE_NLSID FROM MGMT_METRIC_THRESHOLDS T WHERE T.TARGET_GUID = :B4 AND T.METRIC_GU
ID = :B3 AND T.COLL_NAME = :B2 AND T.KEY_VALUE = :B1
gx1h998ck9sg6
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property,i.pct
free$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey,i.dblkkey,i.
clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.insta
nces,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),n
vl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,spare2,spare6, de
code(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (selec
t enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(t
o_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1 order by i.obj#
bkdusjx00dsmc
select audit$ from library$ where obj#=:1
grzuvf0hjxt1f
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 a
nd intcol#=:2 and row#=:3 order by bucket
db78fxqxwxt7r
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select procedure#,entrypoint# from procedureplsql$ where obj#=:1 order by proced
ure#
bgjhtnqhr5u9h
select procedure#,entrypoint# from procedureplsql$ where obj#=:1 order by proced
ure#
bgjhtnqhr5u9h

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select STAT_NAME, VALUE, OSSTAT_ID from GV$OSSTAT where INST_ID = USERENV('Insta
nce')
f1s9nsrufxuyj
select rt.inst_id,rtnum,decode(bitand(rtsta,1),1,'OPEN','CLOSED'), decode(bitand
(rtsta,6),0,'DISABLED',2,'PRIVATE',6,'PUBLIC','UNKNOWN'), rtnlf,tirsid,to_date(r
tots,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'), rtcln,rtseq, to_number(rtc
kp_scn), to_date(rtckp_tim,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'), to_n
umber(rtenb), to_date(rtets,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'), to_
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
number(rtdis), to_date(rtdit,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'), cp
odr_seq, cpodr_bno, to_number(cpods), to_date(cpodt,'MM/DD/RR HH24:MI:SS','NLS_C
ALENDAR=Gregorian') from x$kccrt rt, x$kcctir tr, x$kcccp  where rtnlf != 0 and
tr.inst_id = rt.inst_id  and tirnum = rtnum and cptno = rtnum
5nssv56vu1v42
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ w
here obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
2q93zsrvbdw48
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING wh
ere reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instanc
e_number = :4
c4nhd1ntptxq7
select sysdate + 1 / (24 * 60) from dual
dwssdqx28tzf5

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
SELECT NVL(AVG(VALUE),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME=:B2 AND
 NAME=:B1 AND TIME>(SYSDATE-(1/24))
2wuxsvgst612h
select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags f
rom seq$ where obj#=:1
axmdf8vq7k1rh
begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
d92h3rjp0y217
alter session set NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CU
RRENCY='?' NLS_ISO_CURRENCY='CHINA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT=
'DD-MON-RR' NLS_DATE_LANGUAGE='SIMPLIFIED CHINESE' NLS_SORT='BINARY'
2zfpntzghu3wz
select u1.user#, u2.user#, u3.user#, failures, flag, interval#,    what, nlsenv,
 env, field1  from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3  where j
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
ob=:1 and (next_date < sysdate or :2 != 0)  and lowner = u1.name and powner = u2
.name and cowner = u3.name
7s7a79nsaf4j7
select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1
6769wyy3yf66f
select text from view$ where rowid=:1
grwydz59pu6mc
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select owner# from obj$ o where obj# = :1
483fv5088f6p4
select owner# from obj$ o where obj# = :1
483fv5088f6p4
select obj#, dataobj#, part#, hiboundlen, hiboundval, flags, ts#, file#, block#,
 pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt,
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 distkey, lblkkey, dblkkey, clufac, pctthres$, length(bhiboundval), bhiboundval
from indpart$ where bo# = :1 order by part#
c3zymn7x3k6wy
insert into wrh$_thread     (snap_id, dbid, instance_number,      thread#, threa
d_instance_number, status,      open_time, current_group#, sequence#)  select
   :snap_id, :dbid, :instance_number,      t.thread#, i.instance_number, t.statu
s,      t.open_time, t.current_group#, t.sequence#  from v$thread t, v$instance
i  where i.thread#(+) = t.thread#
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
71y370j6428cb
select /* EXEC_FROM_DBMS_XPLAN */ rtrim(sql_text)                           from
 v$sql where SQL_ID=:v_sql_id                                      and child_num
ber=:v_child_number
du2u5hgh368qt
select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ wher
e obj#=:1 and part=:2 and version=:3 order by piece#
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
ga9j9xk5cy9s0
SELECT UNIQUE(TARGET_GUID) FROM MGMT_METRIC_DEPENDENCY WHERE CAN_CALCULATE = 1 A
ND DISABLED = 0
7gnakyxnvaadf
SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
089dbukv1aanh

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select count (*), state from "SYSMAN"."MGMT_NOTIFY_QTABLE"  where q_name = :1 gr
oup by state
3s5hsyrq4fb38
INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTIO
N, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SU
BSTR(:B7 , 1, 512), SUBSTR(:B6 ,1,32), :B5 , SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,1
28), SUBSTR(:B2 ,1,128), SUBSTR(:B1 ,1,256))
18naypzfmabd6
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select ks.inst_id,ksuxsins,ksuxssid,ksuxshst,ksuxsver,ksuxstim,decode(ksuxssts,0
,'STARTED',1,'MOUNTED',2,'OPEN',3,'OPEN MIGRATE','UNKNOWN'),decode(ksuxsshr,0,'N
O',1,'YES',2,NULL),ksuxsthr,decode(ksuxsarc,0,'STOPPED',1,'STARTED','FAILED'),de
code(ksuxslsw,0,NULL,2,'ARCHIVE LOG',3,'CLEAR LOG',4,'CHECKPOINT',       5,'REDO
 GENERATION'),decode(ksuxsdba,0,'ALLOWED','RESTRICTED'),decode(ksuxsshp,0,'NO','
YES'),decode(kvitval,0,'ACTIVE',2147483647,'SUSPENDED','INSTANCE RECOVERY'),deco
de(ksuxsrol,1,'PRIMARY_INSTANCE',2,'SECONDARY_INSTANCE','UNKNOWN'), decode(qui_s
tate,0,'NORMAL',1,'QUIESCING',2,'QUIESCED','UNKNOWN'), decode(bitand(ksuxsdst, 1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
), 0, 'NO', 1, 'YES', 'NO') from x$ksuxsinst ks, x$kvit kv, x$quiesce qu where k
vittag = 'kcbwst'
3nhfzxjzx2btx
select java_pool_size_for_estimate, java_pool_size_factor,  estd_lc_size, estd_l
c_memory_objects, estd_lc_time_saved,  estd_lc_time_saved_factor, estd_lc_load_t
ime,  estd_lc_load_time_factor, estd_lc_memory_object_hits  from gv$java_pool_ad
vice where inst_id = USERENV('Instance')
3zmw1wxrvfckx
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select count(*)  from   "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_I"  where  (subscriber#
 != 0 and          subscriber# in (select subscriber_id
 from   "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S"                          where  queu
e_name = :1)) or         (subscriber# = 0 and queue# = :2)
ffcztr22hucp2
select count(*)  from   "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_I"  where  (subscriber#
 != 0 and          subscriber# in (select subscriber_id
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 from   "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S"                          where  queu
e_name = :1)) or         (subscriber# = 0 and queue# = :2)
ffcztr22hucp2
select audit$,properties from type_misc$ where obj#=:1
0m78skf1mudnb
insert into wrh$_comp_iostat   (SNAP_ID, DBID, INSTANCE_NUMBER, COMPONENT, FILE_
TYPE,    IO_TYPE, OPERATION, BYTES, IO_COUNT) select :snap_id, :dbid, :instance_
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
number, 'RMAN', 'DATAFILE',        is_sync, type, sum(bytes), sum(io_count) from
  (select decode(x.type, 1, 'READ', 'WRITE') as type,               case when (b
itand(x.flags, 2) = 0) then 'SYNC' else 'ASYNC'                    end as is_syn
c,               x.blocks * x.block_size as bytes,               case when (bita
nd(x.flags, 2) = 0)                    then (x.sync_count)                    el
se (x.async_short_count + x.async_long_count +                          x.async_
ready)                    end as io_count        from   x$ksfqp x, v$dbfile df
      where  x.type in (1,2)          and  df.name = x.filename) group by is_syn
c, type
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
3kjbw2svxydst
SELECT DISTINCT HOST_URL FROM MGMT_OMS_PARAMETERS WHERE NAME='TIMESTAMP'
auqc5yhb7ady2
insert into wrh$_sqlstat  (snap_id, dbid, instance_number,   sql_id, plan_hash_v
alue,   optimizer_cost, optimizer_mode, optimizer_env_hash_value,   sharable_mem
, loaded_versions, version_count,   module, action,   sql_profile, force_matchin
g_signature,   parsing_schema_id, parsing_schema_name,   fetches_total, fetches_
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
delta,   end_of_fetch_count_total, end_of_fetch_count_delta,   sorts_total, sort
s_delta,   executions_total, executions_delta,   px_servers_execs_total, px_serv
ers_execs_delta,   loads_total, loads_delta,   invalidations_total, invalidation
s_delta,   parse_calls_total, parse_calls_delta,   disk_reads_total, disk_reads_
delta,   buffer_gets_total, buffer_gets_delta,   rows_processed_total, rows_proc
essed_delta,   cpu_time_total, cpu_time_delta,   elapsed_time_total, elapsed_tim
e_delta,   iowait_total, iowait_delta,   clwait_total, clwait_delta,   apwait_to
tal, apwait_delta,   ccwait_total, ccwait_delta,   direct_writes_total, direct_w
rites_delta,   pl***ec_time_total, pl***
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
0sy05h3pw6f30
INSERT INTO wrh$_sql_plan sp         (snap_id, dbid, sql_id, plan_hash_value, id
,          operation, options, object_node, object#, object_owner,          obje
ct_name, object_alias, object_type,          optimizer, parent_id, depth, positi
on,          search_columns, cost, cardinality, bytes, other_tag,          parti
tion_start, partition_stop, partition_id, other,          distribution, cpu_cost
, io_cost, temp_space,          access_predicates, filter_predicates,          p
rojection, time, qblock_name, remarks, timestamp, other_xml)    SELECT /*+ order
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
ed use_nl(p) */ :lah_snap_id lsnid, :dbid dbid,           p.sql_id,           p.
plan_hash_value,           p.id,           p.operation,           p.options,
       p.object_node,           p.object#,           p.object_owner,           p
.object_name,           p.object_alias,           p.object_type,           p.opt
imizer,           p.parent_id,           p.depth,           p.position,
  p.search_columns,           p.cost,
9txzuppkuffg7
SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
B1
gfdn12rn0fg3m
SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :
B1
gfdn12rn0fg3m
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
AND COLLECTION_TIMESTAMP < :B3
91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3
91h2x42zqagcm
select audit$,options from procedure$ where obj#=:1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
b1wc53ddd6h3p
insert into wrh$_undostat   (begin_time, end_time, dbid, instance_number, snap_i
d, undotsn,    undoblks, txncount, maxquerylen, maxquerysqlid,    maxconcurrency
, unxpstealcnt, unxpblkrelcnt, unxpblkreucnt, expstealcnt,    expblkrelcnt, expb
lkreucnt, ssolderrcnt, nospaceerrcnt, activeblks,    unexpiredblks, expiredblks,
 tuned_undoretention, status,    spcprs_retention, runawayquerysqlid)  select
 to_date(ktusmstrbegtime,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),    to_
date(ktusmstrendtime,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),    max(:db
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
id), max(:instance_number), max(:snap_id),    max(KTUSMSTTSN), sum(KTUSMSTUSU),
sum(KTUSMSTTCT), max(KTUSMSTMQL),    max(KTUSMSTRMQI), max(KTUSMSTMTC),    sum(K
TUSMSTUAC), sum(KTUSMSTUBS), sum(KTUSMSTUBR),    sum(KTUSMSTXAC), sum(KTUSMSTXBS
), sum(KTUSMSTXBR),    sum(KTUSMSTSOC), sum(KTUSMSTOOS), max(KTUSMSTABK),    max
(KTUSMSTUBK), max(KTUSMSTEBK), max(KTUSMSTTUR), max(KTUSMSTFLG),    max(KTUSMSTS
PR), max(KTUSMSTRQSID)  from    X$KTUSMS
37m1fvjg52hqm
select cachedblk, cachehit, logicalread from ind_stats$ where obj#=:1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
dpvv2ua0tfjcv
select INST_ID,KSUCPUSTATNAME,  decode(KSUCPUSTATID,     15, KSUCPUSTATVALUE/102
4,         KSUCPUSTATVALUE), KSUCPUSTATID from X$KSUCPUSTAT union all select INS
T_ID,KSUVMSTATNAME,KSUVMSTATVALUE,KSUVMSTATID from X$KSUVMSTAT
afxwt0ay5ujsm
insert into "SYS"."ALERT_QT"  (q_name, msgid, corrid, priority, state, delay, ex
piration,   time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
uid,   enq_tid, retry_count, exception_qschema, exception_queue, recipient_key,
  dequeue_msgid, user_data, sender_name, sender_address, sender_protocol,   user
_prop, cscn, dscn)   values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12,
:13, :14, 0, :15,         :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
c0agatqzq2jzr
insert into sys.scheduler$_event_log  (log_id, log_date, type#, name, owner, ope
ration, status, user_name,   client_id, guid, additional_info, class_id)   value
s  (:1, SYSTIMESTAMP,   :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
d3z03a7y4um3d
INSERT INTO RECENT_RESOURCE_INCARNATIONS$ ( RESOURCE_TYPE, RESOURCE_ID, RESOURCE
_NAME, DB_UNIQUE_NAME, DB_DOMAIN, INSTANCE_NAME, HOST_NAME, STARTUP_TIME, LOCATI
ON, INCARNATION ) SELECT 'INSTANCE', INSTANCE_NUMBER, INSTANCE_NAME, :B2 , :B1 ,
 INSTANCE_NAME, HOST_NAME, SYS_EXTRACT_UTC( DBMS_HA_ALERTS_PRVT.INSTANCE_STARTUP
_TIMESTAMP_TZ(VI.STARTUP_TIME)), HOST_NAME, '==N/A==' FROM V$INSTANCE VI
32ss2fd6p2m4g

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
UPDATE MGMT_METRIC_COLLECTIONS SET STATUS_MESSAGE = :B6 || ' returned ' || :B5 |
| ' values', LAST_COLLECTED_TIMESTAMP = :B4 WHERE TARGET_GUID = :B3 AND METRIC_G
UID = :B2 AND COLL_NAME = :B1
48sdn419b6p2q
insert into wrh$_tablespace_space_usage      (snap_id, dbid, tablespace_id,
  tablespace_usedsize, tablespace_size, tablespace_maxsize, rtime)  select
:snap_id, :dbid,      KTTEFINFOTSN, sum(KTTEFINFOUSP), sum(KTTEFINFOSIZE),
sum(KTTEFINFOMSIZE), to_char(sysdate,'MM/DD/YYYY HH24:MI:SS')      from X$KTTEFI
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
NFO      group by KTTEFINFOTSN
dtj94u9jj2qj4
INSERT INTO wrh$_sqltext    (sql_id, dbid, sql_text,     command_type, snap_id,
ref_count)  SELECT    sqlid_kewrstx, :dbid, sqlfulltext_kewrstx,    cmdtype_kewr
stx, :lah_snap_id, 0 ref_count  FROM x$kewrtsqltext
cc3c5yr3y2rh1
SELECT INSTANCE_NAME, HOST_NAME, NVL(GVI_STARTUP_TIME, SYSTIMESTAMP) - INTERVAL
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
'1' SECOND AS SHUTDOWN_TIME FROM (SELECT RRI.INSTANCE_NAME AS INSTANCE_NAME, RRI
.HOST_NAME AS HOST_NAME, FROM_TZ(RRI.STARTUP_TIME, '+00:00') AS RRI_STARTUP_TIME
, DBMS_HA_ALERTS_PRVT.INSTANCE_STARTUP_TIMESTAMP_TZ(GVI.STARTUP_TIME) AS GVI_STA
RTUP_TIME FROM RECENT_RESOURCE_INCARNATIONS$ RRI LEFT OUTER JOIN GV$INSTANCE GVI
 ON GVI.INSTANCE_NAME = RRI.RESOURCE_NAME WHERE RRI.RESOURCE_TYPE = 'INSTANCE' A
ND :B2 = RRI.DB_UNIQUE_NAME AND :B1 = RRI.DB_DOMAIN) WHERE GVI_STARTUP_TIME IS N
ULL OR GVI_STARTUP_TIME > RRI_STARTUP_TIME GROUP BY INSTANCE_NAME, HOST_NAME, GV
I_STARTUP_TIME
92f47aa2q2rmd
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,c.precision#,c
.charsetid,c.charsetform from triggercol$ tc,col$ c ,trigger$ tr where tc.obj#=:
1 and c.obj#=:2 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.pr
operty,32) != 32 or bitand(tc.type#,20) = 20) union select type#,intcol#,positio
n#,69,0,0,0,0,0 from triggercol$ where obj#=:3 and intcol#=1001 union select tc.
type#,tc.intcol#,tc.position#,121,0,0,0,0,0 from triggercol$ tc,trigger$ tr wher
e tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and tc.obj# = :4 and bitand(
tc.type#,20) != 20
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
25326scp1asa4
select priority from resource_mapping_priority$ where attribute = :1 and status
= 'ACTIVE'
c2tnpdmt26t6b
SELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP
 < :B1 /(24*60*60)
34rks4d5suuxz
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intco
l# asc
32bhha21dkv0v
SELECT WHAT WHAT, NEXT_DATE NEXT_TIME, DECODE(BROKEN,'Y','DOWN','UP') BROKEN, NV
L(TO_CHAR(NEXT_DATE,'Mon DD, YYYY HH:MI:SS AM'),'Not Scheduled') SCHEDULED FROM
USER_JOBS
8f6trzfj56vqw
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
INSERT INTO MGMT_STRING_METRIC_HISTORY (TARGET_GUID, KEY_VALUE, COLLECTION_TIMES
TAMP, METRIC_GUID, STRING_VALUE) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 )
ccqcbrv0aywad
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1
53saa2zkr6wc3
select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltyp
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
e$ where obj#=:1 order by intcol# asc
9rfqm06xmuwu0
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf
ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl
ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance
s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(
c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,dec
ode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cac
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
hehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) un
icols,min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))
) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.ob
j#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7ng34ruy5awxq
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf
ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl
ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(
c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,dec
ode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cac
hehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) un
icols,min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))
) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.ob
j#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7ng34ruy5awxq

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf
ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl
ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance
s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(
c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,dec
ode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cac
hehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) un
icols,min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))
) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.ob
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
j#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7ng34ruy5awxq
select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(ty
pidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
7nuw4xwrnuwxq
insert into sys.scheduler$_job_run_details  (log_id, log_date, req_start_date, s
tart_date, run_duration,   instance_id, session_id, slave_pid, cpu_used, error#,
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 additional_info)   values  (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7,   numtods
interval(:8/100, 'second'), :9, :10)
cxjga3nv4kxa7
SELECT /*+ ORDERED */ A.READY FROM USER_QUEUES B, GV$AQ A WHERE B.NAME = 'MGMT_N
OTIFY_Q' AND A.QID = B.QID
1gc7umngbqyc1
SELECT T.WARNING_OPERATOR, T.WARNING_THRESHOLD, T.CRITICAL_OPERATOR, T.CRITICAL_
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
THRESHOLD, T.NUM_OCCURENCES, T.NUM_WARNINGS, T.NUM_CRITICALS, T.MESSAGE, T.MESSA
GE_NLSID FROM MGMT_METRIC_THRESHOLDS T WHERE T.TARGET_GUID = :B3 AND T.METRIC_GU
ID = :B2 AND T.COLL_NAME = :B1 AND T.KEY_VALUE = ' '
0h2dybf5yuz5r
SELECT T.WARNING_OPERATOR, T.WARNING_THRESHOLD, T.CRITICAL_OPERATOR, T.CRITICAL_
THRESHOLD, T.NUM_OCCURENCES, T.NUM_WARNINGS, T.NUM_CRITICALS, T.MESSAGE, T.MESSA
GE_NLSID FROM MGMT_METRIC_THRESHOLDS T WHERE T.TARGET_GUID = :B3 AND T.METRIC_GU
ID = :B2 AND T.COLL_NAME = :B1 AND T.KEY_VALUE = ' '
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
0h2dybf5yuz5r
insert into wrh$_osstat   (snap_id, dbid, instance_number, stat_id, value)  sele
ct    :snap_id, :dbid, :instance_number, osstat_id, value  from    v$osstat
13fnb572x6z9j
insert into wrh$_sys_time_model   (snap_id, dbid, instance_number, stat_id, valu
e)  select    :snap_id, :dbid, :instance_number, stat_id, value  from    v$sys_t
ime_model  order by    stat_id
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
13kwg458hfzfb
SELECT SEVERITY_CODE FROM MGMT_CURRENT_SEVERITY WHERE TARGET_GUID = :B2 AND METR
IC_GUID = :B1 AND KEY_VALUE = ' '
0xnpxdg26aznc
SELECT SEVERITY_CODE FROM MGMT_CURRENT_SEVERITY WHERE TARGET_GUID = :B2 AND METR
IC_GUID = :B1 AND KEY_VALUE = ' '
0xnpxdg26aznc
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
abtp0uqvdb1d3
UPDATE MGMT_TARGETS SET LAST_LOAD_TIME = :B1 WHERE TARGET_GUID = :B2 AND (LAST_L
OAD_TIME < :B1 OR LAST_LOAD_TIME IS NULL)
0sydc5jyrv1t4
select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o,  user$ u,
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
trigger$ where bitand(trigger$.property,16) = 16 and  trigger$.baseobject = :1
and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#
g73tzgnm4722f
UPDATE WRH$_SQL_BIND_METADATA SET snap_id = :lah_snap_id  WHERE dbid = :dbid
AND (SQL_ID) IN (SELECT STR1_KEWRATTR FROM X$KEWRATTRSTALE)
1wqf9a7q2v2d7
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#,
 grantee#
6aq34nj2zb2n7
select vindex,itypetoid,imethod#,iflags,itypeowner,itypename from vtable$ where
obj#=:1 order by vindex
f6xf2v1pw72ww
SELECT TARGET_NAME, TARGET_TYPE FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
6236swstvr33b
select order#,columns,types from access$ where d_obj#=:1
8swypbbr0m372
SELECT SEVERITY_CODE FROM MGMT_CURRENT_SEVERITY WHERE TARGET_GUID = :B3 AND METR
IC_GUID = :B2 AND KEY_VALUE = :B1
fg994r5g1r3mu

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select q.eventid, q.oid, t.schema, t.name, q.table_objno,         q.usage, t.uda
ta_type,  q.enable_flag,         q.max_retries, q.retry_delay, q.properties, q.r
et_time,         t.flags, t.sort_cols, q.memory_threshold, a.owner_instance,
     q.service_name, q.network_name, t.timezone  from system.aq$_queues q, syste
m.aq$_queue_tables t,       sys.aq$_queue_table_affinities a  where q.table_objn
o = t.objno and q.table_objno = a.table_objno  and t.schema= :1 and q.name= :2
cubcqrdcjb3mz
SELECT snap_id , OPTIMIZER_ENV_HASH_VALUE FROM   (SELECT /*+ ordered use_nl(t2)
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
index(t2) */ t2.snap_id , t1.OPTENVHV_KEWROEE  OPTIMIZER_ENV_HASH_VALUE FROM X$K
EWRTOPTENV t1, WRH$_OPTIMIZER_ENV t2      WHERE t2.dbid(+)  = :dbid  AND t2.OPTI
MIZER_ENV_HASH_VALUE(+) = t1.OPTENVHV_KEWROEE) WHERE nvl(snap_id, 0) < :snap_id
5n9u26z5jg3p1
select file# from file$ where ts#=:1
bsa0wjtftg3uw
lock table sys.col_usage$ in exclusive mode nowait
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
b2gnxm5z6r51n
SELECT S.SNAP_ID, S.BEGIN_INTERVAL, S.END_INTERVAL FROM (SELECT SS.SNAP_ID, CAST
(SS.BEGIN_INTERVAL_TIME AS DATE) AS BEGIN_INTERVAL, CAST(SS.END_INTERVAL_TIME AS
 DATE) AS END_INTERVAL FROM WRM$_SNAPSHOT SS WHERE SS.DBID = :B3 AND SS.INSTANCE
_NUMBER = :B2 AND SS.SNAP_ID <= :B1 ORDER BY SS.DBID, SS.INSTANCE_NUMBER, SS.SNA
P_ID DESC) S WHERE ROWNUM <= 2
2xn8yx0uz75fm

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
SELECT VALUE FROM V$PARAMETER WHERE NAME='compatible'
c2h8tpm85b5gb
SELECT COUNT(A.TARGET_NAME) FROM MGMT_TARGETS A, MGMT_CURRENT_AVAILABILITY B WHE
RE A.TARGET_GUID = B.TARGET_GUID AND B.CURRENT_STATUS = 1 AND A.TARGET_TYPE NOT
IN (:B3 , :B2 , :B1 ) AND A.LAST_LOAD_TIME < ((SYSDATE - ((TO_NUMBER(TO_CHAR(SYS
TIMESTAMP, 'TZH'))* 60 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP, 'TZM'))) / (24 * 60)) +
 (A.TIMEZONE_DELTA / (24 * 60))) - 1 / 12)
13ufjzvqzz68s
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,e
xtpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decod
e(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:
17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9qgtwh66xg6nz
select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,maxtrans,h
ashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),nvl(flags,0),nvl(spare
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
1,0)from clu$ where obj#=:1
05sghzkq6r6yv
select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,maxtrans,h
ashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),nvl(flags,0),nvl(spare
1,0)from clu$ where obj#=:1
05sghzkq6r6yv
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
rivilege#>0 start with grantee#=:1 and privilege#>0
0h6b2sajwb74n
select sql_id from v$sql where sql_text like 'select TABLESPACE_NAME,sum(bytes/1
024/1024) MB from dba_data_files group by TABLESPACE_NAME'
5ck93j84nm7c9
select value, consumer_group from resource_group_mapping$ where attribute = :1 a
nd status = 'ACTIVE'
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
11fhc265h37ws
select procedure#,entrypoint# from procedurec$ where obj#=:1 order by procedure#
971vpk0tp7ahm
select procedure#,entrypoint# from procedurec$ where obj#=:1 order by procedure#
971vpk0tp7ahm
select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ wher
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
e obj#=:1 and part=:2 and version=:3 order by piece#
39m4sx9k63ba2
select metadata from kopm$  where name='DB_FDO'
cb21bacyh3c7d
select metadata from kopm$  where name='DB_FDO'
cb21bacyh3c7d

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
INSERT INTO wrh$_optimizer_env         (snap_id, dbid, optimizer_env_hash_value,
 optimizer_env)    SELECT         :lah_snap_id lsnid, :dbid dbid,         ope.op
tenvhv_kewroee, ope.optenv_kewroee    FROM      x$kewrattrnew atn, x$kewrtoptenv
 ope    WHERE      atn.num1_kewrattr = ope.optenvhv_kewroee
8ptzbp9gxmcbf
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.cluco
ls,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.bl
kcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.pro
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
perty,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(
t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts
.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj#
= ts.obj# (+)
1gu8t96d0bdmu
insert into wrh$_mttr_target_advice        (snap_id, dbid, instance_number,
    mttr_target_for_estimate, advice_status, dirty_limit,         estd_cache_wri
tes, estd_cache_write_factor,         estd_total_writes, estd_total_write_factor
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
,         estd_total_ios, estd_total_io_factor)   select :snap_id, :dbid, :insta
nce_number,          mttr_target_for_estimate, advice_status, dirty_limit,
    estd_cache_writes, estd_cache_write_factor,          estd_total_writes, estd
_total_write_factor,          estd_total_ios, estd_total_io_factor     from v$mt
tr_target_advice
5b3c11dffgdvy
select position#,sequence#,level#,argument,type#,charsetid,charsetform,propertie
s,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,typ
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
e_name,type_subname,type_linkname,pls_type from argument$ where obj#=:1 and proc
edure#=:2 order by sequence# desc
32hbap2vtmf53
select position#,sequence#,level#,argument,type#,charsetid,charsetform,propertie
s,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,typ
e_name,type_subname,type_linkname,pls_type from argument$ where obj#=:1 and proc
edure#=:2 order by sequence# desc
32hbap2vtmf53
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE
', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT',
4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5ur69atw3vfhj
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0
0k8522rmdzg4k
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del
etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags
 + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob
j# = :objn
g00cj285jmgsw
select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#
=:1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
g3wrkmxkxzhf2
insert into sys.mon_mods$ values (:1, :2, :3, :4, :5, :6, :7)
5nw6w7vm83hjn
select plan_table_output from table(dbms_xplan.display_cursor('ajru4r5m2djwt'))
69xt43xpzbhns
select A.inst_id, A.sgasz, round((A.sgasz / A.base_sgasz), 4),                ro
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
und(A.base_dbtime * round((A.dbtime / A.base_estd_dbtime), 4), 0),          roun
d((A.dbtime / A.base_estd_dbtime), 4),                                    round(
A.base_phy_reads *                                                            ro
und((A.estd_physical_reads / A.base_estd_phy_reads), 4), 0)           from x$kmg
sbsadv A                                                            order by A.i
nst_id
a4xyg22hrzhuv
SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETE
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
R_VALUE)='TRUE'
24dkx03u3rj6k
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_
size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, a
vgcln from hist_head$ where obj#=:1 and intcol#=:2
96g93hntrzjtr
update wrm$_wr_control    set snap_interval = :bind1, snapint_num = :bind2, rete
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
ntion = :bind3,      retention_num = :bind4, most_recent_snap_id = :bind5,
most_recent_snap_time = :bind6, mrct_snap_time_num = :bind7,      status_flag =
:bind8, most_recent_purge_time = :bind9,      mrct_purge_time_num = :bind10,
  most_recent_split_id = :bind11, most_recent_split_time = :bind12,      swrf_ve
rsion = :bind13, registration_status = :bind14,      mrct_baseline_id = :bind15,
 topnsql = :bind16    where dbid = :dbid
7k5ymabz2vkgu
select obj# from oid$ where user#=:1 and oid$=:2
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
cjk1ffy5kmm5s
insert into wrh$_java_pool_advice     (snap_id, dbid, instance_number,      java
_pool_size_for_estimate, java_pool_size_factor,      estd_lc_size, estd_lc_memor
y_objects, estd_lc_time_saved,      estd_lc_time_saved_factor, estd_lc_load_time
,      estd_lc_load_time_factor, estd_lc_memory_object_hits)  select      :snap_
id, :dbid, :instance_number,      java_pool_size_for_estimate, java_pool_size_fa
ctor,      estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved,      estd_l
c_time_saved_factor, estd_lc_load_time,      estd_lc_load_time_factor, estd_lc_m
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
emory_object_hits  from v$java_pool_advice
70utgu2587mhs
select q.name, q.eventid, q.usage, t.schema, t.name,   t.flags  FROM system.aq$_
queues q, system.aq$_queue_tables t   WHERE q.table_objno = t.objno and q.eventi
d = :1
ajqab55f8rn36
select max(procedure#) from procedurejava$ where obj#=:1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
5km6gkvuh3n43
select max(procedure#) from procedurejava$ where obj#=:1
5km6gkvuh3n43
SELECT DISTINCT HOST_URL FROM MGMT_OMS_PARAMETERS
f20qqtsxtbnc8
select STAT_ID, STAT_NAME, VALUE from GV$SYS_TIME_MODEL  where inst_id = USERENV
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
('Instance')
19q01ah6pbqd7
SELECT INSTANCE_NAME, HOST_NAME, STARTUP_TIME FROM V$INSTANCE
fm1gpkftdrr1j
select a.obj#, a.schedule_expr, a.schedule_id, a.flags, 1   from sys.scheduler$_
job a  where (a.schedule_limit is not null)    and bitand(a.job_status, 515) = 1
    and ((bitand(a.flags, 134217728 + 268435456) = 0) or         (bitand(a.job_s
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
tatus, 1024) <> 0))    and (a.next_run_date is not null)    and (a.next_run_date
 + a.schedule_limit < :1)    and (a.class_oid is not null)    and (a.class_oid i
n (select b.obj# from scheduler$_class b                          where (bitand(
b.flags, :2) <> 0 and                                 b.affinity = :3)))
59r2vzsngmr8t
select a.sql_text from v$sqltext a where (a.hash_value,a.address) in ( select de
code (sql_hash_value,0,prev_hash_value,sql_hash_value), decode (sql_hash_value,0
,prev_sql_addr,sql_address) from v$session b where b.paddr=(select addr from v$p
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
rocess c where c.spid='5922')) order by piece asc
cmsych93w3rtw
SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC
_NAME = :B2 AND METRIC_COLUMN = :B1
5kyb5bvnu3s04
SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC
_NAME = :B2 AND METRIC_COLUMN = :B1
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
5kyb5bvnu3s04
select value, flags, modified_inst, additional_info,         attr_tstamp, attr_i
ntv from  sys.scheduler$_global_attribute where obj# = :1
4rm4183czbs7j
SELECT EMD_URL, EVENT_TYPE, OCCUR_TIME FROM MGMT_JOB_EMD_STATUS_QUEUE ORDER BY O
CCUR_TIME
d59tgwpksgs94
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
lock table sys.mon_mods$ in exclusive mode nowait
350f5yrnnmshs
select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysd
ate+5/86400))
g2wr3u7s1gtf3
select intcol#,type,flags,lobcol,objcol,extracol,schemaoid,  elemnum from opqtyp
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
e$ where obj# = :1 order by intcol# asc
0fr8zhn4ymu3v
select OBJOID,  CLSOID, RUNTIME, PRI, JOBTYPE,  SCHLIM,  WT, INST,  RUNNOW, ENQ_
SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID,    decode(bitand(a.flags
, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME,    (2*a.priority +
   decode(bitand(a.job_status, 4), 0, 0,            decode(a.running_instance, :
1, -1, 1))) PRI,    1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT,    deco
de(a.running_instance, NULL, 0, a.running_instance) INST,    decode(bitand(a.fla
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
gs, 16384), 0, 0, 1) RUNNOW,    decode(bitand(a.job_status, 8388608), 0, 0, 1) E
NQ_SCHLIM  from sys.scheduler$_job a  where bitand(a.job_status, 515) = 1    and
 ((bitand(a.flags, 134217728 + 268435456) = 0) or         (bitand(a.job_status,
1024) <> 0))    and bitand(a.flags, 4096) = 0    and (a.next_run_date <= :2
  or bitand(a.flags, 16384) <> 0)    and (a.class_oid is null      or (a.class_o
id is not null      and a.class_oid in (select b.obj# from sys.scheduler$_class
b                          where b.affin
63fyqfhnd7u5k

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select node,owner,name from syn$ where obj#=:1
1mjd9xp80vuqa
select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# a
nd t.dflextpct!=0 and t.bitmapped=0
chsyr0gssbuqf
SELECT NVL((((SUM(DURATION)/(60*1000))/60)*100),0), NVL(AVG((VALUE*1000.0)/DURAT
ION),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE IS_TOTAL='Y' AND DURATION > 0 AND
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 TIME > (SYSDATE-(1/24)) AND JOB_NAME = 'EMD_NOTIFICATION.NotificationDelivery S
ubsystem'
bz2x7xsaf3uyx
select java_pool_size_for_estimate s,           java_pool_size_factor * 100 f,
         estd_lc_load_time l, 0            from v$java_pool_advice
8p447s6p0rv6b
select sum(SYSDATE - cast(qt.enq_time as date))  from   "SYSMAN"."MGMT_NOTIFY_QT
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
ABLE" qt, "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_I" iot  where  iot.subscriber# != 0 a
nd         (iot.subscriber# in (select subscriber_id
  from   "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S"                              where
 queue_name = :1 and (bitand(subscriber_type, 8) = 8)))         and qt.msgid = i
ot.msgid
4rm23mmq2zv7q
select sum(SYSDATE - cast(qt.enq_time as date))  from   "SYSMAN"."MGMT_NOTIFY_QT
ABLE" qt, "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_I" iot  where  iot.subscriber# != 0 a
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
nd         (iot.subscriber# in (select subscriber_id
  from   "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S"                              where
 queue_name = :1 and (bitand(subscriber_type, 8) = 8)))         and qt.msgid = i
ot.msgid
4rm23mmq2zv7q
select INST_ID, KWQSIQID , KWQSINWT, KWQSINRD,          KWQSINEX, KWQSINCO, KWQS
ITWT,           DECODE(KWQSINCO, 0, 0, KWQSITWT/KWQSINCO)          from X$KWQSI
9hzvpupma3y9p
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select externtype, externname, local_attrs, attributes from type$  where tvoid=:
1
0p7pg240f3z0a
select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where o
bj#=:1 order by procedurename desc, overload# desc
dcstr36r0vz0d

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where o
bj#=:1 order by procedurename desc, overload# desc
dcstr36r0vz0d
select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where o
bj#=:1 order by procedurename desc, overload# desc
dcstr36r0vz0d
select   schedule_mode, start_calibrate, num_votes,   synced_time, last_vote, st
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
atus from   WRI$_SCH_CONTROL where   schedule_id = :id
3s1yukp05bzg6
select cachedblk, cachehit, logicalread from tab_stats$ where obj#=:1
7tc5u8t3mmzgf
select u.name, o.name, trigger$.sys_evts, trigger$.type#  from   obj$ o, user$ u
, trigger$  where (bitand(trigger$.property, 8) = 8)  and   (bitand(trigger$.pro
perty, 16) != 16)  and   trigger$.obj# = o.obj# and o.owner# = u.user# order by
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
o.obj#
10utkgdw43zmn

261 rows selected.
SQL> l
  1* select sql_text,SQL_ID from v$sql
SQL> select sql_text,SQL_ID from v$sql where rownum<10;
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
update sys.job$ set this_date=:1 where job=:2
aq8yqxyyb40nn
SELECT NVL(DISPLAY_NAME, :B1 ) FROM MGMT_PERFORMANCE_NAMES WHERE IS_DBMSJOB='Y'
AND :B1 LIKE (DBMS_JOBNAME||'%') AND ROWNUM = 1
6k825qt9n816u
select streams_pool_size_for_estimate s,           streams_pool_size_factor * 10
0 f,           estd_spill_time + estd_unspill_time, 0  from v$streams_pool_advic
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
e
g6gu1n3x0h1h4
select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by i
ntcol# asc
9g485acn2n30m
select a.obj# OBJOID, a.class_oid CLSOID,    decode(bitand(a.flags, 16384), 0, a
.next_run_date, a.last_enabled_time) RUNTIME,    (2*a.priority +     decode(bita
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
nd(a.job_status, 4), 0, 0,            decode(a.running_instance, :1, -1, 1))) PR
I,    1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT,    decode(a.running_i
nstance, NULL, 0, a.running_instance) INST,    decode(bitand(a.flags, 16384), 0,
 0, 1) RUNNOW,    decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM  fro
m sys.scheduler$_job a  where bitand(a.job_status, 515) = 1    and ((bitand(a.fl
ags, 134217728 + 268435456) = 0) or         (bitand(a.job_status, 1024) <> 0))
  and bitand(a.flags, 4096) = 0    and (a.next_run_date <= :2       or bitand(a.
flags, 16384) <> 0)    and a.class_oid is not null    and a.class_oid in (select
 b.obj# from scheduler$_class b                        where bitand(b.flags, :4)
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 <> 0 and b.affinity = :5) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
7mvdhsu3d43ag
SELECT DECODE(PARAMETER_VALUE, :B3 , 3, :B2 , 2, :B1 , 1, 0) FROM MGMT_PARAMETER
S WHERE PARAMETER_NAME = 'system_error_log_level'
dm39phkdf04ug
select timestamp, flags from fixed_obj$ where obj#=:1
asvzxj61dc5vs
SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnb
as,NVL(spare1,0) from file$ where file#=:1
19g6x6d7nh669
select blocks,NVL(ts#,-1),status$,NVL(relfile#,0),maxextend,inc, crscnwrp,crscnb
as,NVL(spare1,0) from file$ where file#=:1
19g6x6d7nh669

9 rows selected.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@RAC2 ~]$
[oracle@RAC2 ~]$
[oracle@RAC2 ~]$ exit
logout
[root@RAC2 ~]#
[root@RAC2 ~]#
[root@RAC2 ~]#
阅读(6323) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~