Need help on oracle 8i db

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Oeleboele
    #1

    Need help on oracle 8i db

    the situation :
    A few days ago I inserted a lot of records (400.000) into my database, since
    then I sometimes experience low cpu-power (those moments last around 2
    hours) Even when no users are logged into my database.
    Is it possible oracle organizes maintenance and takes 30-40% of my cpu ?
    (every half hour a small boost in HD-activity)
    Before it did not suffer such a loss in cpu-power.
    So how can I prevent it ? with some kind of setting ?

    tnx in advance

    Greetz
    Guy Cretskens





    Tags: None
    • Romeo Olympia
      #2
      Re: Need help on oracle 8i db

      There is not enough information to make an intelligent guess. For all
      we know, it's not even your Oracle instance that's eating up your CPU.
      See the top processes at the OS level during those peak times and
      check if Oracle (just one big process in WindowsNT or several
      processes in Unix flavors) is actually the culprit. Use any OS
      monitoring tool available to you. Let's start there.

      Would also help if you could provide OS/DB/HW configuration.

      And btw, 400,000 inserted rows isn't really that big a number by most
      standards.

      "Oeleboele" <oeleboeleke@ze ron.bewrote in message news:<108733673 0.147921@seven. kulnet.kuleuven .ac.be>...
      the situation :
      A few days ago I inserted a lot of records (400.000) into my database, since
      then I sometimes experience low cpu-power (those moments last around 2
      hours) Even when no users are logged into my database.
      Is it possible oracle organizes maintenance and takes 30-40% of my cpu ?
      (every half hour a small boost in HD-activity)
      Before it did not suffer such a loss in cpu-power.
      So how can I prevent it ? with some kind of setting ?
      >
      tnx in advance
      >
      Greetz
      Guy Cretskens

        Comment

        • Oeleboele
          #3
          Re: Need help on oracle 8i db

          It's task manager that says it's the oracle proces that takes 30-40%

          OS :Windows 2000
          DB : Oracle 8.1.5
          hd : Eide Barracuda Seagate 7200 udma
          cpu : Intel P4 2ghz
          mem : 1 gig

          no 400.000 is not that much.. but since than I experience those troubles.
          (there is still enough room on hd =14gigs)

          "Romeo Olympia" <rolympia@hotma il.comschreef in bericht
          news:42fc55dc.0 406151831.48acc 10b@posting.goo gle.com...
          There is not enough information to make an intelligent guess. For all
          we know, it's not even your Oracle instance that's eating up your CPU.
          See the top processes at the OS level during those peak times and
          check if Oracle (just one big process in WindowsNT or several
          processes in Unix flavors) is actually the culprit. Use any OS
          monitoring tool available to you. Let's start there.
          >
          Would also help if you could provide OS/DB/HW configuration.
          >
          And btw, 400,000 inserted rows isn't really that big a number by most
          standards.
          >
          "Oeleboele" <oeleboeleke@ze ron.bewrote in message
          news:<108733673 0.147921@seven. kulnet.kuleuven .ac.be>...
          the situation :
          A few days ago I inserted a lot of records (400.000) into my database,
          since
          then I sometimes experience low cpu-power (those moments last around 2
          hours) Even when no users are logged into my database.
          Is it possible oracle organizes maintenance and takes 30-40% of my cpu ?
          (every half hour a small boost in HD-activity)
          Before it did not suffer such a loss in cpu-power.
          So how can I prevent it ? with some kind of setting ?

          tnx in advance

          Greetz
          Guy Cretskens

            Comment

            Previous template Next
            Working...