dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Strange problem with database

  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    Strange problem with database

    I am having a problem where, after stress tesing a java app on my database using load runner, the database crawls. The strange thing is the application completes successfully.

    Then sys connection takes 10 mimutes. Query to a dbs_users takes half an hour. These are the checkes I made:

    1. Nothing in the alert log other than log switching.
    2. No trace files at all regarding any error bdump and udump
    3. The database is not on archivelog mode.

    How to solve this problem. Where to look?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have you usedstats pack to see what the delays are due to?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    Sounds like the Flux Capacitor.



    MH
    I remember when this place was cool.

  4. #4
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    I cannot even run statspack report because it takes forever. Each line slowly displays after 10 minutes.

    This is W2K server running 9.2.0.4.

  5. #5
    Join Date
    Feb 2004
    Posts
    50
    Then sys connection takes 10 mimutes.
    Are you saying it takes 10 minutes to login?

  6. #6
    Join Date
    Jan 2001
    Posts
    3,134
    Usually when I have problems like this in Windoze, the CPU in task manager is pinned. Did you look at task manager? Sort the apps by CPU time, that should point you in the right direction, short of a networking problem.

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Is your java application running on the db server?

    Tamil

  8. #8
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    Connect is Ok. But select dbname from v$databse takes 10 minutes before coming back with connected.

    I locked the XDB schema. I was told that there is a 9.2.0.4 bug that does that if XDB schema is not locked. But I did lock this schema.


    Where do I look if select count(*) from user_tables does not come back and the session hangs.
    Last edited by newbie5; 02-27-2004 at 01:59 PM.

  9. #9
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    As Mr.H says look at task manager, also have a look at the disks: the flashing lights might indicate some unexpected activity (e.g. paging).

    I have NT Performance Monitor running permanently on my servers, with a window of 10+ minutes. In cases like this, if I run fast, I can see a picture of the server activity, before and after the onset of the problem.

    [Look on this site for QuickSlice which shows CPU per sub-process (i.e. "inside" oracle.exe) that task manager does not show. Unfortunately with response so bad, you'll have problems correlating that with anything the v$ views show you.]

    PS: link for quick slice and a useful Meatlink
    http://forums.dbasupport.com/forums/...ght=quickslice
    Last edited by DaPi; 02-27-2004 at 02:33 PM.

  10. #10
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    ri Feb 27 12:58:01 2004
    Errors in file e:\oracle\admin\rnjesm\udump\rnjesm_s006_2196.trc:
    ORA-00600: internal error code, arguments: [16365], [0x3A11D34C], [0], [4], [], [], [], []

    Fri Feb 27 12:58:30 2004
    found dead shared server 'S006', pid = (16, 1)
    Fri Feb 27 12:59:37 2004
    Errors in file e:\oracle\admin\rnjesm\udump\rnjesm_s016_3344.trc:
    ORA-00600: internal error code, arguments: [16365], [0x3A11DD78], [0], [4], [], [], [], []

    Fri Feb 27 13:00:13 2004
    found dead shared server 'S016', pid = (28, 1)

    I bounced the database and now this showing up in the init.ora.

    This seems to be a 9.2.0.4 bug apparently with no resolution from oracle.
    Last edited by newbie5; 02-28-2004 at 09:04 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width