Home » RDBMS Server » Performance Tuning » ORACLE V$SQL issue ....
ORACLE V$SQL issue .... [message #362110] Mon, 01 December 2008 00:30 Go to next message
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

Re: ORACLE V$SQL issue .... [message #362250 is a reply to message #362110] Mon, 01 December 2008 08:15 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DBMS_PROFILER
Previous Topic: Clob column on remote database
Next Topic: how to find list of sql statements ran in the past time.
Goto Forum:
  


Current Time: Thu Dec 08 10:24:45 CST 2016

Total time taken to generate the page: 0.12984 seconds