currently installing oracle 11g

..iSSUES...Where the we needed to update not only sysctl.conf file for kernel parameter
but also limits file in etc folder

set the variables in unix..
Still the installation is not complete i am facing some trouble while using net config assistant
changed the host name from local. to cpisolution.com

moved from oracledbavoyager to dbavoyager.blogspot.com

I have just moved from oracledbavoyager.blogspot.com to dbavoyager.blogspot.com

I will be currently blogging in that site
Thanks
Paul j

reverse key indexes

IN Reverse key indexes the values are stored in reverse format..
The advantage of reversekey index will be
1 It is good for inserts where say primary key is comign in sequence. ..
2 It is used where there is lot of concurrency .. useful in rac where there is lot of contention
3) Also rebuilts not need to be done on reverse key index

4) It is not useful for range scan

The following site has good notes and more details on it
http://users.telenet.be/oraguy.be/reverse_key_indexes.htm

usage of trace 10053..

Use the following command to trace on a sql statement a user is executing
Alter session set event s'10053 trace name context forever 1' ;

To stop trace use the command
Alter session set event s'10053 trace name context off;
The trace gets generated in user_dump_destinatino...


Now the parts of the trace file
Query
Parameter used by optimizer
Base Statistical Info
Base Table Acces Cost
General Plan
Reosting for sepcial featur

There are very nice articles written on tuning in the following
website
www.hotsos.com

time wasted on my cab software.

woke up 8 am ..time from 9 am to 12:30 wasted by my client..

came across 2 more new sites...
1...http://eternal-donut.blogspot.com/
owner of pictural company in australia.. he is a oracle ace..
and he owns this site
His site has contents for sotring multimedia .. in oracle

2...
Richard Foote is another oracle ace...and he has gone in depth in oracle dba tuning
http://richardfoote.wordpress.com/
He is currently in Australia..

Hello in this blog i will mention how ..i get my new job..
I am aiming for a senior level oracle dba job.. I have some plans to execute
like i need to be a ocm soon, oracle ace, be a rac expert, get skills in 11g , give a upgrade certification on it , know oracle apps...
I do have application development skills too..I know olap and also apex..

Today i am revising Rman ..And came on some notes on ...how to use rman ..with emc
..I think it does the work like a real application cluster .. Or might be the future version of rac will have these facilities..
These facilities could be used for taking backup of very large databases. We need to check
the following site to know more about it...
http://www.myexpospace.com/OracleDemogrounds2008/PDFDOCLIB/oowh4262-red-backup-wndw-rcvry-time-oracle-11g-rman-timefinder-clone-wp.pdf