This is a discussion on performance statistics - where to find? within the DB2 forums, part of the Database Server Software category; --> When Oracle DB is being watched for performance the following performance stats are found in these Oracle's instance system ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| When Oracle DB is being watched for performance the following performance stats are found in these Oracle's instance system tables like V$<table_name> (e.g. V$SYSSTAT, V$_BUFFER_POOL_STATISTICS V$WAISTAT, V$ROLLNAME, V$ROLLSTAT, V$LATCHNAME, V$SESSION, V$LATCH_CHILDREN, V$SORT_USAGE, V$SYSTEM_EVENT, V$SESSION_WAIT, V$PARAMETER ). What are the comparable DB objects and where or how to debug performance with UDB DB2? |
| ||||
| Have a look at the Table functions in the v8 SQL Reference. Vladimir Cholak wrote: > When Oracle DB is being watched for performance the following > performance stats are found in these Oracle's instance system tables > like V$<table_name> (e.g. V$SYSSTAT, V$_BUFFER_POOL_STATISTICS > V$WAISTAT, V$ROLLNAME, V$ROLLSTAT, V$LATCHNAME, V$SESSION, > V$LATCH_CHILDREN, V$SORT_USAGE, V$SYSTEM_EVENT, V$SESSION_WAIT, > V$PARAMETER ). > > What are the comparable DB objects and where or how to debug > performance with UDB DB2? |