SELECT NULL AS table_cat, t.owner AS table_schem,
t.table_name AS table_name, t.column_name AS column_name,
DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER'
, 3, 'LONG', -1, 'DATE', 91, 'RAW', -3, 'LONG RAW
', -4, 'BLOB', 2004, 'CLOB', 2005, 'BFILE', -13 2,375 1 2,375.0 2.7 2.90 7.06 2522684317
Module: SQL*Plus
BEGIN statspack.snap; END; 766 2 383.0 0.9 0.02 0.01 2614951860
select t.schema, t.name, t.flags, q.name from system.aq$_queue_t
ables t, sys.aq$_queue_table_affinities aft, system.aq$_que
ues q where aft.table_objno = t.objno and aft.owner_instance = :
1 and q.table_objno = t.objno and q.usage = 0 and b
itand(t.flags, 4+16+32+64+128+256) = 0 and NOT ( t.n 600 20 30.0 0.7 0.00 0.02 1356713530
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with (grantee#=:1 or grantee#=
1) and privilege#>0 567 81 7.0 0.7 0.01 0.02 696263800
select count(*) from t_user 359 1 359.0 0.4 1.76 5.91 4043595143
Module: SQL*Plus
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER
, TEXT_SUBSET , SHARABLE_MEM , SORTS , MODULE , LOADED_VERSIONS
, FETCHES , EXECUTIONS , LOADS , INVALIDATIONS , PARSE_CALLS ,
DISK_READS , BUFFER_GETS , ROWS_PROCESSED , COMMAND_TYPE , ADDRE
SS , HASH_VALUE , VERSION_COUNT , CPU_TIME , ELAPSED_TIME , OUTL 280 40 7.0 0.3 0.02 0.00 3371479671
select t.name, (select owner_instance from sys.aq$_queue_table_
affinities where table_objno = t.objno) from system.aq$_queue
_tables t where t.name = :1 and t.schema = :2 for update skip lo
cked 140 20 7.0 0.2 0.00 0.00 1841561324
select count(*) from T_User 40 20 2.0 0.0 0.00 0.01 2009804744
ALTER SESSION SET TIME_ZONE='+8:00' NLS_LANGUAGE='SIMPLIFIED CHI
NESE' NLS_TERRITORY='CHINA' 40 20 2.0 0.0 0.00 0.00 3997906522
select user# from sys.user$ where name = 'OUTLN'
Module: JDBC Thin Client
select work_time from operate_time 20 10 2.0 0.0 0.00 0.00 1038353885
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= n
ext_date) and (next_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, job 15 5 3.0 0.0 0.00 0.00 764557680
SELECT JOB_NAME, RUN_TIME, SERVICE_NAME, LOADER_NAME, RUNTIME_DA
TA_ID, RECURRENCE_INFO_ID, START_DATE_TIME, FINISH_DATE_TIME FRO
M JOB_SANDBOX WHERE (RUN_TIME < :1 ) AND (START_DATE_TIME IS NU
LL ) ORDER BY RUN_TIME 15 5 3.0 0.0 0.02 0.00 1179298226
Module: JDBC Thin Client
select * from GOLD_PASSWORD_RESET e where 1=1 14 2 7.0 0.0 0.00 0.00 2413738086
Module: JDBC Thin Client
select auto_update from operate_time 12 4 3.0 0.0 0.01 0.00 1694224442
Module: JDBC Thin Client
select * from GOLD_PASSWORD_RESET e where 1 = 1 and account_typ
e = 'f' 10 10 1.0 0.0 0.00 0.00 1693927332
select count(*) from sys.job$ where (next_date > sysdate) and (n
ext_date < (sysdate+5/86400)) 9 1 9.0 0.0 0.00 0.00 3743621015
UPDATE SMON_SCN_TIME SET SCN_WRP=:1, SCN_BAS=:2, TIME_MP=:3, TIM
E_DP=:4 WHERE TIME_MP = :5 AND THREAD = :6 AND ROWNUM <= 1测试:http://hi.baidu.com/edeed/blog/item/3ed0a4c212cc661e0ff47778.html
7 1 7.0 0.0 0.00 0.00 2201872251
SELECT MIN(TIME_MP), COUNT(*) FROM SMON_SCN_TIME WHERE THREAD =
:1 3 1 3.0 0.0 0.00 0.00 3716207873
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
1 2 2 1.0 0.0 0.00 0.00 633914867
select q_name, state, delay, expiration, rowid, msgid, dequeu
e_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,Module: SQL*Plus
BEGIN statspack.snap; END; 7,156 1 7,156.0 99.9 1.76 5.91 4043595143
Module: SQL*Plus
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER
, TEXT_SUBSET , SHARABLE_MEM , SORTS , MODULE , LOADED_VERSIONS
, FETCHES , EXECUTIONS , LOADS , INVALIDATIONS , PARSE_CALLS ,
DISK_READS , BUFFER_GETS , ROWS_PROCESSED , COMMAND_TYPE , ADDRE
SS , HASH_VALUE , VERSION_COUNT , CPU_TIME , ELAPSED_TIME , OUTL 0 5 0.0 0.0 0.00 0.00 406999655
Module: JDBC Thin Client
select work_time from operate_time 0 5 0.0 0.0 0.00 0.00 425407315
Module: JDBC Thin Client
SET TRANSACTION READ ONLY 0 2 0.0 0.0 0.77 0.73 436720154Module: JDBC Thin Client
SET TRANSACTION READ WRITE 0 2 0.0 0.0 0.00 0.00 633914867
select q_name, state, delay, expiration, rowid, msgid, dequeu
e_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corr
id, time_manager_info from SYS.AQ_EVENT_TABLE where time
_manager_info <= :1 and state != :2 for update skip locked 0 81 0.0 0.0 0.01 0.02 696263800
最好能详细到每个SQL语句,能分析多少是多少,依据情况给分,麻烦各位了!
http://user.qzone.qq.com/251097186/blog/1245484178
Buffer Gets
Executions
Gets per Exec
%Total Time (s)
Time (s)
Hash Value
Gets per Exec、%Total Time (s)、Time (s)、Hash Value的数据来看语句有没有问题呢,都无法把完整report附件上传,谁能告诉我下,难道要发邮件?
Gets per Exec、%Total Time (s)、Time (s)、Hash Value的数据来看语句有没有问题呢,都无法把完整report附件上传,谁能告诉我下,难道要发邮件?
Time (s) 、Hash Value报告上确实有,如果单从这些的数字上看,上面的语句有没有问题呢。我没有找到在哪可以上传附件,知道的朋友可以告知下,难道要发邮件了?
Inthirties关注Oracle数据库 维护 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
电子邮件:[email protected] [email protected]
网站: http://www.inthirties.com