| Optimizing specific client query [message #275153] |
Thu, 18 October 2007 10:04  |
mleduc
Messages: 1
Registered: October 2007
Location: Québec
|
Junior Member |
|
|
Hi, I'm new to Oracle and I have some questions regarding Optimization.
I have some users using an application which is using an Oracle 9i Database.
One of the query used by the application is taking longer and longer to execute over time since the database is growing... The specific query seems to be a search (Searching for a sample within a lot of containers)
What I would like to do is to "Grab" the specific query by monitoring with the OEM and then create some indexes to make that query run faster.
Now I don't know how to do that... Where should I go to see that specific query SQL Syntax on the server side... I would like to ask the users to execute the search from the application and then look in some monitoring tool to grab it...
Also, Once I have the specific query, I would like to know the steps to optimize the databases indexes for that query...
Thanks for the help !!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
