
Oracle DBA Pocket Guide
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Intro
- Contents
- Oracle DBA Pocket Guide
- Introduction
- Acknowledgments
- Conventions
- Oracle Architecture
- Database Versus Instance
- Background Processes
- System Global Area
- Database buffer cache
- Shared pool
- Redo log buffer
- Large pool
- Files
- Parameter files
- Control file
- Datafiles
- Redo log files
- Logical Database Structures
- Software Options
- Base Product
- Licensing
- Version Numbers
- Configuration Planning
- Availability
- Replication
- Hot standby database
- Real Application Clusters (RAC)
- Backup and Recovery
- Performance
- Memory
- Disk layout
- Installation
- Planning
- Installing the Oracle Software
- Creating a Database
- Using the DBCA
- Creating a database manually
- Initialization Parameters
- INIT.ORA: The Initialization File
- SPFILE: The Server Parameter File
- Dynamic and Static Parameters
- Backup and Recovery
- Export (EXP) and Import (IMP)
- EXP and IMP commands
- Common Export/Import parameters
- Export-only parameters
- Import-only parameters
- Data Pump Export and Import
- Data Pump features
- Data Pump privileges
- Data Pump Export and Import commands
- Export comparison
- Import comparison
- User-Managed Backup and Recovery
- Archivelog mode
- What files should be backed up?
- Backing up datafiles
- Backing up log files
- Backing up the control file
- Backing up miscellaneous files
- Restoring datafiles
- Restoring the control file
- Tablespace point-in-time recovery
- Backup and Recovery Commands
- ALTER DATABASE BACKUP CONTROLFILE
- ALTER DATABASE OPEN
- ALTER SYSTEM
- CREATE CONTROLFILE
- DBVERIFY
- OCOPY
- RECOVER
- STARTUP MOUNT
- Recovery Manager
- RMAN fundamentals
- Running RMAN
- Using RMAN scripts
- RMAN commands
- Security
- Authentication
- CREATE USER
- ALTER USER
- Profiles
- CREATE PROFILE
- ALTER PROFILE
- DROP PROFILE
- Privileges
- System privileges
- AUDIT
- CLUSTER
- CONTEXT
- DATABASE
- DATABASE LINKS
- DEBUG
- DIMENSION
- DIRECTORY
- INDEX
- INDEXTYPE
- LIBRARY
- MATERIALIZED VIEW
- OPERATOR
- OUTLINE
- PROCEDURE
- PROFILE
- RESOURCE COST
- ROLE
- ROLLBACK SEGMENT
- SEQUENCE
- SESSION
- SYNONYM
- SYSTEM
- TABLE
- TABLESPACES
- TRIGGER
- TYPES
- USER
- VIEW
- Miscellaneous privileges
- Special system privileges
- Schema object privileges
- Directories
- External tables
- Indextypes
- Libraries
- Materialized views
- Operators
- Procedures, functions, and packages
- Sequences
- Tables
- User-defined types
- Views
- Privilege commands
- GRANT
- REVOKE
- Roles
- CREATE ROLE
- ALTER ROLE
- DROP ROLE
- SET ROLE
- Auditing
- AUDIT
- NOAUDIT
- Other Security Features
- Views
- Stored procedures
- Fine-grained access control and security policy
- Virtual Private Database
- Label security and Policy Manager
- Application contexts
- Fine-grained auditing
- LogMiner
- Oracle Advanced Security
- Oracle Internet Directory
- Invoker rights
- The Data Dictionary
- Static Views
- Families of views
- Advisor views
- Change Data Capture views
- Constraint views
- Data dictionary views
- Index views
- Jobs and Advanced Queuing views
- Lock views
- Log group views
- Materialized view views
- Networking and distributed transaction views
- Objects Option views
- Partitioning views
- Programming and PL/SQL views
- Replication views
- Scheduler views
- Security and auditing views
- Server information views
- SQLJ views
- Storage views
- Streams views
- Table, column, and view views
- Dynamic Views
- Availability of dynamic views
- How dynamic views are built
- Global dynamic performance data dictionary views
- Index
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.