Database Administrator

A. show tables or show tables from database_name; -- display the names of all tables in the current databaseB. show databases; -- display the names of all databases in mysqlC. show columns from table_name from database_name; or show columns from

Many of my friends often asked me how to learn Oracle. Here I will post my words in front of Oracle database performance optimization for your reference!Some may ask how to learn Oracle and how to quickly improve it? I have written some of my

Install mysql-4.0.26 notes under RedHat9: The original code package of mysql-4.0.26.tar.gz is obtained. Note that it is not binary. Use the following command to modify the actual path based on your own situation: --- Create a mysql installation

A few days ago, the MySQL site held a 12-day Scale-Out activity, listing many successful cases. The figure below each page is very noticeable: Note that HA between the master and slave servers is implemented through DRBD (Distributed Replicated

In Linux, MySQL (especially the MySQL client tool) is used for query. When there is a large amount of data, the page is quickly turned over and cannot be seen. In Linux, you can view the data on each page. You can use the -- pager parameter. For

Today, after repeated tests, the RAC was successfully configured. Now, the detailed operation steps are posted for your reference, we hope that we can avoid unnecessary detours when we are confused about RAC configurations. We also hope that our

The required information: Create a dblink from the MM Library to the GG Library The username and password of the MM library are mmn and mmk. The user name and password of the GG library are ggn and ggk. Prerequisites: The MM database has the

RMAN duplicate for standby failure Solution ProcessWhen using rman duplicate to standby to generate the standby database, it is always unsuccessful. The following error occurs when multiple attempts are made:RMAN> duplicate target database for

Redo content Oracle uses redo to implement the same fast commit. On the one hand, it is because redo log files can be written continuously and sequentially. On the other hand It is also related to the simplified content of the redo record.   To

To modify the Host Name of Oracle 10g RAC, refer: Related platforms:Aix 6106 + oracle 11203Modify host name:First node: change from dbrac1 to dbrac100Second node: change from dbrac2 to dbrac200 1. Uninstall CRS

Oracle 10g R2 rac crs cannot be started, CRS-1604: CSSD voting file offline [Root @ rac1 ~] # Cat/etc/RedHat-release Red Hat Enterprise Linux Server release 5.4 (Tikanga) [Root @ rac1 ~] # Uname- Linux rac1 2.6.18-164. el5 #1 SMP Tue Aug 18 15:5

Yesterday, colleagues export data, has been easy to use the file, has been reporting the error: ORA-12899: value too large for column, originally thought that the program changes caused by the length of the field changed, the structure of a table is

Purpose1. Table scanning before index creation1. Which data blocks are scanned?2. Relationship between data blocks3. Physical read4. Logical read5. Test the differences: full table scan and partial Table Record Scan6. Do I scan data blocks for

Block repair is the easiest way to restore a database. It is automatically performed by the system during normal operations of the database, and users can hardly feel it. Articles: Oracle recovery Internal principles http://www.bkjia.com/search.aspx?

1. installation environment: Oracle Linux 5.9 2. Download and install: For how to install the yum command in Linux, see: Check whether the yum source has mongodb: [Root @ bakdbserver ~] # Yum info mongo-10gen Loaded plugins: rhnplugin, security This

Oracle 11g has been installed in your Ubuntu environment. We hereby record the installation process and keep it as a memorandum. Prerequisites: 1. system update sudo Sudo apt-get updateSudo apt-get upgrade 2. packagesudo required for system

Compiler path configuration under Codeblocks: I feel that I can understand the compiler compilation and linking mechanism. I am not sure about it here. To put it simply, you need to add some options when compiling a program using the command line:

1. Functions of statistical information The CBO-based optimizer in Oracle relies heavily on statistics when generating execution plans. You can understand CBO as a complex mathematical model, statistics are the most important input, and execution

Pt-table-checksum installation: : Wget www.percona.com/downloads/percona-toolkit/2.2.2/percona-toolkit-2.2.2.tar.gz Tar xf percona-toolkit-{version}.tar.gz Cd percona-toolkit-{version} # enter the decompressed directory Vim README # view the

If undo damage is unfortunately encountered in Oracle running, the best way is to recover it completely. However, if there is no backup, you can use an unconventional method (using Oracle's hidden parameters ), if undo contains uncommitted