Skip to Content
0
Former Member
Nov 25, 2011 at 05:55 AM

How to perform 'SQL Statement Analysis'?

756 Views

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