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

A few days ago, when operating the database, you needed to execute SQL statements that took a long time. However, at that time, the LAN network was not good and frequent disconnection occurred. In this case, you need to add the statement to the

Oracle query lock: Select a. OWNER solution name,A. OBJECT_NAME table name,B. XIDUSN rollback segment number,B. XIDSLOT slot number,B. XIDSQN serial number,B. SESSION_ID lock table SESSION_ID,B. username of the ORACLE_USERNAME lock table,Decode (D.

Keywords: Hongqi Asianux3 + Oracle 10g R2 for Linux x86-64 1. Receive a consulting phone number in the morning: Oracle cannot be started in Linux. We will try to solve the problem at the site in the afternoon. 2. After arriving at the site, learn

Installing Oracle on the Linux platform requires a lot of preparation. For example, create a user, modify the environment variables, and set oracle parameters. Now it is compiled into a shell script to facilitate installation.1. Create an

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 #

1. What is an elastic domain? FlexValue is a field composed of child fields or segments. It is displayed as a pop-up window containing prompts of each segment on the form. Each segment has a name and a valid value set. For example, Guangdong mobile

1. view the table space name and size. Select t. tablespace_name, round (sum (bytes/(1024*1024), 0) ts_size From dba_tablespaces t, dba_data_files d Where t. tablespace_name = d. tablespace_name Group by t. tablespace_name;　　 2. view the name and

Oracle dump may have Character Differences in different oracle databases. Today, I am going to get a new method from my friends, as shown below. 1. Common method-find a machine with the same Registry language and oracle language characters and

First, declare that, in general, you need to have the root permission in MySQL to modify the mysql password and grant permissions.User: bkjia user database: bkjia.com 1. Create a user.// Log on to MYSQL@> Mysql-u root-p@> Password// Create a

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

The process of cross-compiling the SQLite-3.3.8 (or SQLite3.3.12) and porting to ARMS3C2410: To port SQLite3.3.8 (or SQLite-3.3.12) to the ARM2410 Development Board, in addition to the support of the underlying operating system, you must also have

The remote_listener cannot be enabled due to a problem in the settings. The alert Log is as follows: Starting up:Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data

Value Type MySQL includes strict data types (INTEGER, SAMLLINT, DECIMAL, NUMERIC), and approximate data types (FLOAT, REAL, DOUBLE). After extension, TINYINT is added, MEDIUMINT and BIGINT types have different lengths, and BIT types are added to

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

The Oracle Database modifies the corresponding values for the same field based on different conditions: For example, adjust the employee's salary based on the position. If the employee's position is "SALESMAN" or "ANALYST", the employee's salary is

When using Oracle SQL * PLUS, SPOOL is really easy to use. How can we implement it in MySQL? The following is an experiment description. In MySQL, the tee parameter can be used in three methods: First, add the tee parameter to the my. cnf parameter

This is a relatively biased knowledge, but it has a lot of practical significance and can help DBAs complete some daily management work, for example, you can disable some user functions (prohibit users from modifying or deleting a table, and

I. Environment Description 1. Working logic diagram 2. Advantages and Disadvantages of MySQL-MMM Advantages: high availability, good scalability, automatic failover in case of faults. For master-master synchronization, only one database write

Indexing null values Install relational database theory. null indicates unknown. Oracle B-tree index does not contain null. Consider the following table: Create table tt (t_id number, t_name varchar2 (10 ));Create index tt_idx on tt (t_name