> 
> Hi Ari, 
> 
> I am a new Oracle DBA. Recently I come across a problem.
> 
> Our developers have developed one "Point of Sales" software in oracle 
> Forms 4.5. Since I am new in this Environment , I don't know the Table
> designing and Application. 
> 
> Yesterday, One user complained to me that application response time is 
> slow.
> 
> Now I want to tune the application. I know all the tools like TKPROF
> utility, Hints and like. I also know how to tune SQL statement.
> 
> But, since I don't know table design and Application, I don't know
> from where to start Application Tuning.
> 
> Please guide me in this matter. Please tell me how to find out 
> Problematic SQL statement.
> 
> Thanks
> 
> Bye
> Prashant Shindgikar
> 
The first thing to do is to look at the EXPLAIN PLAN for the SQL statements.
To find out what's being run most often, type:

SELECT SQL_TEXT, EXECUTIONS
FROM V$SQLAREA
ORDER BY EXECUTIONS;

There are other columns in the V$SQLAREA that you can query to see the
SQL statements that took up the most memory, or the most disk io.

Also, check out some of the books in the stores, such as Advanced Oracle
Tuning by O'Reilly & Assoc.

Best of luck!


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page dex.htm"> Back to Ari Kaplan's Home Page