Personal tools
You are here: Home
« July 2010 »
July
MoTuWeThFrSaSu
1234
567891011
12131415161718
19202122232425
262728293031
 

Welcome back to Lotuseyes!

Ooops! I did it again! I changed the site!

All your old Links are broken, sorry for that, honestly! But I had to do it. I found out that I'm not a wiki guy nor am I a blogger. Just can't use these sytems in an effective way for my purposes. I tried! I really tried. But I failed. Now I finally admited to that and installed a CMS. Here it is. Have fun!

Latest Submissions:

Document Display Sessions
Sometimes it's handy to get an overview who ist connected to the database. This script gives you a brief overview and aggregates same user and machine.
Document Error installing Plone on OpenSolaris using the Unified Installer
The Unified Installer builds and installs a specific python version that will be used by the zope instance providing plone. Unfortunately python gets built lacking some crucial features required by plone and so the install fails on open solaris.
Document WARNING: mismatch_cnt is not 0 on /dev/mdX
Occasionally I receive the above message from various LINUX machines. They appear as output of a cron job.
Document Calculate Freespace in ASM
Strange enough it is not obvious to what extent the freespace in an ASM-Diskgroup ist being used. The answer will always be: "It depends!". Here I'll provide a query that should give you numbers an a way that you'll be on the save side.
Document Disable Oracle Password Security
Sometime it may be necessary to disable the password security to enable tools or scripts to install properly.
Document Oracle Disk-IO Assessment
When analyzing the performance of an Oracle RDBMS in many cases one may want to take a look at on how the IO subsystems perform. Actually there has not been one situation in my carreer as an DBA when I was confronted with a performance issue that was not related to either disk or network IO. Therefore it is vital for a database sysstem in order to stay healthy to regularly assess the IO-performance.
Document Calculating Buffer Cache Hit Ratio
In oder to determin weather the SGA ist apropriately sized, the most importent piece of informaiton is the Buffer Cache Hit Ratio.
Document SQL Developer getting ora-00942 at session start
We had the crazy situation that every time we loged into one specific database, we received ora-00942. One could just click OK and continue working as usual. Still it was annoying and we wanted to get rid of it.
Document Extending ASM Space for an Oracle DB
Today one of our databases reached the critical threshold of 80% in the ASM-Diskgroup that holds the datafiles.
Document Actions