Blog Aggregator - Amardeep Sidhu

Today I have finished a condensed course for a bunch of DBAs from CERN. Again I had a group which I really could challenge and they also gave me a hard time by asking questions with an average of  3/minute at least I guess.
These people come from all over the world to work for CERN and […]

I am writing some chapters in a book on Oracle 11g New Features.
It is planned to be published at the beginnig of next year.
See more details on the book here!
We are a team of four authors working on it. The others are:
- John Garmany, Steve Karam, and V.J. Jain
Table of Contents:
John Garmany
Steve Karam
V.J. Jain
Lutz […]

Most of you folks would have heard all the 11g hype: we’ve been bombarded with it for weeks now!

Almost all of it is just more marketing blurb, rehash of old functionality with a new gloss paint, same-old-same-old “you don’t need no dbas” nonsense, etcetc.

However, IMHO this is truly amazing!

Thanks for pointing this out, Patrick. If it works indeed like this and Doug Burns says it does, it’s

This week I have delivered a workshop on backuo and recovery for Oracle University in Geneva.
Next week I will also be in Geneva at the World Trade Center and teach a bunch of DBAs working for CERN again.
This is going to be fun I guess. We will squeeze 10 days of normal training into five days […]

While working on another problem, I found this interesting little tidbit with Materialized Views querying views on Oracle 10.2.0.3.

One one db, I have a table called xyz_rtab. The table structure doesn’t really matter, it’s just any table with a primary key. Then, I create a view on top of the table:

db2> create view xyz_v1 as select * from xyz_rtab;

View created.

Why do that? Well, my table is not really a table in my environment. The view on top of the table is really refactoring a business object that is used by several systems but whose time has come to change. But it doesn’t matter, for the purposes of this demonstration.

Next, I change dbs and create the database link I’ll use to get this data.

db1> create database link db2 using ‘db2′;

Database link created.

Now, I query across that dblink to verify that I can actually see the data:

db1> select count(*) from xyz_v1@db2;

COUNT(*)———-     10

db1> select count(*) from xyz_rtab@db2;

COUNT(*)———-     10

If I can query the data I should be able to create a mview, right? Lets try from the base table:

db1> create materialized view xyz_rtab_mview as select * from xyz_rtab@db2;

Materialized view created.

db1> exec dbms_mview.refresh(list=>’xyz_rtab_mview’,method=>’C',atomic_refresh=>true);

PL/SQL procedure successfully completed.

No problem, that’s what we expect. Now lets try from the view:

db1> create materialized view xyz_mv1 as select * from xyz_v1@db2;create materialized view xyz_mv1 as select * from xyz_v1@db2*ERROR at line 1:ORA-00942: table or view does not existORA-06512: at “SYS.DBMS_SNAPSHOT_UTL”, line 960ORA-06512: at line 1

Nice.

Today I have received an E-Blast from Oracle University Switzerland.
Here is a slightly modified version which you can use to register directly for any of these events through sysdba database consulting GmbH from
here
Oracle University is pleased to bring you a preview of

Oracle Database 11g

through three brand new courses given by

Lutz Hartmann - Oracle ACE 
 Oracle Database 11g: New Features Overview […]

Today I was informed about a very strange incident for which I cannot really believe that it can be true:
On July 13th. John Leyden published a post on THEREGISTER in which Oracle U.K. is accused to host computers from which SSH brute force password attacks are launched against servers which run SSH software since May 3rd. […]

As promised I will continue with my series of posts about top 11g new features.
After talking about the SQL Analyzer (Sql Replay) in part I of this series I will continue with another Change Management functionality Oracle database 11g ships with. It is called Replay Database. 
This is one of the very big highlights of Oracle database […]

Sorry for the delayed conclusion folks, been incredibly busy with a Peopletools 8.48 upgrade. Did you know that DESC indexes are actually FBIs? Create one and then check out the USER_IND_EXPRESSIONS view!

Was quite surprised when suddenly nearly 8000 indexes sprouted an entry there with only the column name string as the expression: didn’t even know that was possible. But yes, that is a DESC

Rows per Exec There is a section titled “SQL ordered by Gets” in statspack reports. This section reports the sql statements performing most of the buffer gets. CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
————— ———— ————– —— ——– ——— ———-
One