otechno.blogspot.com
Ontario Technoblog: October 2006
http://otechno.blogspot.com/2006_10_01_archive.html
Comment-link {margin-left:.6em;}. Ontario Emperor technology blog. This blog has been superseded by the mrontemp. Ontario, California, United States. Sometime audio artist. Email comments on this blog to the gmail account mrontemp. View my complete profile. Online Tools (My Idea of Fun). Wednesday, October 25, 2006. Oracle Database 11g Additional Blog Coverage. Here's what others have written about Oracle Database 11g (or whatever the database after 10g will be called). If the key theme of 10g was "lower...
phat4oracle.wordpress.com
Phat on RAC ? | Phat4Oracle
https://phat4oracle.wordpress.com/2007/12/12/phat-on-rac
General information about performance analysis. Getting started: installing and first results. Using Phat4Oracle, how? 12,841 performance problems. December 12, 2007 — Bas. 2 Responses to “Phat on RAC? June 17, 2011 at 10:37. Can you share with us, how to you configured and run Statspack in your RAC system? June 21, 2011 at 7:48. Just create a dbms job for each instance:. What = ‘statspack.snap;’. Next date = TRUNC(SYSDATE 1/24,’HH’). INTERVAL = ‘TRUNC(SYSDATE 1/24,”HH”)’. No parse = TRUE. Doug’s O...
phat4oracle.wordpress.com
Strange choice of execution plan | Phat4Oracle
https://phat4oracle.wordpress.com/2007/11/10/strange-choice-of-execution-plan
General information about performance analysis. Getting started: installing and first results. Using Phat4Oracle, how? 12,841 performance problems. Strange choice of execution plan. November 10, 2007 — Bas. Complaints were that a batch was not performing well, and one thing led to another. Queries which were done were of the most simple form:. Select columns from table where unique id = value. Delete from table where unique id = value. Cost was lower, why did the optimizer not choose for the index plan?
phat4oracle.wordpress.com
Advantages & disadvantages | Phat4Oracle
https://phat4oracle.wordpress.com/non-tech/advantages
General information about performance analysis. Getting started: installing and first results. Using Phat4Oracle, how? 12,841 performance problems. No need to install agents. No need to run a performance warehouse. No need to hire consultants to implement. No extra clients to install. No direct memory access for fine grained monitoring. You need a query tool (like Toad), which can be used to copy paste data to Excel. You need a graph tool like Excel. A little work has to be done to produce a graph. You a...
phat4oracle.wordpress.com
Getting started: installing & first results | Phat4Oracle
https://phat4oracle.wordpress.com/tech/getting-started
General information about performance analysis. Getting started: installing and first results. Using Phat4Oracle, how? 12,841 performance problems. Getting started: installing and first results. Before start using Phat to do some analysis, it’s important to be aware of a few things. Running the Phat queries on top of the Phat views and Perfstat tables isn’t a lightweight operation. We are not talking about a few OLTP queries here, we are allmost doing heavy warehousing on a schema! Make sure you have som...
pbarut.blogspot.com
Software Engineer Thoughts: XMLType and Namespace problem
http://pbarut.blogspot.com/2006/11/xmltype-and-namespace-problem.html
My thoughts about developing software. Problems descriptions and solutions, tips, tricks, links to useful resources. Mostly on Oracle, but also PHP, Delphi and other languages and tools. List of Blogs maintained by Paweł Barut. Tuesday, November 07, 2006. XMLType and Namespace problem. I've run into some strange problem with XMLType and XML namespaces. I'll try to make a showcase. Lets define variable and simple XML content. SQL var x varchar2(200);. SQL exec :x := ' feed. Lets find out the namespace:.
pbarut.blogspot.com
Software Engineer Thoughts: Rolling Back the DDL
http://pbarut.blogspot.com/2006/09/rolling-back-ddl.html
My thoughts about developing software. Problems descriptions and solutions, tips, tricks, links to useful resources. Mostly on Oracle, but also PHP, Delphi and other languages and tools. List of Blogs maintained by Paweł Barut. Sunday, September 10, 2006. Rolling Back the DDL. Issue command to set restore point:. CREATE RESTORE POINT before patch GUARANTEE FLASHBACK DATABASE;. Test system after patch. If ok, release restore point:. DROP RESTORE POINT before patch;. Select * from v$restore point;. Flashba...
pbarut.blogspot.com
Software Engineer Thoughts: What a news! Oracle Buys Sun !
http://pbarut.blogspot.com/2009/04/what-news-oracle-buys-sun.html
My thoughts about developing software. Problems descriptions and solutions, tips, tricks, links to useful resources. Mostly on Oracle, but also PHP, Delphi and other languages and tools. List of Blogs maintained by Paweł Barut. Monday, April 20, 2009. What a news: Oracle Buys Sun. I'm not the first one that blogs about it, but anyway let me express my comments. What does it mean for IT:. 4 Oracle now owns 2, ehh, 3 databases: Oracle, Berkley XML DB and now MySQL. I could mean that MySQL will get even...
pbarut.blogspot.com
Software Engineer Thoughts: Useful links on Oracle XML DB
http://pbarut.blogspot.com/2008/02/useful-links-on-oracle-xml-db.html
My thoughts about developing software. Problems descriptions and solutions, tips, tricks, links to useful resources. Mostly on Oracle, but also PHP, Delphi and other languages and tools. List of Blogs maintained by Paweł Barut. Monday, February 18, 2008. Useful links on Oracle XML DB. Here is bunch of useful links related to Oracle XML DB and handling XML data in Oracle PL/SQL. It's mostly for my own reference, but I hope it will be useful for others too. How do i store the counts of all tables. Eric S&#...
pbarut.blogspot.com
Software Engineer Thoughts: How to shrink Oracle Context Index
http://pbarut.blogspot.com/2008/01/how-to-shrink-oracle-context-index.html
My thoughts about developing software. Problems descriptions and solutions, tips, tricks, links to useful resources. Mostly on Oracle, but also PHP, Delphi and other languages and tools. List of Blogs maintained by Paweł Barut. Wednesday, January 23, 2008. How to shrink Oracle Context Index. This was my first though:. Drop Index . /Create Index . Or Alter Index . Rebuild. But those methods have some disadvantages:. Users cannot perform text searches during this operation,. But this operation requires to ...