RE: startup takes long time on 10gR2.
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 14 Sep 2008 09:46:00 -0500 (CDT)
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.
Thanks,
Rich
> I found it.
>
> its becoz, of the databse strutp trigger which is pinning too many
objects.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
