Re: dynamic service registration

"srivenu" <srivenu_at_hotmail.com> wrote in message news:1a68177.0403222258.674897a2_at_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

Well, that note is not exactly authorative is it? "About every minute" is as good as I saw. And that was in response to someone posting that re-registering takes place with delays of "up to a few minutes", a statement which the Oracle representative conveniently ignored in his reply.

> 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.

What may or may not happen when the listener is re-started doesn't exactly persuade either, because that's a special case with quite possibly a special code path. In the general case, where listener and instance run continuously, one needs to deal with the evidence of the listener.log... which I posted last time, and which has all sorts of registration times in it, but which averages out over 12 hours at once every 5 and a bit minutes.

Regards
HJR Received on Tue Mar 23 2004 - 04:46:32 CST