| Ratnaker |
Posted: Feb 08, 2008 04:15:04 AM |
Total Post: 138
Joined: Apr, 2007
|
Hi
All One of my SQL Statement Working fine in morning but samew SQL is taking long time in The afternoon. How we can tune? Please Suggest me.
Ratnaker |
|
|
 Murtuja |
| Posted: Feb 08, 2008 04:36:11 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
There must be some batch job or Backup or some maintenace task is running.
If uou have changed any parameters then take care about that change.
|
|
|
|
|
| Ratnaker |
| Posted: Feb 08, 2008 05:27:41 AM | |
|
Total Post: 138
Joined: Apr, 2007
|
How we identify which batch job is running?
|
|
|
|
|
| Murtuja |
| Posted: Feb 08, 2008 05:52:13 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
If you have cronjobs then "crontab -l" gives you information about all the jobs.
If you have database jobs then
select * from DBA_JOBS_RUNNING
select * from DBA_JOBS
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 09, 2008 12:04:12 AM | |
|
Total Post: 704
Joined: Jul, 2007
|
And if you have windows and not using "dba_job_*" then check "schedule task" for any batch jobs.
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 09, 2008 12:06:24 AM | |
|
Total Post: 704
Joined: Jul, 2007
|
>>> samew SQL is taking long time
Did you check execution plan for both queries ?
SQL statement is slow for all database users or just few database users.
What changes you made in database before sql statement is slow ?
May be there is network speed is slow that is why you face performance problem.
so many reason find step by step and give us your feedback.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
