oracle 12c complete reference

Label:Environmental Status:Two virtual hosts A and b:1. A machine has installed ASM storage for Oracle 11g instance reference: Http://www.cnblogs.com/jyzhao/p/4332410.html 2. b machine installed system, configuration and directory structure are consistent with a machine/U01 + 3 ASM DiskDG Deployment Planning: Primary Standby Host Jy-db Jy-dbs

During the Oracle database operation, the DBA should monitor the database's running log and table space usage, and discover the problems in the database as early as possible. Oracle Warning log file monitoring Oracle will log some of the database operations in the warning log file (alert_sid.log) during the run: The database is started, shut down, not default

Source: Network/Editor: getting started with programming Author: E Jian The goal of this article is to execute a shell script to complete the entire process of automatic Oracle database backup, and to generate compressed files in the current directory. The specific implementation steps are as follows: 1. log on to Linux as an oracle user. 2. Creat

packageFirst Linux.x64_11gR2_database_1of2.zip, linux.x64_11gR2_database_2of2.zip upload to Oracle home directory/opt/oracle(2) Log in and unzip the installation package with an Oracle userUse the Oracle User login GUI to extract files and perform the installation (some exceptions may occur if you are not logged on wi

, from the library to take over the main library, complete identity changes. Can be a master library, up to 9 from the library. It is also divided into logical standby and physical standby here we are talking about physical standby.Once created and configured as standby, DG is responsible for transmitting the primary database redo data to the standby database, and standby the database to keep the redo database transactions consistent with the primary

--oracle exception return complete information, see finally attached--Of course, it's best to select the returned information, along with other relevant information about the code--such as the occurrence of object name, time, etc. insert pre-built reference error table--11:08 2007-11-26 edit by Inreyou DeclareStrName Varchar2 (20);BeginStrName: = ' datanotfound '

Complete optimization of Oracle Database in UNIX environment2007-04-19 12:54:02 Author: changelive Browse Number: 14 Text size: " large "" in the "" Small "into the forumToday's optimization has been transformed to the optimization Wait (waits), in fact, the most fundamental point of performance optimization is also focused on Io, which is the most important aspect of performance, it is a good idea to wait

for the size of N;Iv. degree: concurrency, can be nice value, 8/16/24/32 ...*/ --Frees data space after data is deletedALTER TABLE my_table enable row movement;ALTER TABLE my_table shrink space cascade;ALTER TABLE my_table disable row movement; OrALTER TABLE table_name move; --After performing this operation, you need to rebuild the index Select T.num_rows, T.temporary, t.last_analyzed, t.* from User_tables twhere t.table_name = Upper (' gspauresult_tkk0107 '); Select T.num_rows, T.distinct_key