count数据库优化oracle,高version_count问题 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀...

Version Count Report Version 3.1.2 -- Today's Date 12-8月 -13 15:26

RDBMS Version :10.2.0.5.0 Host: odsb11 Instance 1 : odsb11

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

Addr: C0000012C3D410E0  Hash_Value: 4125641360  SQL_ID 04xtrk7uyhknh

Sharable_Mem: 280879 bytes   Parses: 3163445

Stmt:

0 select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$,

1 spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespa

2 ce=:3 and remoteowner is null and linkname is null and subname i

3 s null

Versions Summary

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

OPTIMIZER_MISMATCH :1

AUTH_CHECK_MISMATCH :8

LANGUAGE_MISMATCH :8

Total Versions:9

~

Plan Hash Value Summary

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

Plan Hash Value Count

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

853875749    10

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

Details for OPTIMIZER_MISMATCH :

4 versions with parallel_execution_enabled = false

4 versions with optimizer_mode = choose

4 versions with _pga_max_size = 2097152 KB

2 versions with hash_area_size = 2000000

2 versions with sort_area_size = 1000000

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

Details for AUTH_CHECK_MISMATCH :

# of Ver PARSING_USER_ID PARSING_SCHEMA_ID PARSING_SCHEMA_NAME

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

10                0                 0 SYS

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

Details for LANGUAGE_MISMATCH :

No details available

####

To further debug Ask Oracle Support for the appropiate level LLL.

alter session set events

'immediate trace name cursortrace address 4125641360, level LLL';

To turn it off do use address 1, level 2147483648

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