Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2010
    Posts
    5

    Unanswered: insert rate to table is getting slower with time

    Hi,
    I have a noticed the following behavior...
    when the DB is clean and fresh... our DB handles a very high rate of inserts (~1200 per second), butwith time, when the datafile (think thats the reason but might be any other thing... maybe indexes?) increases - the rate is going down. Right now the rate of inserts per second is around 500 per second (around 40% from the starting rate).
    Does anyone has any idea why is that happen? How can I solve that problem?
    Thanks,
    Ori Raz

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Post Operating System (OS) name & version for DB server system.
    Post results of
    SELECT * from v$version

    Do not COMMIT inside LOOP
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2010
    Posts
    5
    Solaris sparc64Bit
    Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
    PL/SQL Release 11.1.0.7.0 - Production
    CORE 11.1.0.7.0 Production
    TNS for Solaris: Version 11.1.0.7.0 - Production
    NLSRTL Version 11.1.0.7.0 - Production

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SQL_TRACE=TRUE for process "slowing down"

    You need to determine where time is being spent.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    you don't mention how you are inserting. There are a bunch of ways.
    you also don't mention if you are using logging, are in archivelog mode, whether the tablespace is set to auto-extend, whether you are doing direct inserts, whether you have constraints checking parent tables, how big the table is, if you are using ASM, what the server disk usage is, what else is going on while you are inserting, (i could keep going)
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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