GeekInterview.com
Home
Tech Articles
Code Samples
Learn
Freelance Projects
Online Testing
Geek Talk
Job Postings
Knowledge Base
Geek Blogs
Question Bank
Interview Questions
Certification
Placement Papers
Tech FAQ
Career Advice
Engineering
Ask Question
I am new,
Sign me up!
User Name
Remember Me?
Password
Interview Questions
Certification
Placement Papers
Tech FAQ
Career Advice
Engineering
Ask Question
GeekInterview.com
>
Interview Questions
>
Oracle
>
Database Administration
Go To First
|
Previous Question
|
Next Question
Database Administration
| Question 220 of 231
Print
Changed Performance
When yesterday developer gives the following command:
select count(*) from [table name]
it gives the output within minutes, today the same command takes hours? What will you check?
Total Answers and Comments:
3
Last Update: August 11, 2008 Asked by:
shanthiavari
Sponsored Links
Best Rated Answer
—
No best answer available. Please pick the good answer available or
submit
your answer.
June 18, 2008 11:26:00
#1
irfanyell
Member Since: April 2008 Contribution: 4
RE: Changed Performance
we have to take the sql trace. but it cannot be read by us. so we have to take the tkprof of this file which can be read by us. to take the sql trace fire the below command
SQL>alter session set sql_trace true;
then fire that sql statement
SQL>select count(*) from [tablename];
it will generate a trace file in udump
then stop the trace by following command
SQL>alter session set sql_trace false;
then produce a tkprof
$tkprof [filename] [kprof filename]
regards
irfan
Is this answer useful?
Yes
|
No
August 11, 2008 02:35:52
#2
baala
Member Since: August 2008 Contribution: 4
RE: Changed Performance
Probably there occured a plan flip look for changes in the plan using the AWR views.
Is this answer useful?
Yes
|
No
August 11, 2008 02:43:02
#3
baala
Member Since: August 2008 Contribution: 4
RE: Changed Performance
Have a look into the following tables :
DBA_HIST_SQLSTAT
dba_hist_snapshot
by doing natural joins on these views for the SQL_ID you will know about any plan changes happened.
Do corrective actions as per the findings.
Is this answer useful?
Yes
|
No
Go To Top
Sponsored Links
Related Categories
—
Oracle Backup and Recovery Interview Questions
Oracle Basics Interview Questions
Oracle Architecture Interview Questions
D2K Interview Questions
Data Access Interview Questions
Oracle DBA Interview Questions
Oracle security Interview Questions
Database Tuning Questions
Oracle Distributed Processing Interview Questions
Oracle Interview Questions
Oracle Memory Management Interview Questions
Oracle Forms Interview Questions
Oracle Forms Interview Questions
PL/SQL Interview Questions
Programmatic Constructs Interview Questions
RMAN Interview Questions
Real time Oracle Interview Questions
SQL Interview Questions
SQL and SQL Plus Interview Questions
Oracle System Architecture Interview Questions
Sponsored Links
About Us
-
Privacy Policy
-
Terms and Conditions
-
Contact
-
Ask Question
-
Propose Category
-
Site Updates
Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved