1. Process ArchitectureThe processes in the Oracle DB system are divided into two main groups:? Running the application or Oracle tool codeUser Process? Running the Oracle DB server codeOracle DB Process(includingserver processes and background
After studying Oracle for a long time, I would like to share with you that you will certainly have a lot of gains after reading this article. I hope this article will teach you more things. After the compiled code is generated, the next step is to
Database Storage Architecture
The files that make up Oracle DB can be categorized into the following categories:?Control Files:Contains data related to the database itself, which is the physical database structure information. These files are
Compiling bbed and 11.2.0.4bbed in Oracle db 11.2.0.4 in linux 6.3
From: http://blog.csdn.net/inthirties/article/details/5558030
Environment:
Oracle db 11.2.0.4, rhel 6.3 x86-64bit
The following files required for compiling bbed in 11.2.0.4
? Describe the storage of table row data in a block? Create and manage table spaces? Get tablespace information
How table data is stored
When you create a table, you also create one that holds its data.segment。 A table space contains a
Oracle NUMA support is enabled on Oracle DB 11GR2 version numberReference Original:Enable Oracle NUMA Support with Oracle Server Version 11gR2 (file ID 864633.1)Application:Oracle database-enterprise edition-version 11.2.0.1 and laterOracle Database-
Enabling Oracle NUMA support in the Oracle DB 11GR2 releaseReference text:Enable Oracle NUMA Support with Oracle Server Version 11gR2 (document ID 864633.1)Suitable for:Oracle database-enterprise edition-version 11.2.0.1 and laterOracle
? Describe the DBA's responsibility for security and audit work? Enable standard database auditing? Specify audit options? Review audit information? Maintain audit trail
Segregation of duties
? A user with DBA authority must be
? Determine what types of failures can occur in Oracle DB? Describe how to optimize instance recovery? Explain the importance of checkpoints, redo log files, and archived log files? Configure the quick recovery area? Configuring Archivelog Mode
For non-Oracle DB, SQL Server is a sample description:My train of thoughtA:oracle DB production B:oracle DB Intermediate machine C:sqlserver db destinationa-> b->c Note: B on both the rep process also has the EXT process, at this time. There is also
Non-Oracle DB is illustrated with SQL Server as an example:My train of thoughtA:oracle DB production B:oracle DB Intermediate machine C:sqlserver db destinationa-> b->c Note: B on both the rep process and ext process, at this time, C also need to
? Configure backup settings with Oracle Enterprise Manager? Enable automatic backup of control files? Configure the backup destination? Assign a channel to a tape target? Configure Backup Optimizations? Create a compressed backup? Create an
? Create and manage database user accounts: – Authenticate users – Assign default storage (tablespace)1. Database user accountTo access the database, the user must specify a valid database user account and also successfully authenticate against the
RHEL 7 was opened for download in 2014 and can be found in the "Certifications" section of MOS:12.1.0.2 passed the certification on the RHEL7.12.1.0.1 failed to pass the certification on RHEL7.11.2.0.4 passed the certification on the RHEL7.11.2.0.3
Database Control is backed up after Oracle DB 11.2 releaseReference from:Database Control to being desupported in DB releases after 11.2 (Doc ID 1484775.1)Suitable for:Oracle server-enterprise EditionInformation in this document applies to any
? Configure the Flashback database? Perform a flashback database operation? Monitoring the Flash back database
Flash back to the database
Flash back database operation:? Functions like a rewind button for a database? You can use the
Interacting with Oracle DBThe following demo sample describes Oracle DB operations from the most significant level. This demo sample illustrates an Oracle DB configuration in which the user and the associated server processes are performed on
Interacting with Oracle DBThe following example describes the Oracle DB operation from the most basic level. This example illustrates an Oracle DB configuration in which the user and the associated server processes run on different computers that
? Describes locking mechanisms and how Oracle manages data concurrency processing? Using SQL to manage Data? identify and manage PL/SQL Objects? Describe triggers and trigger events? Monitoring and resolving locking conflicts
Working with
The "Check operating system version: must be 5.1 or 5.2" encountered when installing Oracle DB 10.2.0.4 under Widows x64bit R2. The actual 6.1 failed "Special Note: Widows X64bit R2 The installation of Oracle DB 10.2.0.4 is only the first step, then
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.