Download OCA/OCP: Oracle9i DBA Fundamentals I Study Guide by Biju Thomas PDF

By Biju Thomas

-Your key to achieving certification in Oracle's made over DBA music! -Contains examination necessities, real-world situation sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD contains flashcards, chapter-by-chapter assessments, randomly gen

Show description

Read Online or Download OCA/OCP: Oracle9i DBA Fundamentals I Study Guide PDF

Best oracle books

Oracle DBA Scripting Quick Reference

# quick, effortless automation for each Oracle 9i and 10g DBA! # easy accessibility to real-world examples# install, database construction, administration, tracking, tuning, and backup/recovery# Oracle common Installer (OUI), Oracle internet Configuration Assistant (NetCA), and Oracle Database Configuration Assistant (DBCA)

OCP Oracle9i Database: New Features for Administrators Exam Guide

Arrange to cross the Oracle9i qualified specialist DBA New beneficial properties for directors examination utilizing this Oracle Press research consultant. you will get entire insurance of all examination issues by means of perform questions and bankruptcy summaries. The CD-ROM includes hundreds of thousands of perform examination questions in an adaptive layout.

OCA/OCP: Oracle9i DBA Fundamentals I Study Guide

-Your key to achieving certification in Oracle's made over DBA song! -Contains examination necessities, real-world situation sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD comprises flashcards, chapter-by-chapter assessments, randomly gen

Pro ODP .NET for Oracle Database 11g

This booklet is a entire and easy-to-understand consultant for utilizing the Oracle facts supplier (ODP) model 11g at the . internet Framework. It additionally outlines the middle GoF (Gang of 4) layout styles and coding concepts hired to construct and install high-impact mission-critical purposes utilizing complex Oracle database good points during the ODP.

Extra resources for OCA/OCP: Oracle9i DBA Fundamentals I Study Guide

Example text

Database users are able to be more self-sufficient with the new features of LogMiner and Oracle Flashback Query feature, maximizing database availability while reducing the dependency on the DBA for routine historical data requests. In addition, many of the operations that required the database to be shut down can now be done online with minimal impact to ongoing user activity. com Summary 19 Many of the changes to the Oracle9i architecture facilitate both the performance and scalability of the Oracle server.

This chapter begins by discussing the components that constitute the Oracle database and the way the database functions. Administering an Oracle database requires that you know how these components interact and how to customize them to best suit your requirements. Oracle9i Server: An Overview The Oracle Server consists of two major components—the database and the instance. Database is a confusing term that is often used to represent different things on different platforms; the only commonality is that it is something to do with data.

The two new parameters are DB_CREATE_FILE_DEST and DB_CREATE_ ONLINE_LOG_DEST_n. The parameter DB_CREATE_FILE_DEST defines the default location for storing new datafiles associated with a given tablespace as well as for temporary files. The second parameter, DB_CREATE_ONLINE_ LOG_DEST_n, provides similar functionality except that this location is specified for new control files and online redo log files. You manage archived redo log files as you did in previous Oracle versions. Using OMF for one group of files does not prevent the DBA from continuing to use the older methods for naming files in the database; both methods can coexist nicely, and you can convert to a completely OMF-based database in stages.

Download PDF sample

Rated 4.96 of 5 – based on 4 votes