Hi all,
Haven't been tuning in much... that's the hazard of not getting the posting
directly to my mail-box anymore...
anyway...
I have seen IDS 9.4 (64 bit on Solaris) dynamically allocate locks.
It will do so, but not unalloc them. for example, if i have 1 mill locks,
and the activity blows past that, and IDS dynamically allocs more, say up
to 3.4 mill....
well after the dust settles, the 3.4 mill locks are still there, it didn't
auto-drop back to the defined number (1 mill). Bouncing the DB sets it
back.
Tonight, I have witnessed our first dynamic log allocation (woooo hoooo...
pass the cigars!)....
IDS put it in rootdbs. we added more log space, and it started using that
as it's so smart :)
but I could not find info in the online manuals about what happens after
IDS doesn't need those dynamically alloc'd logs....
i could not find that they would automatically unalloc.
I suspect they do not auto-unalloc, just like the dynamic locks did not.
I suspect I have to manually drop them.
I'm a bit squeamish about dropping anything in rootdbs.
Advice/education requested....
thanks,
Norma Jean
--
Message posted via http://www.dbmonster.com