| The query too slow [message #65423] |
Sat, 18 September 2004 03:55  |
Mazen Eid
Messages: 4
Registered: September 2004
|
Junior Member |
|
|
Hi there
I have query take too mush time to execute
My OS : Winods XP Professinal
Product : Oracle 9i database
I check the Oracle Performance manager I found the SGA Ratio is 100%
& there is more than 70% free memory in the Shared Pool
I checked the Wait event to see the top event & I found DB File Sequential Read Is very high
Please how can I reduce the DB File Sequential Read
Because I think this is the problem or how can i make my guery faster ??
Please help
Thanks
Mazen Eid
|
|
|
|
| Re: The query too slow [message #65424 is a reply to message #65423] |
Sat, 18 September 2004 06:56  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Hi,
Did you first tune your statement to choose the optimal path before checking your configuration ?
Most of the time, about 95% of the performance gains are in tuning faulty queries instead of tuning the database...
hth
Frank
|
|
|
|
| Re: The query too slow [message #65427 is a reply to message #65424] |
Sat, 18 September 2004 21:57 |
Mazen Eid
Messages: 4
Registered: September 2004
|
Junior Member |
|
|
hi Frank
i don't know how to check the optimal path ?
& can i do it without change the code in the application because i can't change the code ?
thanks 4 ur reply
Mazen
|
|
|
|
| Re: The query too slow [message #65428 is a reply to message #65427] |
Sun, 19 September 2004 07:25 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Oh dear, can't change code; this will become tough.
Search the docs for the use of statspack to see where the actual pain is.
best of luck...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
