buffer cleanup on exit?

For questions and postings not covered by the other forums
User avatar
ghosttie
Posts: 181
Joined: Sat Aug 15, 2009 1:25 am
Location: Atlanta, GA, USA
Contact:

buffer cleanup on exit?

Postby ghosttie » Thu Jan 19, 2012 9:53 pm

I noticed lines like this in my jommsg.log:
2012/01/19 09:45:21.075 028f0-3c44 TDB: buffer cache: 2097152 byte heap, buffer cleanup on exit disabled (default), hash modulus = 2042
Any idea what it's talking about? I couldn't find a reference to it in the help files.
I have a catapult. Give me all the money or I will fling an enormous rock at your head.

GerardO'Brien
Posts: 12
Joined: Tue Jul 07, 2009 9:49 am

Re: buffer cleanup on exit?

Postby GerardO'Brien » Fri Jan 20, 2012 7:35 am

It was found that process termination could take an awfully long time when database caches were very large in a 64 bit database server. Traversing the buffer pool and verifying the state of the buffers didn't cost much but cleanup, that is removing each buffer from control structures (list management etc), adjusting and checking accounting, and releasing each buffer back to the system (heap delete), was quite costly and was observed in some instances to add tens of minutes to shutdown times.

The operating system reclaims all resources when the process terminates so buffer pool (transient and persistent) finalise was changed to only perform state verification.


Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 23 guests

cron