Re: Tables scanning ??

Sharon Q (squarrington_at_mdshealth.com) writes:
> I have third party layered application running on Oracle 7.0.16 on DEC
> OSF UNIX. The performance is not very good and we believe that the
> system is doing table scanning. How can we verify that this is occuring
> without access to the source code? How can we tell what tables are being
> scanned and how often? We have seen very high disk I/O rates and believe
> the software is the problem but are getting nowhere with the software developer.

   Enable the SQL trace option by setting init.ora parameter SQL_TRACE=TRUE. Then run the app through it's paces. This will produce trace files in the directory pointed to by init.ora paramater USER_DUMP_DEST. You can then run the tkprof utility on these file with the EXPLAIN option and get all of the information you are looking for.

   This is all documented in the Application Developers Guide.

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##