oracle 9i

optimization of the index. Oracle provides the ctx server for synchronization and optimization, or you can use the following job to complete. Sync Save the new term to the I table. createorreplaceproceduresyncis begin executeimmediate'alterindexdoc_indexrebuildonline'|| 'parameters(''sync'')'; executeimmediate'alterindexdoc_indexrebuildonline'|| 'parameters(''optimizefullmaxtimeunlimited'')'; endsync; Optimization Clear tab

that most people will consider these 4 parameters as controlling the time of the incremental checkpoint. In fact, this is wrong, and these 4 parameters are used to control the number of entries in the checkpoint queue, rather than controlling the occurrence of checkpoints.(1) Fast_start_io_targetThis parameter is used to indicate the total number of IO that needs to be generated when the database is instance recovery, which is estimated by V$filestat Avgiotim. For example, we have a database in

production environment, and make decisions based on the frequent user access. 　　 1) Main physical files can be divided into three types:I. Data Files: data files are used to store database data, such as tables and index data.Ii. Control File: the control file is a binary file that records the physical structure of the database.Iii. Online Log File: records all changes to the database for fault recovery.Note: if these files are lost, the database cannot continue to run and media recovery is requ

Oracle Pen questions Oracle DBA face questions and answers (foreign companies)Oracle Database Pen Test DBAOracle Interview Pen test for international large companiesOracle Database DBA Interview Questions1. How many memory layers are in the shared pool?2. How did you find the RMAN catalog if a particular archive log has been backed-up?3. How can I tell how much i

Tags: oralceOne, Oracle 9i Standard Edition, Enterprise Edition oracle 9i Standard Edition /td> oracle 9i Enterprise ? Jserver Enterprise Edition ? Intermedia ? Enterprise Manager ? Workflow

This article mainly introduces the differences between Oracle versions. From Oracle database-related products, from Oracle2.0 (no 1.0) to Oracle7.3.4, it is a relatively simple version of Oracle, starting with Oracle8, the identifier of a database product, such as Oracle8i and 9i, is displayed. Internet stands for "I",

This article mainly introduces the differences between Oracle versions. From Oracle database-related products, from oracle2.0 (no 1.0) to oracle7.3.4, it is a relatively simple version of Oracle, starting with oracle8, the identifier of a database product, such as Oracle8i and 9i, is displayed. Internet stands for "I",

prompts the user to specify the OCR location. And the user-specified location is recorded in/ETC/ORACLE/OCR. Loc (Linuxsystem) or/VAR/OPT/ORACLE/OCR. Loc (solarissystem) file. In the Oracle 9i RAC, the equivalent is the Srvconfig.loc file. Oracle Clusterware will read the O

OracleCopy a table from OracleOracle replication tablespaceOracle full table replicationCopy a table from OracleOracle Advanced ReplicationOracle Database ReplicationOracle replication userOracle Database DevelopmentOracle Development EngineerOracle EBS DevelopmentOracle form developmentSecondary Development of Oracle ERPSecondary Oracle DevelopmentOracle Application DevelopmentOracle ERP developmentOracle

As one of the mainstream databases in the current market, Oracle databases are developed on many applications. Due to the reasons for upgrading Oracle databases and different application providers, several Oracle versions may exist in an application unit, such as Oracle 7, Oracle