It is very easy: I want my databases to consume as much memory as they need. But not more than a reasonable amount. And I want Automatic Memory Management and Automatic Shared Memory Management both enabled. Easy you say?
Ok, you’re right – but only if you are a full time Oracle database admin with a long, long time experience. Me, I’m a part-time DBA, with an outside view on the instances. For example, I’m writing scripts to automate the creation of instances, upgrade software and instances to new releases aso.
So I stumbled upon the . In chapter 7, I’ve found what I was looking for (reading the first 5 pages of this chapter). I’ve adapted one of my databases’ pfile and gave it a try.
From now on I will always set
memory_target=4294967296 to enable the Automatic Memory Management. And I will set
Hey, stop complaining: I know I should *not* set sga_max_size. But if I don’t do, querying the database for this parameters’ value it says “Dude, it’s equal . And so a simple show sga shows me values, which I don’t like.
This database instance has a small memory footprint now, nearly what I wanted to achieve.
BTW. All other params (db_cache_size,shared_pool_size,large_pool_size, and java_pool_size) have not been set in the pfile.
Happens if more than a number of jobs need to be started. It is specified in
/etc/cron.d/queuedefs in the line starting with
# cat /etc/cron.d/queuedefs
(found in C QUEUE MAX RUN LIMIT REACHED)
Nice article at triathlete.com about Sebastian Kienle’s Start at Xterra race Maui. And an interesting view on his _strategies_ during races (like “always give 101 percent“) and after the race period.
To have a Dash Search and Files tab, it helped me to
# sudo apt-get install unity-place-applications unity-place-files
Found in http://askubuntu.com/questions/125843/dash-search-gives-no-result
# dpkg --get-selections| grep -E "linux-(header|image).*3." | grep -iw install | sort
lists the current installed linux-(image|headers) packages:
On my system I will just keep the current and the one before that:
# apt-get remove --purge 3.2.0-30
It will remove the packages
BTW. Found this info in another blog, but cannot remember where nor when, sorry …