Oracle Server side
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Oracle Server side

  1. #1
    Join Date
    Nov 2000
    Posts
    57

    Question

    Tell the various reasons why oracle is hanging up while doing insertion or
    updation alone
    Srikanth

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    You need to be a bit more specific, it could be any number of things. First how long is it hanging? Where are the statements coming from? Over a network or on the local machine? How big is the table? How many indexes are on the table? Are there any triggers on the insert/update? Etc.

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Or does it have any type of a LONG datatype (CLOBS, etc)

  4. #4
    Join Date
    Nov 2000
    Posts
    57

    Oracle Server side

    I just want to know the various reasons for database hanging. Can anyone give some examples from your realtime experience.


    Srikanth

  5. #5
    Join Date
    Jun 2000
    Posts
    417
    well it could be a lot of things.

    network latency, the fact that the table is just huge, inserting into a table with indexes means inserting into all the indexes as well which will take time, if there are triggers that do other things you need to wait for them, long datatypes are a factor, system load at the time, I/O, and i'm sure a dozen other things. it all depends on the environment.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    ...db_block_buffers too small, you have sized the SGA out of real memory, you have hit an oracle bug, you're doing a full table scan for every update, you are doing a cartesian join with update, you have placed all objects in the SYSTEM tablespace, all datafiles are on the same filesystem...

  7. #7
    Join Date
    Jun 2000
    Posts
    417
    ...someone tripped over the power cord, locks on the table/rows you're trying to access, os i/o bottlenecks, the list goes on and on :)

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    seems to me that you are trying to access a blocked row, in other words you are prob doing same update & insert as other people? do you mean hanging in a session?

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