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:
- Latest Submissions:
-
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.
-
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.
-
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.
-
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.
-
Disable Oracle Password Security
- Sometime it may be necessary to disable the password security to enable tools or scripts to install properly.
-
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.
-
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.
-
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.
-
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.

