view counter
Home

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.

Blogroll Report 05/02/2009 – 12/02/2010

<—- Blogroll Report 29/01/2010 – 05/02/2010 1-How to simulate Oracle errors with simulator events Dennis Yurichev-Oracle RDBMS internal self-testing features 2-How to decode dates in histograms? Martin Widlake-Format of Date Histograms 3-How to decide the value of datafile resize option ? Jonathan Lewis-Shrink Tablespace 4-All about network wait events Kyle Hailey-Oracle: Network Waits 5-When does [...]

Mar 09, 2010 6:27pm

Oracle GoldenGate – Using the Director Client

To start the GoldenGate Director Server, we need to run the startWebLogic.sh script located in the “domain” sub-directory of the GoldenGate Director Server software installation directory.

[oracle@redhat346 bin]$ cd /u01/oracle/gg-director

[oracle@redhat346 gg-director]$ ls
cds_current_db_config.xml cds-tool-error.log cds-tool.log domain domain-new.jar ggs.url notices.txt uninstall

[oracle@redhat346 gg-director]$ cd domain

[oracle@redhat346 domain]$ cd bin

Mar 09, 2010 4:54pm

Oracle Database to SQL Server Comparisons

One of the initial obstacles a database administrator encounters is learning where features of his/her system live or reside on a less familiar system. Steve Callan approaches this feature comparison by taking SQL Server and mapping its features back into Oracle.

Mar 09, 2010 12:46pm

Cardinality of table collection expression

Table collection expression has been in Oracle for more than 10 years. It is handy for passing an array to Oracle. Quite often, though, there is was a well-known problem with a default cardinality associated with table collection expressions used in the SQL. The problem is Oracle considers a default cardinality based on the database’ [...]

Mar 09, 2010 12:37pm

Hotsos Symposium 2010 — Battle Against Any Guess Is Won

Video fragments of my session posted at the end — read on.
I arrived at Omni Mandalay Hotel on Sunday evening with Dan Norris. I was flying through Chicago and it turned out that Dan was on the same flight and only few rows behind me. Small world.
Preparations for the conference were very chaotic on my [...]

Mar 09, 2010 12:16pm

Spatial/Oracle Maps Events March 17th 2010 in Düsseldorf - April 20th Frankfurt

An interesting event will take place in Düsseldorf March 17th - organized by CISS TDI and supported by Oracle Carsten Czarski as well as some guestspeakers from
- Kommunale Datenzentrale Westfalen-Süd,
- Hessisches Landesamt für Bodenmanagement und Geoinformation (ALKIS im Webgis Einsatz),
- Landesamt für Umwelt, Wasserwirtschaft und Gewerbeaufsicht, Rheinland-Pfalz.

Mar 09, 2010 11:20am

Fun with Filters

{Please note – this post has been used to test changes to layout, thus the duplicated sections}
This post is about the importance of filter statements in execution plans and how they can indicate problems that are not always apparent.
I had a problem recently with some code that had gone rogue – it had been running [...]

Mar 09, 2010 11:15am

A brand-new Oracle product???

Just came across these yesterday in the Yarra Valley Dairy (which by the way had excellent goat cheese) and still ask myself if Oracle is emerging now into new markets:2010_03_09_Melbourne5.jpgStill wondering ... you'll never know ...

Mar 09, 2010 6:04am

Thanks Melbourne!!!

We had a great time today with you all - and thanks to the local Oracle folks as well who'd organize everything so well. And the view from the top floor was the best we've ever had in a workshop so far :-) Hope you all start your upgrade to 11g Release 2 pretty soon - and we'll be very happy to get your feedback once you've gone live.

Mar 09, 2010 5:57am

Clustering Factor: Row Migration’s Victim

This article describes the effects of a high row migration rate on the clustering factor and the optimizer’s ability to select the best execution plan. In my previous article—Row Migration and Row Movement—I have demonstrated that the “insert empty, update everything” anti-pattern can lead to 100% row migration. This article continues the research on row [...]

Mar 09, 2010 2:15am
view counter