Hi
The Better answer is that ... Create a trace file using tkprof and check
what would be the problem.....
George
-----Original Message-----
From: Amar Kumar Padhi
[mailto:oracledba-ezmlmshield-x10436370.[Email address protected]
Sent: Tuesday, May 31, 2005 4:39 PM
To: LazyDBA Discussion
Subject: RE: Select Count(*) very fast yesterday but its slow today
You have it right. In addition, one I could think of is that there is
something heavy running on the server that has hogged up most of the
resources. This could be related to the memory available or the I/O or
the
CPU, or even the network.
Thanks!
amar kumar padhi
-----Original Message-----
From: JAIMURUGAN Shanmuga Velayutham
[mailto:oracledba-ezmlmshield-x23705609.[Email address protected]
Sent: 31 May 2005 14:18
To: LazyDBA Discussion
Subject: Select Count(*) very fast yesterday but its slow today
Hi all,
This was the question recently I encountered in an interview. I gave the
answers below but that doesn't seem to satisfy the interviewer.
QUESTION:-
SELECT COUNT (*) FROM TABLE_NAME:
The query ran fine and I got the output in less than 25 seconds. The
next
day I ran the same query and I got the output after 15 minutes. What is
the
reason for this? As a DBA what is that you will check immediately?
My Answer:-
1. Mass insert or mass delete would have happened in the table,
Statistics
were not gathered after that .So the performance has degraded. 2.
Statistics
would have been deleted.
Are there any other reasons for the performance degradation?
Thanks in advance
JAIMURUGAN
Confidentiality Statement:
This message is intended only for the individual or entity to which it
is
addressed. It may contain privileged, confidential information which is
exempt from disclosure under applicable laws. If you are not the
intended
recipient, please note that you are strictly prohibited from
disseminating
or distributing this information (other than to the intended recipient)
or
copying this information. If you have received this communication in
error,
please notify us immediately by return email.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
Oracle LazyDBA home page