Re: dynamic service registration

From: srivenu <srivenu_at_hotmail.com>
Date: 22 Mar 2004 22:58:09 -0800
Message-ID: <1a68177.0403222258.674897a2@posting.google.com>

howard,
> if you intend to manage your 8i and 9i databases with Enterprise Manager, it > is practically compulsory to have both DIR and static SID_LIST declarations
> for a single instance.

You are absolutely right.

> One of the reasons why Oracle recommends not using one, is because it may
> cause un-necessary overheads on the listener process.
Metalink Note - 151223.1

> The PMON registration cycle is every 1 minute.
Bug 2655865.
Also Metalink Message -
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=448630.999

Also you can check it out by stopping the listener and restarting it. You can see that the instance regsistration never takes more than 1 minute.

regards
Srivenu Received on Tue Mar 23 2004 - 00:58:09 CST