More articles to come on this subject, this is just a small introduction. To effectively perform reactive tuning, it is vital to have an established baseline for later comparison when the system is running poorly. Without a baseline data point, it becomes very difficult to identify what a new problem is attributable to: Has the volume [...]

Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory (see SORT_AREA_SIZE initialisation parameter), space will be allocated in a temporary tablespace for doing the sort operation. Other SQL operations that might [...]

Starting in Oracle9i, rollback segments are re-named undo logs. Traditionally transaction undo information was stored in Rollback Segments until a commit or rollback statement was issued, at [...]

You have a tablespace that is growing out of control and you need to re org. this is a very lengthy subject but below are the steps you ll need to take in order to rename your datafiles, you can then trun off autoextend, and run a monitoring script to either: 1) Resize a current datafile and [...]

Every Database should have the screen below, It would let everyone know how important this is The only thing a DBA has to get right is recovery. In order to do that, they need the backups. -Again Thanks for reading

because when you own it, you own the world. You can literally do anything you want (given you have that privilege of course)… 1. Quick, what does the following Unix/Linux command do? ls -R | grep “:$” | sed -e ’s/:$//’ -e ’s/[^-][^\/]*\//–/g’ -e ’s/^/ /’ -e ’s/-/|/’ If you said, “Well, that’s obvious; it [...]

This is a two-step process. email if you have questions: fayoubi@gmail.com STEP ONE : Modify your initSID.ora Modify your initSID.ora to include the following three lines: log_archive_start   = true log_archive_dest    = /mount_point/oradata/SID/ARCHIVE/arch log_archive_format  = _%s.arc log_archive_start: This parameter specifies whether archiving should be started automatically when the database is started. log_archive_dest: This value specifies the default location of the file to be [...]

Does oracle really expect you DBAs to know every vdollar table by heart ? The answer is no. I have run into the issue so many times. specially if you are oncall and that big poster that has every table name etc… is in you cube and nowhere close to the terminal u are sitting in [...]

What: Pinning an Object to the shared pool area is the process of tellin oracle to leave an object in the shared pool at all time - unless the database is shutdown. Why: Pinning Oracle objects prevents oracle from doing moving objects in and out of the shared pool which can degrade performance (specifically if the [...]