How to perform 'SQL Statement Analysis'?
Dear Gurus,
'DB02->Performance->SQL Statement Analysis->Shared Cursor Cache/Table Access/Column Usage/System Statistics for CBO'
Does anyone know how to use the 'SQL Statement Analysis'?
For instance,
>Shared Cursor Cache
There are many technical analysis indexes(Buffer gets,Reads/Execution...). What are the most important/significant?
>Table Access
When I run this anyalysis. It popupped a 'Runtime Errors COMPUTE_BCD_OVERFLOW'. Why? and What's the point of this analysis?
>Column Usage
>System Statistics for CBO'
Regards!
Jason