Database Administrator

There are several terms involved, which can be explained as follows:Policy: A security Policy. A security Policy is a set of level, compartment, group, and label.Level: Level. This is the most basic security control Level and must be set.Compartment:

After viewing the request and clicking Diagnostic, there is a View XML button, which is sometimes available and sometimes grayed out. Why? Two preparations are required to enable View XML: 1. Output must be XML: After the Output Format is

MySQL 5.6 is coming soon, and 5.6 has made many optimizations to the optimizer. This time I mainly explain MRR (MULTI-RANGE-READ ). I used stored procedures to explain the changes in this process. Let's take a look. For statements:

Create index idx_p_merchant_detail_id on D_ORDER_DETAIL (merchant_detail_id) Online; After the index is created for a long time, it is not reflected. Then, when the index is deleted, the following error is returned: Error: ORA-08104: this index

(1) Determine whether the Oracle connection is correct 1. Install a client on the local machine and use. net manager to configure the listener. 2. Use plsql to log in with the user name and password (use the normal user role to import and export

In mysql-cluster, if you want to upgrade an SQL node to a Web server, you need to install php and php extension modules for mysql on the node, but there will be conflicts. The command to install php is: # php53 will install the dependency package by

Environment: Oracle 11.2.0.1.0 RHEL5.3 64bit mysql Server version: 5.5.9 1: Download [ODBC Driver Manager] unionODBC2.2.14, decompress the package, and put it in the/u01/app/tools/unionodbc directory. [Oracle @ wonder tools] $

I learned about the Partition Table Technology in Oracle today. Now I want to save the statement for creating a partition table here! SQL> conn system/windows @ studyConnected. SQL> create tablespace test datafile 'd: \ oracle \ product \ 10.2.0 \

1. Place the check script on the monitored machine (Mysql Slave: /Usr/local/zabbix/bin/check_mysql_repl.py #! /Usr/bin/python # Coding: UTF-8 Import MySQLdb Import sys Class check_mysql_repl (): Def _ init _ (self ): Self. dbhost =

I would like to summarize several other experiments on high-availability clusters. Let's look back at the content summarized by others. It's very fine, and a lot of content has been extended. Sorry, I just skipped it, haha ~~~ Here we will summarize

1. What is Trial Recovery? Official explanation: A trial recovery applies redo in a way similar to normal media recovery, but it never writes its changes to disk and it always rolls back its changes. Trial recovery occurs only in memory. Trial

Temporary Tablespace Temporary Tablespace is used to store instantaneous data, which can be viewed only during session connection. Permanentobject cannot be created in temporarytablespace. Space utilization principle: It will not be monitored or

Mr. Huang took an SQL statement and asked me if I could optimize it. After reading it, the data volume is not large and the query is not complex. The record optimization process is as follows:DB: PostgreSQL 9.1OS: CentOS 6Count

This error occurs when you export or import tables in the 10.2.0.3 database using NETWORK_LINK in Oracle 11.2.0.2. The detailed error is as follows: [Oracle @ Oracle112 dmp] $ impdp system/password noLOGFILE = y tables = xyyzone. logs, xyyzone. logs,

Rename a data file If the primary database re-commands one or more data files, the modification will not be automatically transmitted to the standby database. If you want to make standby and data files consistent with primary, you can only manually

Experience summary: Online logs are classified into current online logs and non-current online logs. the corruption of Non-current online logs is relatively simple. Generally, you can solve the problem by using the clear command. Corrupt non-current

1. Generate a statistical report for the specified SQL statementTo compare databases with multiple instances, use the $ Oracle_HOME/rdbms/admin/awrddrpi. SQL script. The operation of this script is basically the same as that of a single instance. We

Fault description: The following error occurs when I establish a DBLINK verification connection to 11.2.0.3 in Oracle10.2.0.4: ORA-01017: invalid username/password; logon deniedORA-02063: preceding line fromAnalysis Error: According to the error

In some cases, you need to relocate multiple Oracle data files and log files or migrate them to new partitions or locations, such as insufficient disk space or special requirements. In this case, you can migrate multiple data files or log files in

There are many ways to perform backup, recovery, and data reorganization in the Oracle database. The simplest and quickest is the import and Export function. Oracle has two tools (Export Unility) and Import Unility. Export Unility can create a