Category Archives: Oracle Server

Storage & Configuration, Undo Management, Redo Logs, Security, Scheduler,etc

Benefits and consequences of the NOLOGGING option

I still find confusion out there about the LOGGING and NOLOGGING clauses when performing DML and DDL operations, the reality is that the NOLOGGING clause will work only on particular conditions, but all regular inserts,updates and deletes will still log … Continue reading

Posted in Backup & Recovery, Oracle Server, SQL | Tagged , , , , , , , | 9 Comments

Oracle Widgets for the Grid Control / Oracle Enterprise Manager

Oracle desktop Widgets for the Grid Control Continue reading

Posted in Monitoring, Oracle Server, Performance & Tuning | Tagged , , , , , , | Leave a comment

Finding a locking session

How to identify lockers This article will explain about locks on rows and on objects in ORACLE. Locks on rows can cause performance problems or even impede a transaction from finishing, when there are processes running for long time we … Continue reading

Posted in Oracle Server, Performance & Tuning | Tagged , , , , , | 4 Comments

expdp error: 31623 and ORA-12805 in cluster 10.2.0.4

I was getting an error with expdp in our cluster 10.2.0.4 running on Red-Hat UDE-00008: operation generated ORACLE error 31623 ORA-31623: a job is not attached to this session via the specified handle ORA-06512: at “SYS.DBMS_DATAPUMP”, line 2772 ORA-06512: at … Continue reading

Posted in Backup & Recovery, Linux/Unix, Oracle Server | Tagged , , , | 1 Comment

Commonly used srvctl commands

What is srvctl? it is the Server Control Utility, we use SRVCTL to start and stop the database and instances, manage configuration information, and to add, move or remove instances and services. These are some of the srvctl commands I … Continue reading

Posted in High-Availability, Linux/Unix, Oracle Server | Tagged , , , , , , , , , , | 9 Comments

UNDO management, Cannot shrink the UNDO tablespace.

One common question we canĀ  find in the internet is how to shrink the undo tablespace, because even if we see it empty we can get an ORA 3297 error (see here how to deal with ORA 3297 error), therefore, … Continue reading

Posted in Oracle Server, SQL | Tagged , , , , | 2 Comments

OMS does not understand the timezone region of the agent – solved!

Hi, I was having problems starting up the management agent (10.2.0.5) in a RedHat 5 Linux, I was constantly getting the following error: 2009-12-15 19:19:47,406 Thread-1317072 WARN diagnostics.cpu: nmegam_ActivityManager_init: per-thread cpu usage not available for this platform 2009-12-15 19:19:50,251 Thread-1317072 … Continue reading

Posted in High-Availability, Linux/Unix, Oracle Server | Tagged , , , , , | 1 Comment