• Home
  • RMAN
  • Database
    • Data Guard
    • Data Pump
    • Performance Tuning
    • Security
    • General
  • Enterprise Manager
    • Grid Control 11g
    • Cloud Control 12c
  • Middleware
    • APEX
    • Application Server
    • Forms & Reports
    • WebLogic Server
  • OS
    • Linux & UNIX
    • Windows
    • VirtualBox
  • SQL Server
  • MongoDB
  • About Me
Home » Posts tagged "performance"

Tag Archives: performance

Which SQL Server instance is consuming all my CPU/memory?

Posted on March 21, 2014 by Garth

For anyone running Windows 2008 (or above), you can simply add the “Command Line” column to the Task Manager view. From there, the instance name will follow the “-s” startup option, for example: C:\…\Binn\sqlservr.exe” –sPREPROD If you’re on Windows 2000/2003 then it’s not quite as straight forward. You can either get the Process ID from

Read More…

Posted in SQL Server | Tags: cpu, instance, memory, performance, sql server | Leave a comment |

Installing nmon on Linux 6

Posted on April 11, 2013 by Garth

The nmon (Nigel’s Monitor) tool was written initially for AIX to monitor system performance, but there are plenty of distributions available now so people can use it on a variety of operating systems these days, including flavours of Linux and even the recent Raspberry Pi (mini ARM based computer). It’s one of my favourite performance monitoring tools

Read More…

Posted in Linux & UNIX, OS | Tags: aix, linux, monitoring, nmon, performance, statistics | 1 Comment |

Changing the heap size of the OMS in EM12c

Posted on April 10, 2013 by Garth

Generally speaking, the Java heap memory utilization for your Oracle Management Service (OMS) should be averaging at under 75%, and anything over this could mean the Garbage Collection starts impacting the performance of your Enterprise Manager experience. If you’re using the “out-of-the-box” notification rules, then an OMS suffering such symptoms may start churning out events like this:

Read More…

Posted in Cloud Control 12c | Tags: cloud control, em12c, heap size, performance, tuning | 2 Comments |

Archived

Popular Posts

  • Restoring a MongoDB document from the oplog
  • PLS-00801: internal error [hshuid:LU invalid] when compiling a package body
  • OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring
  • Configuring Oracle Reports Server Job Queue Monitoring
  • Data Guard "CORRUPTION DETECTED: In redo blocks starting at block..." issues

External Links

  • SQL Formatter
  • Oracle Live SQL
  • SQL Fiddle
  • ASH Viewer
  • MOS
  • Oracle Forum
  • Oracle Base
  • Oracle FAQ
  • Oracle Articles
  • Rob Zoeteweij’s EM Blog
Copyright © 2020 SnapDBA.com