Oracle Note

If you encounter the issue where you simply query a table using 'select * from ' and it takes a long time only to return 0 row, you ...

The command 'alter system kill session' is not actually killing the target session (like kill -9 would do for OS processes). It just...

Tables created with logging or nologging clause will stay in that way. If the logging clause is not used when creating table (other than LOB...

This is a guest post by Dayid http://dayid.org There are better options to see your memory usage; however it seems `free` is more attune t...

Copied from here: http://askdba.org/weblog/2008/05/shutdown-immediate-hang-2/ Shutdown immediate can take long time to complete (appear t...

You can identify the Oracle session ID for an RMAN channel by looking in the RMAN log for messages with the format shown in the following ex...

This error can show up when trying to archive an active logfile but the logfile is unavailable. SQL> alter system archive log current; ...