Database Administrator

Currently, php_oci8.dll is generally used for PHP and Oracle connections. However, when I wrote the PHP code debugging, I encountered a strange problem, that is, only the data can be successfully obtained for the first time after each boot, but I

Oracle 10g installed on Red Hat AS4 has many related examples on the Internet. I will only make reference for this. 1> install AS4 Put the CD in and so on. Now we are talking about partitions, which are usually divided into two parts. I>/root

The system crontab is used to regularly execute Backup files and save the backup results by date to achieve the purpose of backup. 1. Create a path to save the backup file # Mkdir/opt/databack/mysql 2. Create a backup script file #

There are three types of connections between Oracle tables: 1. inner connection (natural connection) 2. External Connection(1) left Outer Join (the table on the left is not restricted)(2) Right Outer Join (the table on the right is not restricted)(3)

After Oracle 10201 rac is upgraded to 10204, the following error is reported during export. EXP-00056: ORACLE error 3212 encounteredThe ORA-03212: Temporary Segment cannot be created in locally-managed tablespaceEXP-00000: Export terminated

PL/SQL is a block structure language. The block consists of the definition part, execution part, and Exception Handling part. Syntax structure: Declare /* * Definition: used to define variables */ Variable name variable type V1 varchar2 (10 )

1> After the Oracle STARTUP script dbstart is installed by default, an error listener is reported, which is the same as the installation result in linux. The modification is as follows: Su-oracleVi 'which dbstart'Locate ORACLE_HOME_LISTNER and

I have been trying to install a testing environment for Oracle10g RAC. Today I have finally finished it. For more information, see: The specific steps are not listed. The above descriptions are very detailed. I just want to list some errors and

The set operator is used to merge the results of multiple select statements, including UNION, union all, INTERSECT, and MINUS. When using the set operator, make sure that the number of columns in Different queries matches the data type. The set

Pga_aggregate_target is usually abbreviated as P_A_T. This parameter also limits global pga allocation and private Workspace Memory allocation. In Oracle9i and 10gr1, the memory usage of a single SQL operation has the following restrictions: For

How to access the Oracle database using the ADO engine: Define the database header file as CDBOperation. h # Pragma once# Import "C: \ Program Files \ Common Files \ System \ ADO \ msado15.dll" no_namespace rename ("EOF", "adoEOF"), rename

When analyzing the performance of some statements, we will analyze some information. Such as tables, columns, indexes, and histograms. This article mainly describes the collection and analysis of statistical information of tables and columns.I.

How to Write high-quality SQL statements in Oracle databases and diagnose and adjust SQL statements with performance problems in Oracle databases is an inevitable challenge for DBAs in ORACLE Database practice. Next let's analyze how we can start

Recently, we helped HR capture the overtime records. HR wants to calculate the number of overtime hours by week. However, Oracle's date function compute week is the first day of Sunday and the last day of Sunday. The Chinese are used to counting the

It is easy to create a database manually in DB2. Create an example database:1. Generate database storage directories and archive DirectoriesMkdir-p/demo/sampleMkdir-p/demo/samplearc2. Generate a sample databaseDb2sampl-dbpath/demo/sample3. Specify

Oracle archive mode and non-archive mode switch 1. Check whether oracle is in archive Mode Arichive log list; Database Log mode non-archive ModeDisable automatic archivingArchiving end point USE_DB_RECOVERY_FILE_DESTThe earliest online log sequence 6

In Oracle, if a column type is varchar2, it cannot be directly converted to the clob type. It can be modified indirectly. The following is an experiment: SQL> create table test (id int, name varchar2 (10 )); Tablecreated SQL> insert into test values

I have been working with Oracle for the past two days, and various problems have been resolved... Mainly for various Oracle connection problems 1. PL/SQL connection to Oracle After Oracle11gR2 is installed, you do not need to install the Oracle

To build a Oracle10g-RAC cluster environment, we need to solve the problem of shared storage first; Here the FreeNAS-8.0.4-RELEASE-p1-x64.iso is used to configure ISCSI shared storage; Install the FreeNAS8 system, and the operating system disk can

/* Install CMake *//* Go To The CMake source code directory */Cd #/* Decompress the CMake source code */Tar zxf cmake-2.8.3.tar.gz /* Enter the CMake source code directory */Cd cmake-2.8.3/* Configure the installation parameters */./Configure --