Blog Aggregator - Amardeep Sidhu

I’ve been playing around with Native Oracle XML DB Web Services in Oracle 11g Release 1 for a while and I’ve finally decided to release the article.
One of the reasons it’s been on the back burner for some time is I’ve been having trouble with the anonymous access configuration. I’ve still not got this sorted, […]

Today I was upgrading 10gR1 to 10gR2 (10.2.0.1) on Linux x86. The upgrade went almost fine (except that I had to install one package and change few kernel parameters) but while running DBUA to upgrade databases, it gave an error:

Could not get database version from the Oracle Server component. The CEP file rdbmsup.sql does not […]

Today I have delivered two presentation @ the
 yearly conference of the Swiss Oracle Usergroup.
The topics were :
- Real Application Testing with Oracle 11g
     REPLAY DATABASE and
     SQL PERFORMANCE ADVISOR
- SQL Plan Management and Automatic SQL Tuning in 11g
I have used my new courseware which
I have produced in the last few weeks for 11g New Features.
I offer […]

I saw Mary Ann’s interestingly titled post ” Lies, Damn Lies, and Statistics ” and had a read. The interesting part for me was the short discussion of the genesis and development around the Oracle secure coding standards that currently….[Read More]

Posted by Pete On 13/02/08 At 09:11 PM

SQL Server has a variety of features that let developers and DBAs take advantage of minimally logged inserts and leverage the Bulk Copy API. This is an extremely important area to understand when doing large data loads or moving data between tables, databases, or servers, but I have found that many DBAs don’t understand what’s […]

I recently imported the contents of an Oracle 8i database into an 11g database. Since the original application needed to query a MS SQL Server database, I had to set up generic connectivity, which among other things, allows , the Oracle database to connect to non-Oracle databases for DML operations. The external database is referred […]