Re: Performance difference issue between two users of the same database

"Billy" <vslabs_at_onwe.co.za> wrote in message news:<1117000141.196099.213410_at_g47g2000cwa.googlegroups.com>...
> Talk2Vineet_at_gmail.com wrote:
>
> > Billy i want to include one more thing that i know only a little about
> > the things you described in your previous mail...... CBO....FGAC......,
>
> CBO = Cost Based Optimiser
> FGAC = Fine Grained Access Control
> IOT = Indexed Organises Table
>
> > So please explain them in detail.
>
> And take the joy away from you from discovering these wonders via the
> Oracle manuals!? NEVER!! <horrified expression>
>
> Seriously though - all these are covered in the Oracle documentation.
> Two manuals are (IMO) mandatory reading for everyone who uses Oracle
> - Oracle Concepts Guide
> - Application Developer Fundementals
>
> The first one tells you how Oracle works and the 2nd one tells you
> about the fundementals of the features you as developer can use in
> Oracle.
>
> Do not except to get anything right in Oracle without at least knowing
> the basic stuff in these two manuals.

Besides these manuals:
Read always Oracle Performance Tuning Guide - and know how the database is instrumented
(see Anjos YAPP method, www.miracleas.dk, www.oraperf.com)

If you want to solve the mystery about 2 users running the same query with different execution times, you have to put a trace 10046 on the users. For now its all stilla guess.

Bjarke. Received on Wed May 25 2005 - 22:40:37 CDT