Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Upgrade to 10G from 9i best practices

Re: Upgrade to 10G from 9i best practices

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Thu, 16 Nov 2006 19:06:35 -0400
Message-ID: <cd4305c10611161506sc561bb0xd52946d5032a58bd@mail.gmail.com>


I have another on 10.2 when compiling in Oracle Developer calling to a functoin which calls through a link to a synonym, the forms can hang up while recompiling or leave the cpu about 90%, when no body is working on the database.
There is metalink note but I don't remember the number.

On 11/16/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Good Stuff Rich, thanks!
>
> Here is a new one for your list that I just found out about today. I've
> been wondering for a while now why my gethitratio was so terrible:
>
> SQL> select gets, gethits, gethitratio from v$librarycache where
> namespace = 'SQL AREA';
>
> GETS GETHITS GETHITRATIO
> ---------- ---------- -----------
> 122939 2640 .021474064
>
>
> Now I know it's just being reported incorrectly in v$librarycache:
>
> Note:394383.1
> Subject: Unusually low gethit ratio in statspack or AWR report
>
>
> Regards,
> Brandon
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
----------------------------------------
http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Oracle Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 16 2006 - 17:06:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US