Home » RDBMS Server » Performance Tuning » To find out the Stored Procedure name and the Full table scan
To find out the Stored Procedure name and the Full table scan [message #65617] Tue, 09 November 2004 20:22 Go to next message
Vijay
Messages: 116
Registered: September 1999
Senior Member
Dear All,

1.)  I have a set of queries that were collected from v$sql_area, that are performing badly. Now im supposed to tune these queries and edit the procedure that contains these queries. how can i find the procedure that contains these queries.

I tried using all_source and user_source but that did not give any result, is there anyother way out.

2.) Is there any way we can find out the tables in an entire application that have gone for a full scan.

Kindly help,

Vijay

Report message to a moderator

Re: To find out the Stored Procedure name and the Full table scan [message #65618 is a reply to message #65617] Tue, 09 November 2004 23:37 Go to previous message
Padders
Messages: 79
Registered: January 2004
Member
What version of Oracle?

Report message to a moderator

Previous Topic: how to tuning a hierachical query having "or" conditions
Next Topic: Slow performance of DBPLease help!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 23:30:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.