Re: need answer to this OCP question on Resource limits
From: Frank C.C.Shen <frank_shen_at_uuu.com.tw>
Date: 1 May 2002 21:46:30 -0700
Message-ID: <cf9e635e.0205012046.3cf83df1_at_posting.google.com>
Date: 1 May 2002 21:46:30 -0700
Message-ID: <cf9e635e.0205012046.3cf83df1_at_posting.google.com>
"Cecil D'Souza" <cecildsouza_at_comcast.net> wrote in message news:<fTwz8.272322$K5.21907501_at_bin5.nnrp.aus1.giganews.com>...
> I came across a question while studying for my Oracle 8i OCP and I am not
> sure of the answer.
>
> Q: Identify the data dictionary view you can query to display the weights
> assigned to the different resources that are part of the composite index.
>
> 1. DBA_USERS
> 2. RESOURCE_COST
> 3. DBA_TS_QUOTAS
> 4. DBA_PROFILES
>
> Your help is appreciated.
This Answer is 2
The data dictionary view RESOURCE_COST provides the weightages
assigned to different resources.
Composite_limit=CPU_PER_SESSION,CONNECT_TIME,LOGICAL_READS_PER_SESSION,PRIVATE_SGA
Received on Thu May 02 2002 - 06:46:30 CEST