Home » RDBMS Server » Performance Tuning » find out query is taking full table scan or index scan
find out query is taking full table scan or index scan [message #277370] Mon, 29 October 2007 16:06 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Hi,

i have couple of questions.

1) I have a schema where all my objects are in that schema. my users are runnig reports. some of them are complaint thet reprot is taking long time.
my question is i want to find the query (text of plsql block) who is causing performance problem.

2) i want to know that query is taking full table sacn or index scan.

Report message to a moderator

Re: find out query is taking full table scan or index scan [message #277372 is a reply to message #277370] Mon, 29 October 2007 16:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/

Sometimes a Full Table Scan is the best/correct way to access the data.

[Updated on: Mon, 29 October 2007 16:23] by Moderator

Report message to a moderator

Re: find out query is taking full table scan or index scan [message #278025 is a reply to message #277370] Thu, 01 November 2007 09:05 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Addition to Ana,
You can also use DBMS_PROFILER package to findout plsql function/procedure/package problem.
http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_profil.htm#996766



Regards
Mohammed Taj

Report message to a moderator

Previous Topic: performance problem
Next Topic: reading AWR report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 05:30:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.