. Table Directory: if the data stored in the block is table data, the table directory stores information about the table.
3. Row directory
4. Free Space:
5. Row Space: the storage space used in the block. Table or index data is stored in the row space.
1.4 New Features of oracle 11g
1.4.1 Database Management
1. Plan Management
Allows you to fix the query plan of a specific statement. No statistical d
Oracle Exams IntroductionThe OCP (Oracle Certified Professional) is an authoritative and professional technical standard promulgated and implemented by Oracle, which is designed to certify those who are able to meet the service and support of Oracle core products, and has a skilled ability to operate with a wide range
)----Multiple instances to open a database• Stream----Multiple Oracle servers propagate transactions to one another• Data protection----The primary database to update the standby database Determine if it is a single instance Select parallel from V$instance; --NO Single InstanceSelect Protection_level from V$database; --Standby database protection, unprotected not protected SELECT * FROM dba_streams_administrator;--has not been configured and returns n
logfile;(Db1) SQL> select max (sequence #) from v $ archived_log;MAX (SEQUENCE #)--------------12(Db2) SQL> select max (sequence #) from v $ archived_log;MAX (SEQUENCE #)--------------12
It can be seen from the above that the log is successfully switched and the logging uard is running normally.
11. Master-slave switchover test:Db1 --- primary/db2 --- standby = db2 -- primary/db1 -- standby
[
QUESTION 2Identify the memory component from which memory is allocated for:session memory for the shared server, buffers for I/O Slaves Oracle Database Recovery Manager (RMAN) Backup and restore operationsA. Large PoolB. Redo Log BufferC. Database Buffer CacheD. Program Global Area (PGA)Correct answer:a
Explanation/reference:Large PoolThe large pool is a optional memory area intended for memory allocations, is larger than was appropriate
Fusion Technology (IV)
RAC special problems and combat experience (V)
ORACLE one-to-G Version 2 RAC ready for use with NFS on Linux (vi)
ORACLE ENTERPRISE LINUX 5.7 under Database 11G RAC cluster installation (vii)
ORACLE ENTERPRISE LINUX 5.7 Databases 11G R
Oracle 11g on July 11, 2007 11 O'Clock (Beijing time 11th 22 o'clock) officially released, 11g is Oracle 30 years to release the most important version of the database, according to the needs of users to achieve information lifecycle management (information Lifecycle Management) and many other innovations.
I. Outline
Stopping OracleWe should now is able to start Oracle database if you had choosed to create one during installation.If you had not yet created any Oracle instance and database use the $ORACLE _HOME/BIN/DBCA Assistant to do.Starting up the databaseOnce your server has been restarted, your database may not start. To solve this issue, first check in/etc/oratab that
Many DBAs are still at Oracle 9i or 10g, possibly because of the Oracle 11g price issue. This article will explain the installation of Oracle 11g under Windows 7, and I hope you can see some of the new features of 11g.
Recently un
following document :
Script. To Collect DB upgrade/migrate diagnostic Information (dbupgdiag.sql) [ID 556610.1]
Run this script:
CD
$ sqlplus/as SYSDBA
Sql> alter session set nls_language= ' American ';
sql> @dbupgdiag. sql
Sql> exit
If the script reports a invalid object, run the following command to recompile the i
file. When the master database becomes a slave database, you can receive logs from the slave database.Alter database add standby logfile group 4 ('/u01/app/oracle/oradata/orcl/redo_dg_021.log') size 50 M;Alter database add standby logfile group 5 ('/u01/app/oracle/oradata/orcl/redo_dg_022.log') size 50 M;Alter database add standby logfile group 6 ('/u01/app/oracle
Global Memory Management
Database files in a RAC
Consistency of read in RAC
Cluster readiness Service (CRS)
Global Resource Directory
Consistency managementData consistency and concurrency describe how Oracle maintains data consistency issues in a multiuser database environment. In a single-user database, users modify the data in the database without worrying about other users modifying the same data at the same time. However
Solution to Oracle 11g installation in Windows 7, oracle11g
Many DBAs are still in Oracle 9i or 10g, probably because of the price of Oracle 11g. This article will explain how to install Oracle
for executable: root@hardy:~# chmod a+x/u01/app/or Acle/product/11.1.0/db_1/bin/oracledb If you want to boot the Oracle 11g database automatically, do the following: root@hardy:~# ln-s/u01/app/oracle/ Product/11.1.0/db_1/bin/oracledb/etc/init.d/oracledb root@hardy:~# sudo sysv-rc-conf--level 2345 oracledb on If there is no sysv-rc-conf command, then apt-get one.
Database 11G RAC cluster installation (vii)
ORACLE ENTERPRISE LINUX 5.7 Databases 11G RAC database installation (eight)
Basic test and use of database 11G RAC under ORACLE ENTERPRISE LINUX 5.7 (ix)
Cache Fusion principleThe background process for RAC has been d
good news for enterprise users.
XML favourites
There is a high degree of flexibility in Oracle 11g to save XML information in both CLOB and binary ways. Oracle 11g also supports query mechanisms for XML, and there are a number of mechanisms to choose from, such as XQuery. XQuery is a set of specifications
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.