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.
sureshbsk.blogspot.com
Evolution in BI :-> OBI, Noetix, Tableau, & Pentaho <-: Exadata , Denodo & Redshift: WEB RESOURCES FOR ORACLE BIEE ANALYTICS
http://sureshbsk.blogspot.com/2008/03/web-resources-for-oracle-biee-analytics.html
Evolution in BI :- OBI, Noetix, Tableau, and Pentaho -: Exadata , Denodo and Redshift. Siebel Anlaytics (7.5.2 ) - OBI 12c, Tableau 9.1.2 Administration, Pentaho BA 6.0, Denodo 5.5, Amazon Redshift and PostgreSQL. Monday, March 31, 2008. WEB RESOURCES FOR ORACLE BIEE ANALYTICS. Dashboards, Applications and BI. OBIEE 10g (10.1.3.x). Labels: Oracle BIEE Analytics. Subscribe to: Post Comments (Atom). WEB RESOURCES FOR ORACLE BIEE ANALYTICS. View my complete profile. Travel template. Powered by Blogger.
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...