Archive for January, 2010

If you have several users waiting on a library cache lock, they are normally blocked by one user that is waiting on a library cache pin. You have to find out who is blocking the user waiting on the library cache pin and find out what they are doing. Our test case performs the... »

I have noticed this over the past few months, and think I still may be missing something. Given the following code… 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 #!/home/oracle/local/bin/python import cx_Oracle import sys   con = cx_Oracle.connect("howards","******","perfrac") con.cursor().execute("alter session set events... »

Using the find command in *nix is very useful. You can specify that you would like to find files newer than another file, or older or newer than a certain time. You cannot (directly) find files older than another file. However, there is a simple step that allows you to do this. Simply add... »

I inherited my dad’s penchant for tools. He frequently came home after work with a new screw driver or ratchet. He used baby food jars to organize excess nuts and bolts left over from projects past. I too, buy tools, sometimes ones I may not need immediately, but I *know* will come in handy... »

If you find yourself in the middle of a hung database, you can do what follows (see Metalink for additional information) Can login to the database 1 ALTER session SET events 'immediate trace name SYSTEMSTATE level 10'; --three time waiting five minutes between Can’t login to the database Either… 1 2 3 4 sqlplus... »