Oracle Database Administrator's Guide, 10g Release 2 () Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. Oracle DBA Concise Handbook. Oracle DBA Concise 2nd Edition – updated for 10g & 11g .. Word format (PDF format is also available). So, you can. Oracle Database 10g Dba Handbook Pdf. Click to zoom the image Oracle Database 12c DBA Handbook Weight: Books Dimensions: Format of ebooks.
|Language:||English, German, Japanese|
|ePub File Size:||19.67 MB|
|PDF File Size:||19.80 MB|
|Distribution:||Free* [*Register to download]|
"Hi, im working in oracle 9i & updating to 10g. i am looking for ""Oracle Database 10g DBA Handbook "" rockmormoutermfog.ml could not find rockmormoutermfog.ml any of your have the pdf copy. He is the primary Internet database designer and an Oracle DBA at Lands' End in addition to authoring several certification study guides for Oracle 10g and. Pete has also passed all the Oracle DBA Certifications (Oracle7,. Oracle8, Oracle8i, and Oracle9i) 2 Installing Oracle Database 10g and Creating a Database.
This feature is specific to Oracle 10g.
Control Files The database can be associated with more than one control file. If the parameter is not set, the default is obtained based on the operating system. This parameter cannot be changed after the creation of the database. A larger data block results in more efficient performance of Oracle in a data warehouse. On the other hand smaller block size would be more appropriate for OLTP sessions. System Global Area System global area is made up of different pools of memory. These pools of memory are used to meet the memory allocation requests.
The lowest value assigned to this parameter is one. The number of processes mainly depends on the feature being used. The undo space is used to store the undo changes that were made to the database before they are committed.
These records are called undo records. This parameter enforces named user licensing. Otherwise user info stored in the PGA in dedicated server environment. There are four mandatory processes.
If any of these processes fail the instance will crash and have to be restarted!
Known as defragging or coalescing. Will write dirty blocks when one of the following occurs: The dirty list reaches a threshold value 2.
A process scans a specified number of buffers in the LRU list without finding a free buffer 3. A time-out occurs 4. Will write redo log buffer entries to the redo log files when: A commit occurs. The redo log buffer pool becomes one-third full.
Download Oracle Database 10g DBA Handbook (Oracle Press) by Kevin Loney (1-May-2005) Paperback
The DBWR completes cleaning the buffer blocks as during a checkpoint. A LGWR time-out occurs every 3 seconds. Is mandatory starting with Oracle 8. Oracle Database Files Data Files: Control Files: Parameter File: Password File: NONE - no unsecured privileged sessions because no password file exists.
Index of /programmation/Databases/Oracle/
Needed for remote-nonsecure connections. If a secure connection can be obtained you can use OS authentication. If no secure connection is possible you must use oracle method. Archived redo log files: Trace Files: Cursor also holds the status info for each sql statement.
Returns dataset into BIND variables. Criteria for reuse of execution plan: Referenced objects are identical. The types and names of variables are identical. The parsed execution plan must be in the shared pool at the same time the current sql statement trying to reuse it is looking for it.
Every block of a table is read into buffer cache until required row is found. This is called the modified LRU least recently used algorithm. Also for this section you must be familiar with various Server Manager line mode commands. Be sure you have fully examined all of these tools and know how to use them! Don't expect to just memorize what's in this document. This section presents a summary only and you should really know these tools inside and out!
This is the "bread and butter" of any Oracle DBA worth their salt. Good for running unatten "batch" operations because it can be executed from within a script. No continuation character is needed multiple line SQL statements. Can use command to run a script. Some server manager commands that do not require a connection to the database are: Know all the SHOW commands and what they display.
Contains various compone such as the OEM Console which contains a menu, launch palette, navigator, map, job system, and event system. Be sure you know what each of these modules does! The Performance Pack contains the following additional modules: Password Utility File - Used to password file for a database.
Managing an Oracle Instance Simple database startup events: Both are granted the DBA role. Use when a secure connection is not possible. This is the default for this parameter. The file is read at time of system startup.
Changes to the parameter file will take effect only after the database has been stopped and restarted. OEM needs to have a local copy of the parameters file to start a remote instance or db. However, OEM can also store multiple database startup configurations in it's registry and this removes the need to have versions of multiple parameter files stored on the machine acting as the OEM console.
You should know and be very familiar with the following parameters: Parameter file read, SGA created, background processes started, trace and alter files opened. Use for database creation. Used for DBA maintenance activities including full database recovery, renaming datafiles, enabling or disabling redo logging.
The DBA can alter the control file in this mode.
Control file is opened and info read but datafile and redo log files are NOT verified in this step. Used for database access for all users. Datafiles and redo log files are verified and opened.
Instance Recovery SMON will automatically perform instance recovery when opening up the database if database crashed or was shut down using abort. Rolls forward txns recorded in online redo log that have not been recorded in the data files.
Opens database before all roll forward txns have been applied. SMON rolls back any uncommitted txns.
Browse more videos
Database Shutdown Stages: Control file remains open. Trace and Alert Files Alert file contains a "log" of messages and errors. Alert file written do while Oracle instance is running. Records all db startups and shut downs.
Oracle will create an Alter file upon db startup if one does not exist. Monitor the Alter file to detect internal and data block corruption errors, monitor database startup and shutdown operations and view the nondefault values of other initialization parameters.
Trace files contain "dumps" created by background processes due to errors that occur during database processing. Trace files can also contain session process information dumped at the request of the user i.
Creating an Oracle Database: Be sure you have actually gone through the process of creating at least 5 different Oracle databases, using varying logfile configurations and parameter settings! Must have memory and sufficient disk space to start the instance and create the physical database files. Create a minimum of 2 control files located on separate physical disks. Multiplex place on separate physical disks groups of redo log files. Datafile locations should be based upon minimizing fragmentation separate into different tablesapces based upon data life span i.
Manual Database Creation 1. Determine unique value to be used for instance and database name and what the database character set will be. Create a password file 5. Use PFILE clause in the startup command to specify a parameter file that is not in the default location. If these values are changed the control file must be recreated.
When a create database command fails, shutdown the instance, manually delete all the files the unsuccessful create database command created, fix the errors and start again. Run script to create data dictionary and other post creation tasks. After database creation through step 6 above, the following exist: Redo log and control files 3. System rollback segment 5.
Be familiar with the difference between these 3 table types.
Maintaining the Control File: The control file contains: The control file has 2 sections: Reusable section is written to in a circular manner similar to that for redo-logs. Must recreate the control file to increase its size based upon new settings for parameters that affect it's size.
To add a control file: Shut down database 2. Start up the database. Maintaining the Redo Log Files Oracle server requires a minimum of 2 online redo log file groups to function properly. Each member in a log group is assigned an identical log sequence number each time Oracle starts to write to a log group. Current log sequence number values are also stored in the control file and all data file headers in order to synchronize and insure data integrity.
Sequential writes to the current online redo log by the LGWR process occur when either of the following happen: A commit occurs 2. A LGWR timeout occurs - one every 3 seconds. Before the DBWR process writes dirty blocks from the db buffer cache to the data files. When a logswitch occurs a checkpoint starts.
Expert Oracle Database 11g Administration
During a checkpoint: Dirty buffers in the db buffer cache that are identified in the log being checkpointed are written to data files by DBWR. CKPT updates the headers of all data files and it updates the control file to reflect the successful completion of the checkpoint.
A checkpoint occurs when: A log switch occurs 2. Instance is shutdown normal, transactional, or immediate 3. If set to zero 0 disables timeout checkpoints parameters.
Requested on the fly by the dba. To get redo log info: Status values: To relocate a redo log file: To drop a redo log member: If group is active, must force a log switch before dropping one of its members. Cannot drop the last valid member of a group.
Number of redo log files depends upon your system usage. If seeing many waits on a log group in the alter log, need to add another group.Be familiar with the difference between these 3 table types.
The global database name is a concatenation of the individual database name and the domain name.
Used for DBA maintenance activities including full database recovery, renaming datafiles, enabling or disabling redo logging. Managing Temporary Segments: Database Shutdown Stages: