vidyabala.blogspot.com
Vidya Bala's Blog: September 2007
http://vidyabala.blogspot.com/2007_09_01_archive.html
Thursday, September 20, 2007. OC4J ping timeout issues. We recently went with a Jdev. Application Server 10.1.3. While the deployment went fine, a few days after the deployment we started noticing oc. 4j ping timeout issues in the opmn. Log After the OC. 4J ping timeout OC. 4J tries to restart itself. We checked the max heap size - the max heap size looks good. There is not much activity on the server so we feel the default ping timeout of 20 seconds should be sufficient. I don't. It can be a JDK.
vidyabala.blogspot.com
Vidya Bala's Blog: April 2006
http://vidyabala.blogspot.com/2006_04_01_archive.html
Tuesday, April 25, 2006. DRINK COFFEE AND PLOT AWAY YOUR DATABASE METRICS. How do you do it? Download gnuplot from http:/ www.gnuplot.info/ to generate your postscriptfile and imageprick to convert your postscript file to gif http:/ www.imagemagick.org/script/install-source.php. Download gnuplot-4.0.0.tar.gz. Move the binaries to your database server. Untar the file ./configure will configure gnuplot for you on your server. Gunzip -c ImageMagick.tar.gz tar xvf. LOAD NAMESTART TIMEEND TIMELOAD DATE. EXEC ...
vidyabala.blogspot.com
Vidya Bala's Blog: November 2006
http://vidyabala.blogspot.com/2006_11_01_archive.html
Monday, November 27, 2006. Recover database until cancel and online redo's. On a noarchivelog mode database, recover database until cancel will still prompt for archive logs. This had me puzzled initially until I looked at the sequence number and realized, the sequence number corresponds to the online redolog (although the recovery command prompted for an archive log). When prompted if the appropriate online redolog is entered the Incomplete recovery will succeed. Wednesday, November 22, 2006. The PowerC...
vidyabala.blogspot.com
Vidya Bala's Blog: October 2006
http://vidyabala.blogspot.com/2006_10_01_archive.html
Tuesday, October 31, 2006. Better now than never buffer busy wait challenges and data block class. Object contention Buffer Busy waits? Tablespaces have no ASSM set? I have a RAC instance with a 30million row OLTP table that is not Partitioned (this is our most used table and since we have a Standard edition license partitioning right now is not an option until we get budget for Enterprise edition ). Select event,time waited,. Round(time waited*100/SUM (time waited) OVER(),2) wait pct. Where event NOT IN.
vidyabala.blogspot.com
Vidya Bala's Blog: September 2006
http://vidyabala.blogspot.com/2006_09_01_archive.html
Friday, September 29, 2006. DON’T JUST COLLECT STATSPACK DATA PUT THEM TO USE. Posted by Vidya Balasubramanian at 12:50 PM. DBA tips / tricks and examples (Oracle and SQL Server). Oracle consultant since 1998 for large State and Commercial organizations. All openions in this blog are based on my experience as a DBA and is not necessarily that of Oracle or its affiliates. Currently live and work in Austin, TX. View my complete profile. OC4J ping timeout issues. A Strange Production Problem!
vidyabala.blogspot.com
Vidya Bala's Blog: February 2007
http://vidyabala.blogspot.com/2007_02_01_archive.html
Monday, February 26, 2007. A Strange Production Problem! A Strange Production Problem! I suddenly got a call that the Front end Applications have frozen (those are the worst calls.). I logged on to the database server, was unable to login to the database, at the same time got a call that the . Network Appliance filer experienced a kernel panic or a low-level system-related lockup. The device then rebooted itself to correct the problem and proceeded normally through the startup process. Each Oracle instan...
vidyabala.blogspot.com
Vidya Bala's Blog: April 2007
http://vidyabala.blogspot.com/2007_04_01_archive.html
Friday, April 13, 2007. Transferring System Statistics to a TEST environment. Can we transfer system statistics from a Production environment to a Test environment? Is it not possible to Gather System Stats in Production into a Staging Table , export the staging table to the Test environment and then import the Stats into the data dictionary in Test? Even if the above is possible , some key questions still remain while gathering System Stats into a Staging Table in Production -. Wednesday, April 11, 2007.
vidyabala.blogspot.com
Vidya Bala's Blog: August 2006
http://vidyabala.blogspot.com/2006_08_01_archive.html
Tuesday, August 15, 2006. Building your Dashboard at work Oracle HTML DB. I used to spend a lot of time on email/phonecalls - answering some of the frequently asked questions. When was preprod /test/dev1/dev2/test.refreshed? What Application db patches do we have on the different environments? When different Application db patches were applied to different environments? DB release notes for the different patches? Results of different load and datafix runs? Schedule for load runs? I found a quick way to p...
vidyabala.blogspot.com
Vidya Bala's Blog: December 2006
http://vidyabala.blogspot.com/2006_12_01_archive.html
Thursday, December 28, 2006. 10G SQL Access Advisor and SQL Tuning Advisor. I was able to take advantage of the holidays to complete a 9i to 10g cross platform migration. While I was quite happy with the migration process (especially on how datapump has made this effort much easier), I was a little bit disappointed on what SQL Access and SQL Tuning Advisor had to offer. The Recommendations I got were far from anything of significance (eg: add an index to a small lkup table). Thursday, December 21, 2006.