My experience with ORACLE

Andy C has written a good article to backup and restore a db without a catalog. http://oracleandy.wordpress.com/rman-refresh-without-a-catal...

Finally installed 2 node, 2 instance RAC on my laptop after quite a number of trials. Followed Tim Hall's document to configure it. htt...

Recently bought a 2GB RAM/160GB Hard Disk laptop ('cos i failed miserably trying to install RAC on my 512MB RAM laptop) and tried to in...

sqlplus username/pwd@//hostname:1521/sidname Just another new feature in 10g

You a find a set of tutorials for RMAN backups. http://rmanbackups.blogspot.com/

http://www.metacafe.com/watch/130922/mike_tyson_k_o_show/

Ok..you traditional HOT backup (not RMAN backup) failed or you have killed the HOT backup. Then you have check if any of the files are still...

Here is how to reverse engineer the DDL commands. I've found this pretty useful sometimes. For example, in case you want to recreate the...

ALL ABOUT TABLESPACES Here is all that you might need to know about when working with tablespaces. I've just given the syntax taking onl...

Finally, i was able to install the ubuntu version of linux on my laptop successfully. Now, i've a dual boot system (linux and windows). ...

I was goin' through one of the blogs (forgot which one it was), but it mentioned that we can create virtual indexes. Basically, what it ...

Its been quite sometime i'm here. Well, moved on to a new job -- Fannie Mae, VA as a production suport DBA. But, here we go. I was tryin...

To kill a session in oracle, i generally use, alter system kill session 'sid,serial#'; (where i get sid, serial# by querying v$sessi...

To find the size of bytes allocated to a table: sql > analyze table emp compute statistics; sql > select num_rows * avg_row_len ...

I was trying to install oracle 10g on my personal laptop. Tried a couple of times without goin' through much of a documentation and fai...

Finally, the much awaited TOAD like software is released by oracle. Thanks to oracle for recognizing that they need to have a software like...

Problem Description: got this error when trying to read from a table/view: ORA-01114: IO error writing block to file name block %s ******Fr...

Here are some scripts, tips regarding the tablespaces. This script basically gives you all the tablespace info in a database. **************...

This blog is to demonstrate my experiences with oracle. planning to post the new things i learn.