Index Access best approach?? Not Always…
There is a common misconception that Index access is the best access method for query execution. This approach leads to people concentrate on removing Full Table Scans (FTS) from the…
Read Full Recipe
How To Change/Restore User Password in 11G
Oracle 11g introduces Case-sensitive passwords for database authentication. Along with this if you wish to change the password (temporarily) and reset it back to old , you will find that…
Read Full Recipe
Tom Kyte Seminar in Bangalore, India
All India Oracle user Group (AIOUG) has arranged for Seminar by Tom Kyte on 18th December 2008. Venue- The Good Shepherd Auditorium Residency Road- Museum Road Junction Opp. St. Joseph's…
Read Full Recipe
10g RAC Tuning :Useful Link
I came across useful link which contains 10g RAC Tuning tips from Joel Goodman (Oracle). It discusses RAC Instance Recovery concepts and key things to look out for while tuning…
Read Full Recipe
Full Database Export Failing With ORA-00980
While trying to do a full export for 10.2.0.3 database, we were getting following errors About to export the entire database ... . exporting tablespace definitions . exporting profiles .…
Read Full Recipe
Question:Sizing ASM LUN
We received following question from Mr Orlando through our Contact Page How about a discussion on how to size our LUNS to use with ASM. For instance we have a…
Read Full Recipe