Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


61: Logical Oracle database backup
ORACLE database there are two types of backup methods. The first category is physical backup, the method to restore the integrity of the database, but the database must be running to the block mode in the (business database in the non-return block m...

62: Achieved in the Oracle database replication
To operate the database in the Internet often have such a demand: the cities all over the country similar to the unified database application, a data node to change not only in Hong Kong, is also reflected to the remote. Replication technology to pr...

63: Import and Export using Oracle tools Oracle database migration
Oracle database as the database is currently one of the mainstream market, a number of applications carried out in their development, due to the reasons for upgrading Oracle database and application providers, may result in the application of a unit...

64: Import and Export using Oracle tools Oracle database migration
Oracle database as the database is currently one of the mainstream market, a number of applications carried out in their development, due to the reasons for upgrading Oracle database and application providers, may result in the application of a unit...

65: Oracle database security policy
Oracle is a relational database management system, which features powerful, high performance in today's large-scale database management systems play an important role. In our development of a MIS system, the selected database Oracle7.3. Under no...

66: MIS system, Oracle database instances Security Policy
Oracle database backup as a result there are three ways, each with different ways of recovery characteristics, and should therefore be integrated database and file system backup, integrated logical backup and physical backup. A backup strategy 1. ...

67: After RESETLOGS backup in case of no data recovery
The restoration of sub-media are not fully recovered and fully restored. Can not be fully restored back to the designated time or system change number, but not fully restored after the remainder of the log file is not available, we must reset the lo...

68: Oracle automatically with the completion of the physical Linux backup
In this paper, Oracle Database automatically Physics in Linux backup (offline backup) as an example of the realization of the physical description of the steps to back up, hoping to help Oracle database administrators more aware of the physical back...

69: Oracle logical backup file of SH
Full backup of the SH file: exp_comp.sh rq = `date +"% m% d "` su - oracle-c "exp system / manager full = y inctype = complete file = / oracle / export / db_comp $ rq.dmp" SH cumulative backup file: exp_cumu.sh rq = `date +&q...

70: Oracle database replication to achieve
We often want to post all over the unified data storage applications. Replication technology can be used now to solve the problem. However, database replication is to have a number of conditions. First of all, the database should have advanced copy...

71: How to set up Advanced Replication environment for Oracle 8
Oracle Advanced Replication, also known as asymmetric replication. Other features of Oracle and different, Oracle's Advanced Replication is not a plug-and-play, users must be a deep understanding of how they work, as well as the advantages and d...

72: How to set up Advanced Replication environment for Oracle 8
Oracle Advanced Replication, also known as asymmetric replication. Other features of Oracle and different, Oracle's Advanced Replication is not a plug-and-play, users must be a deep understanding of how they work, as well as the advantages and d...

73: Oracle's Optimizer (Optimizer)
Oracle in the implementation of a SQL, first we analyze the implementation plan statements, and then to implement the Plan of Implementation. Analysis of the implementation plan statement is handled by the optimizer (Optimizer) to complete. Differen...

74: Summary of Oracle tuning
Preface In the past decade, Oracle has become the world's one of the most professional of the database. For IT specialists is to ensure that the use of Oracle's powerful features to improve the productivity of their companies. One of the mo...

75: Some of the optimization problem CBO
How to use the optimizer to optimize queries CostBased operation? Oracle provides a cost-based (CostBased) and rule-based (RuleBased) two optimizer, referred to as the CBO and RBO, query operation is used to determine the implementation plan. CostB...

76: Some of the optimization problem CBO
How to use the optimizer to optimize queries CostBased operation? Oracle provides a cost-based (CostBased) and rule-based (RuleBased) two optimizer, referred to as the CBO and RBO, query operation is used to determine the implementation plan. CostB...

77: Some of the optimization problem CBO
How to use the optimizer to optimize queries CostBased operation? Oracle provides a cost-based (CostBased) and rule-based (RuleBased) two optimizer, referred to as the CBO and RBO, query operation is used to determine the implementation plan. CostB...

78: Some of the optimization problem CBO
How to use the optimizer to optimize queries CostBased operation? Oracle provides a cost-based (CostBased) and rule-based (RuleBased) two optimizer, referred to as the CBO and RBO, query operation is used to determine the implementation plan. CostB...

79: Some of the optimization problem CBO
How to use the optimizer to optimize queries CostBased operation? Oracle provides a cost-based (CostBased) and rule-based (RuleBased) two optimizer, referred to as the CBO and RBO, query operation is used to determine the implementation plan. CostB...

80: Some of the optimization problem CBO
How to use the optimizer to optimize queries CostBased operation? Oracle provides a cost-based (CostBased) and rule-based (RuleBased) two optimizer, referred to as the CBO and RBO, query operation is used to determine the implementation plan. CostB...


Page 4 of 37
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]