| ORACLE V$SQL issue .... [message #362110] |
Mon, 01 December 2008 00:30  |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Hi All,
In our system there are a number of stored procedures which are called by several applications to implement the business logic.Now the performance of the stored procedures are measured with the help of ORACLE view v$sql. The columns of the view are in use is given below.
PROC_NAME,
EXECUTIONS,
ELAPSED_TIME,
HASH_VALUE,
SYSDATE,
SQL_TEXT,
CPU_TIME,
BUFFER_GETS,
DISK_READS,
SQL_TEXT,
The performance monitoring system calculates the performance indicators between 2 snapshots of V$sql. Now ORACLE flushes out
the view at times as per its architecture. That point of the
problem occurs. We get wrong result for the performance
indicator. The database version is used ORACLE 9i.
To avoid the problem of flushing out of the view, we need to
get some other workaround to measure the performance of the
stored procedures.
Any help / input / suggestion to resolve the issue will be highly appreciated.
[Updated on: Mon, 01 December 2008 00:32] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
