In my listener.log I'm seeing entries showing two different values for HOST, bb7b and bb0.
What is the source of that second host, HOST-bb0?
WARNING: Subscription for node down event still pending
11-FEB-2011 11:18:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=bb7b)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=
(PROTOCOL=TCP)(HOST=bb0)(PORT=1521)))(VERSION=169870336)) * status * 0
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…