RE: startup takes long time on 10gR2.

From: Rich Jesse <>
Date: Sun, 14 Sep 2008 09:46:00 -0500 (CDT)
Message-ID: <2405.>

Glad you found it, Raj. Having a trigger that performs the same function, can you tell us how many objects the trigger's pinning? Also, how big are they (e.g. from v$db_object_cache.sharable_mem)?

On a 8-way p550, my startup trigger uses a table to pin 13 packages totaling about 2MB, and the startup delay isn't really noticable.


> I found it.
> its becoz, of the databse strutp trigger which is pinning too many

Received on Sun Sep 14 2008 - 09:46:00 CDT

Original text of this message