January 7, 2011 In a recent OTN thread a developer described their difficulty in working with ANSI SQL in Oracle Database 8i (quick show of hands, how many people know why?). The OP eventually asked: “I don’t suppose there are any normal-query-sytax-to-freakishly-old-syntax converters out there?” And John Spencer jokingly replied back: “Personally, I’m looking for a freakishly-new-syntax-to-normal-query-sytax [...]Jan 07, 2011 7:02am
One of the simple way to find the growth of the database is using v$datafile view.
I have manually configured VirtualBox Host-Only Ethernet Adapter for static IP. However, the IP can change after reboot which affects connectivity with the Guest with static IP. I have not been able able to figure out why. However, one method to resolve this is to add the following commands in a batch file and have [...]
OGG does not support compressed tables or partitions, neither does it handle it well with proper error messages until OGG v10.4. The abends may or may not produce any error message and sometimes produce wrong messages.
From V220.127.116.11.0, Oracle has enhanced the error handling part in BugDB 9425542, which gives meaningful error message on the compressed record before Extract abend. It will list out the table name, rowid, etc
Achieve enterprise class database redundancy, service levels and performance with Cintra’s SuperCharged Oracle Standard Edition solutions. Wednesday, Jan 19th, 2011 10am EST, 3pm GMT (1 Hour) Presenter: Abdul Sheikh, CTO Please join Cintra, a Dbvisit partner, for a live Webinar exploring the significant benefits of SuperCharged Oracle Standard Edition solutions. While Oracle Standard Edition and [...]
I had an interesting email exchange with a fellow Oracle practitioner, Bryan Grenn, about differences between SQL Profiles and Baselines last week. Basically Bryan observed that SQL Profiles appeared to disable Dynamic Sampling on Global Temporary Tables while Baselines did not. This caused the optimizer’s cost calculations (and therefore the estimated elapsed runtimes) to be [...]
How does Oracle process spin for a latch? How many times does it check the latch before going to sleep? Anyone knows. This is the _spin_count=2000. Two thousand cycles by default. Oracle established this value long ago in version 6 at the beginning of 90s. However, let me count. My previous investigation showed that latch [...]
Past experience has always led me to believe that a METHOD_OPT value of “FOR ALL COLUMNS SIZE REPEAT” would default to “SIZE 1″ on columns without statistics. I have never explicitly tested this default however so this is the quick test I did to put my mind at rest.
First we create a test table that, being new, has never had any queries on it. Therefore “SIZE AUTO” should not create any histograms.
Or how to expose PL/SQL packages as SOAP web services using pure PL/SQL
I have blogged before about the various options available for both consuming and exposing SOAP web services using PL/SQL.