view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Free ANSI SQL to Oracle Specific SQL Translator and SQL Tutor

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 [...]

Checking Database Growth Trend

One of the simple way to find the growth of the database is using v$datafile view.

VirtualBox Command Line

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 [...]

Can You Really Create A Business Logic Layer?

The past three posts of this little mini-series
have gone from a Working definition of business logic
to a Rigorous definition of business logic
and on to some theorems about business logic.
To wrap things up, I'd like to ask the question,
is it possible to isolate busin

Oracle GoldenGate and Compressed Tables

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 V11.1.1.0.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

Example :

Super Charge your Oracle Standard Edition database

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 [...]

SQL Profiles Disable Automatic Dynamic Sampling

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 [...]

Spin tales: Part 1. Exclusive latches in Oracle 9.2-11g

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 [...]

What is the default for a METHOD_OPT value using SIZE REPEAT?

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.

SOAP Server in PL/SQL

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.

view counter