My experience with ORACLE

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.