more

$value) { if (strpos($param, 'color_') === 0) { google_append_color($google_ad_url, $param); } else if (strpos($param, 'url') === 0) { $google_scheme = ($GLOBALS['google']['https'] == 'on') ? 'https://' : 'http://'; google_append_url($google_ad_url, $param, $google_scheme . $GLOBALS['google'][$param]); } else { google_append_globals($google_ad_url, $param); } } return $google_ad_url; } $google_ad_handle = @fopen(google_get_ad_url(), 'r'); if ($google_ad_handle) { while (!feof($google_ad_handle)) { echo fread($google_ad_handle, 8192); } fclose($google_ad_handle); } ?>

Saturday, March 17, 2012

THREE MOST IMPORTANT PARTS OF AN ORACLE DATABASE!

3:17 PM 0 comments

Before understanding the oracle database in depth, it is important to know the most important pieces in any database. This time we are discussing the oracle database.

  1. Storage - Think of it this way, your data needs to be stored in a table, which belongs to a logical area called table space and  a table space gets mapped to a physical file called a data file. (which essentially uses disk storage).
  2. Memory - This is called the System global Area (SGA) in Oracle.
  3. Processes - The third piece in an Oracle database is the disk processes.

Datafiles store tables, indexes and rollback segments (undo segments in 9i on wards) and temporary files. 

The most important logical  view for a DBA is the dba_data_files - this has information about the datafiles.

Another file that controls the structure of your database is your datafiles. It is recommended that you have at least 3 control files on sepererate disk drives. This shows how when your database got created etc All three control files need to look exactly alike.

There is a v$ that will tell you the path of your control file and this is the v$controlfiles.

0 comments:

Post a Comment