Grokbase › Groups › Oracle › oracle-l › September 2004
FAQ
Hi Everyone:

We converted our SAP database to Unicode over the Labor Day=20
weekend. Now we are seeing lots and lots of latch waits and
buffer busy waits.

I'm trying to chase them down through Statspack, but I also thought
that you all might have some insight.

So...in other words...HELP!

Cheers,
Mike

---
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

Michael P. Vergara
Oracle DBA
Guidant Corporation
www.guidant.com <http://www.guidant.com/>

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/

Search Discussions

  • Justin Cave at Sep 7, 2004 at 1:02 pm ⇧
    How exactly did you convert the database to Unicode? Was this a straight
    ALTER DATABASE migration, or did you do an export and import?

    Justin Cave
    Distributed Database Consulting, Inc.
    http://www.ddbcinc.com/askDDBC

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Vergara, Michael (TEM)
    Sent: Tuesday, September 07, 2004 12:01 PM
    To: Oracle-L (E-mail)
    Subject: Ora 9.2.0.5/HP-UX 11.11/latch waits

    Hi Everyone:

    We converted our SAP database to Unicode over the Labor Day=20 weekend. Now
    we are seeing lots and lots of latch waits and buffer busy waits.

    I'm trying to chase them down through Statspack, but I also thought that you
    all might have some insight.

    So...in other words...HELP!

    Cheers,
    Mike

    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/
  • John Kanagaraj at Sep 7, 2004 at 1:13 pm ⇧
    Mike,
    We converted our SAP database to Unicode over the Labor Day=20
    weekend. Now we are seeing lots and lots of latch waits and
    buffer busy waits.
    This might be way off, but did you change the NLS parameter values from the
    OS side and client side as well ? If not, the translation layer may be
    working overtime to check/convert charsets and thus impose a larger than
    usual CPU load, and this may result in what you describe....

    Hth,
    John Kanagaraj <><
    DB Soft Inc
    Phone: 408-970-7002 (W)

    Fear connects you to the Negative, but Faith connects you to the Positive! I
    Jn 4:18

    The opinions and facts contained in this message are entirely mine and do
    not reflect those of my employer or customers **
    --
    To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
    To search the archives - http://www.freelists.org/archives/oracle-l/

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 7, '04 at 12:44p
activeSep 7, '04 at 1:13p
posts3
users3
websiteoracle.com

3 users in discussion

Justin Cave: 1 post John Kanagaraj: 1 post Vergara, Michael (TEM): 1 post

Content

People

Support

Translate

site design / logo © 2023 Grokbase