05361nam 22006613u 450 991079206850332120210111233202.01-299-26152-31-84968-731-5(CKB)2560000000098669(EBL)1140145(OCoLC)830162786(SSID)ssj0000907253(PQKBManifestationID)11943956(PQKBTitleCode)TC0000907253(PQKBWorkID)10855343(PQKB)10503268(CaSebORM)9781849687300(MiAaPQ)EBC1140145(PPN)228013208(EXLCZ)99256000000009866920130418d2013|||| u|| |engur|n|---|||||txtccrOCA Oracle Database 11g Database Administration I[electronic resource] A Real-World Certification Guide1st editionBirmingham Packt Publishing20131 online resource (582 p.)Description based upon print version of record.1-84968-730-7 Cover; Copyright; Credits; Foreword; About the Author; About the Reviewer; www.packtpub.com; Table of Contents; Preface; Chapter 1: Introducing the Oracle Relational Database System; Understanding the RDBMS; The importance of databases; Flat file databases; Limitations of the flat file paradigm; A new paradigm; Introducing the Oracle product family; Exploring the history of Oracle; Understanding the Oracle Database product; Understanding the different editions of Oracle Database; Understanding Oracle Database options; Examining the Oracle product familyUnderstanding Oracle's hardware solutionsExamining Oracle virtualization solutions; Exploring Oracle operating systems; Examining Oracle Application Servers; Interpreting Oracle Database versioning; Understanding the role of the DBA; Examining the tools of the Oracle DBA; SQL*Plus; Oracle Enterprise Manager; TOAD; DBArtisan; Oracle SQL Developer; Introducing the Companylink database; Summary; Test your knowledge; Chapter 2: Installing the Oracle Database Software; Planning an Oracle installation; Understanding Oracle installation concepts; Acquiring the Oracle softwareReviewing the installation prerequisitesReviewing hardware prerequisites for an installation; Meeting the minimum hardware requirements for an installation; Reviewing software prerequisites for an installation; Using the Oracle Universal Installer; Understanding how OUI works; Completing final preparations to install the Oracle software; Creating Oracle user accounts and groups; Establishing Oracle directory structures; Understanding the Optimal Flexible Architecture; Using environment variables in Oracle; Installing the Oracle Database software; Running the Oracle Universal InstallerExamining the installationUnderstanding the de-installation process - advanced topic; Summary; Test your knowledge; Chapter 3: Creating the Oracle Database; Planning for a database creation; Understanding the memory requirements of a database; Understanding the disk requirements of a database; Running the Network Configuration Assistant; Creating an Oracle database using DBCA; Introducing the Database Configuration Assistant; Examining a manual database creation; Examining Windows Services in Oracle; Certification objectives covered; Summary; Test your knowledgeChapter 4: Examining the Oracle ArchitectureUnderstanding the Oracle RDBMS; Distinguishing between an instance and a database; Examining the Oracle instance; Recognizing the primary Oracle processes; PMON - the Process Monitor; SMON - the System Monitor; DBWn - the Database Writer process; CKPT - the Checkpoint process; LGWR - the Log Writer process; ARCn - the Archiver process; Recognizing the secondary Oracle processes; MMON - the Manageability Monitor; MMAN - Memory Manager; RECO - the Recoverer process; Recognizing other database processes; Identifying Oracle's memory cachesUnderstanding the SGADeveloped as a practical book, ""Oracle Database 11g Administration I Certification Guide"" will show you all you need to know to effectively excel at being an Oracle DBA, for both examinations and the real world. This book is for anyone who needs the essential skills to become an Oracle DBA, pass the Oracle Database Administration I exam, and use those skills in the real world to manage secure, high performance, and highly available Oracle databases.Electronic data processing personnel -- Certification -- Study guidesOracle (Computer file) -- Examinations -- Study guidesEngineering & Applied SciencesHILCCComputer ScienceHILCCElectronic data processing personnel -- Certification -- Study guides.Oracle (Computer file) -- Examinations -- Study guides.Engineering & Applied SciencesComputer Science005.7565005.7575Ries Steve1558995AU-PeELAU-PeELAU-PeELBOOK9910792068503321OCA Oracle Database 11g Database Administration I3823869UNINA