Re: CPU

From: Oraboy (venkat.lear_at_gmail.com)
Date: 09/22/05

  • Next message: belvilad: "Re: CPU" 
    Date: 22 Sep 2005 09:38:42 -0700

    Thanks again for your time and help.

    "Again, we too have seen differing results from Oracle between
    development and production, but often this boils down to the data in
    the db and the different queries (and volume quite frankly) between the

    environments."
    - well good thought..but what I meant was, do a HOT backup of
    production database (file after file) and copy it over to development
    instance and bring it up there (data volume is ditto same ; the only
    difference is user-load..since I dont have "loadrunner" or similar
    testing tools, I cannot add more stress..but the development server
    anyway is overloaded with more than 10 other running instances..)

    in spite of all this, development runs faster than production (sort of
    funny why we call this as prod box :-) )

    "The cause of that backlog is what your trying to determine. Is it a
    misconfigured oracle environment? Does the CPU load go down at night
    when the users log off (maybe it's not oracle, but a Unix system
    problem). Is your NIC card overloaded on the production box, etc.

    Applications like top, Glance, perfux, etc might help you to dive a bit

    deaper into what exactly is causing the backlog.
    "
    - thats new info to me..thanks
    I will have to read and understand what is NIC and how to monitor
    I see top with %IDLE jumping every two seconds somewhere between 10% -
    60%
    Glance and perfux - dont know much about it..will have to research more

    Thanks again for your inputs

  • Next message: belvilad: "Re: CPU"

    Relevant Pages

    • Re: Connecting to an Oracle database
      ... PL/SQL Release 2.3.4.0.0 - Production ... I now succeded to connect to the database in Delphi with the ADO ... > use it to connect to the database and immediately after you connect Oracle ... > conform to their programming paradigm. ...
      (borland.public.delphi.database.ado)
    • Re: Adding columns to SQL Server tables dynamically
      ... So would you recommend a production app to add columns through ado.net ... > fragmentation in Sql Server or Oracle. ... > nullable column and then updating each row. ...
      (microsoft.public.dotnet.framework.adonet)
    • Are there performancebenefits to reorganizing database-using export/import?
      ... I am using Oracle 9.2.0.5 on HP UNIX 11i. ... I have a production database using Oracle 9.2.0.5, ... time we had done full export of 8.1.7 database and then created 9.2. ... all objects from application schemas and do schema imports. ...
      (comp.databases.oracle.server)
    • Re: Migrating from 8i
      ... We are using Oracle 8i on the occasion of our professional application. ... Sorry, no, the Standard edition is not free for production use. ... nontransferable limited license to use ... and not for any other purpose. ...
      (comp.databases.oracle.server)
    • Re: possible nomination for oracle wtf
      ... Many years ago, Oracle 7.3.4, in fact, I was a contractor ... The tape from the night before was empty aswell. ... stuff like this to either almost run in production or really get ... It's not uncommon to see people go on vacation when a product goes live. ...
      (comp.databases.oracle.server)