Database Administrator

During Oracle database management, tables are often locked due to unreasonable operations on data tables. The following describes how to find which tables are locked by which users, and how to unlock: 1. Find the locked table: Select object_name,

Environment: NavicatforMysql8.2 + MySQL Sever 5.1 Problem: Garbled characters occur when exporting SQL statements from the MySQL database. Solution: Method 1: Change the database encoding to a UTF-8. Database --------> right-click -------->

I. Physical backup and restoration of LVM-based mysql databases: In this case, our msyql database must be installed on a logical volume. The following method can achieve almost hot backup (the reason is that when we create a snapshot, we cannot

The ultimate goal of backup is to better recover data and restore data. We have finished focusing on the previous chapter.RMANIn fact, we also talked about complex and complete recovery. Of course, in this section, we will discuss in detail the

Syntax: TRANSLATE (char, from,) Usage: replace each character in The from statement with the corresponding character in the to statement. If the from statement is longer than the to statement, the strings in the from statement are deleted. One of

1 MySQL Cluster MySQL Cluster is a highly practical and redundant MySQL version suitable for distributed computing environments. It uses the NDB Cluster Storage engine and allows multiple MySQL servers to run in one Cluster. This storage engine is

First you need to download HBase latest and stable version: http://www.apache.org/dyn/closer.cgi/hadoop/hbase Decompress the package and move the extracted file to a directory such as/home/user/hbase. $ Cd/home/user/hbaseEnter this directory $ Vi

1. Define BOM BOM is the basis of WIP. BOM defines the structure of a product and the parts and quantity required to produce specific materials. Each part may also have its BOM structure, resulting in a multi-layer product structure tree. For

The following statement can be used to obtain the statements for deleting all tables, indexes, and sequences of Oracle... Select 'drop table' | table_name | ';' | chr (13) | chr (10) from user_tables; -- delete tablesSelect 'drop view' | view_name |

Sometimes a lot of SQL statement data needs to be inserted. However, PL/SQL tools are often used for a long period of time. Recently, PL/SQL tools are used frequently and are sorted out to facilitate future reference. The code is simple: Batch

We know that scott must be unlocked before conn to scott/tiger for the first time. The steps for unlocking are as follows: 1: Start the database and run @ $ Oracle_HOME/db_1/rdbms/admin/utlsampl. SQL. 2: access the database through sqlplus again 3

A set of Oracle RAC 10 Gb database, check that the undotbs tablespace is in the recover status, the remote processing process is as follows: 1. Check the database status: Select file #, status from v $ datafile where status = 'recover '; FILE #

When ASMM is used, there are few 04031 problems, but some applications may also exhaust the memory.1. No bound variable is used, resulting in too much resource occupation for parsing.2. Open too many cursor and do not release3. bug First.Bind

First download the MySQL installation package, and then install it step by default. In the last step, check the instance Configuration box. Remember to select it. After the installation is complete, the instance Configuration Wizard will pop up

Share a small case: Today, a cache buffers chain appears in a database, and the application has not changed recently. How can this happen suddenly? Of course, latch: the function of the cache buffers chain is to Find data in the database cache.

1. Use the mysql built-in command mysqldump Usage:Mysqldump [OPTIONS] database [tables]Mysqldump [OPTIONS] -- databases [OPTIONS] DB1 [DB2 DB3. ..]Mysqldump [OPTIONS] -- all-databases [OPTIONS] You can see that you can back up all the databases, the

Master server: 172.16.15.20Slave server: 172.16.15.30 1. Install mysql # pvcreate /dev/sda5    # vgcreate myvg /dev/sda5   # lvcreate -L 10G -n mydata myvg   # mkdir -p /data/mydata   # mke2fs -j /dev/myvg/mydata   

Environment Description: LINUX Virtual Machine RedHat5.5 + Oracle10.2.0.1 Single Instance Library Fault description: When startup starts the database, a ORA-00600 error is reported as follows, and cannot start ORA-00600: internal error code,

Log on to PL as SYSDBA; 2. Right-click "User"-> "New" to create a User; 3. The new user window is displayed. On the general tab, enter: Name: user name; Password: password; 4. Switch to the "Role Privileges" tab: Select connect for Role and

Database Management Tool SQL * PlusStart SQL * PLUS   Cmd-> sqlplus/nolog Conn system/manager   View table structure by Desc table name Column name for 9999 format Column Column name for a99 format   List to view the instructions in the cache; Del