Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


41: Oracle data dictionary frequently used
The following table of the Oracle data dictionary to collect almost all of the view or an alias for each field of view or an alias, please use the 'Describe' statement to query. Note name: Oracle data dictionary, the object name of the major...

42: Steps: Oracle 10g ASM On SLES9
1, the upgrade SLES9 kernel, asm-related packages installed, pay attention to the version to be consistent. 2, / etc / init.d / oracleasm configure user asm driver configuration for the oracle dba group, and starts automatically. 3, ready to bare ...

43: Oracle explain the use of null
Q: What is NULL? A: We do not know what specific data when that is unknown, can be NULL, we call it empty, ORACLE, the table contains a null value of zero length. ORACLE allow any type of a data field is empty, except for the following two situation...

44: 20 best Oracle 10g New Features
The answer according to DBA work experience vary. Most senior managers prefer a simple command-line SQL * Plus (my personal preference), while the rest of the people prefer to use some third-party products. However, a problem with the DBA in the ent...

45: 20 best Oracle 10g New Features
The answer according to DBA work experience vary. Most senior managers prefer a simple command-line SQL * Plus (my personal preference), while the rest of the people prefer to use some third-party products. However, a problem with the DBA in the ent...

46: 20 best Oracle 10g New Features
The answer according to DBA work experience vary. Most senior managers prefer a simple command-line SQL * Plus (my personal preference), while the rest of the people prefer to use some third-party products. However, a problem with the DBA in the ent...

47: Oracle9i introduced the Enterprise Manager
Oracle Enterprise Manager is a management framework, using it can be achieved: the management of the complete Oracle environment, including databases, iAS servers, applications and services. Diagnosis, modification and optimization of multiple data...

48: The use of scripts and queries to take the initiative to monitor the performance of Oracle 9i
More than 250 configuration parameters, thousands of measurements to monitor, which allows Oracle administrators to monitor the overall health of their Oracle database work is not a easy task. Oracle offers a variety of tools to monitor performance,...

49: Oracle performance tuning principle
ORACLE performance impact of the source of many, including the following aspects: Database hardware configuration: CPU, memory, network conditions 1. CPU: any machine in the data processing capacity of CPU is a measure of computer performance is o...

50: Oracle performance tuning principle
ORACLE performance impact of the source of many, including the following aspects: Database hardware configuration: CPU, memory, network conditions 1. CPU: any machine in the data processing capacity of CPU is a measure of computer performance is o...

51: Oracle data method to remove large quantities
Massive quantities of data is usually deleted very complex and slow, a lot of ways, but generally the concept is: deleted batches, successive submitted. The following is a removal process, the data table the primary key can be deleted, Delete and t...

52: Oracle database to maintain the excellent performance
Oracle database for its high reliability, security, compatibility, has been an increasing number of enterprises of all ages. How to make the Oracle database to maintain a good performance, this is a database administrator a number of issues of conce...

53: Analysis of Oracle and SqlServer stored procedure debugging, error handling
In large databases, because the needs of development, often need to call the Procedure, the development of Procedure in Oracle and Sqlserver because of different syntax, and different, but in debugging, is not easy to compare, especially in some err...

54: Oracle database backup and recovery
There are three standard Oracle database backup methods, which are the Export / Import (EXP / IMP), hot and cold backup. Export of spare parts is a logical backup, cold backup and hot backup is a physical backup. A, Export / Import (Export / Import...

55: Oracle automatic backup of data in different places
In large commercial applications, data back up the importance of Disaster Recovery, is also essential. The author according to their own practical experience, has designed a simple way to achieve automatic remote data backup method for database mana...

56: Oracle automatic backup data
The author combines practical experience, to talk about the UNIX environment to automatically back up Oracle databases. We plan to allow the database 23 o'clock at night to do export export backup, 2 in the morning the backup file will be copied...

57: Oralce database disaster recovery
Database administrator should focus on specific operational requirements of the development of a detailed database backup and disaster recovery strategy, and for each fault by simulating the situation likely to rigorous testing, the only way to ensu...

58: Oracle Recovery Manager (RMAN) function
Oracle Recovery Manager (RMAN) can be used to help a lot of backup and recovery process of the function, the tool has a command line and GUI versions. Usually, RMAN implementation and standardization of the process of backup and recovery, and throug...

59: ORACLE tablespace recovery program
A user table space Error: when you start the database ORA-01157, ORA-01110 or the operating system level error such as ORA-07360, In the closure of the database (using shutdown normal or shutdown immediate) will lead to error ORA -01116, ORA-01110...

60: ORACLE tablespace recovery program
A user table space Error: when you start the database ORA-01157, ORA-01110 or the operating system level error such as ORA-07360, In the closure of the database (using shutdown normal or shutdown immediate) will lead to error ORA -01116, ORA-01110...


Page 3 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]