why query execution time is slow, plz help? [message #54717] |
Sun, 01 December 2002 00:43 |
Abduaziz
Messages: 1 Registered: December 2002
|
Junior Member |
|
|
I have Oracle9i installed in sunfire machine. I observe a slow performance in executing any query. I check the following:
- A gateway definition of my server and it was ok.
- I use ftp command to measure the connection from my pc to the sun server and it was 85 Mbps.
Is there any parameter in the Listener, to tune the performance or in the Oracle9i itselfe? plz help.
|
|
|
Re: why query execution time is slow, plz help? [message #54721 is a reply to message #54717] |
Sun, 01 December 2002 06:41 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
there might be tons of unknown bottlenecks.
to start with (check inside oracle env)
check the execution plan.
it will give an idea, whether the indexes are used or what?>
if its OK with this, then u may look into network considerations.
|
|
|