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

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.

--
Billy