Database Administrator

Some performance Alarms can be found through the dba_outstanding_alerts table. If the locked table cannot be released for a long time, the sid and serial # Of the relevant session can be found here #. select * from dba_outstanding_alerts

MySQL, DBI, and DBD must be installed for MySQL database development using perl in Linux. Apart from the good DBI installation, MySQL and DBD installation are not so smooth. The following describes how to solve the installation error: I. MySQL

Oracle backup features include: Advanced Replication) Streaming Replication) Slave uard) One worker uard: Dataguard is generally the first choice for dba in terms of high availability and Disaster Tolerance. After all, dataguard has an overwhelming

I use binary for installation, file nameMysql-standard-5.0.18-linux-i686-glibc23.tar.gz[1] decompress the above file to a certain place and change the directory name of MySQL to mysql. The result should be as follows:/Home/jiang/mysql[2] INSTALL

First, create a user. Groupadd oinstall Groupadd dba Useradd-g oinstall-G dba-s/usr/bin/csh-d/export/home/Oracle-m oracle Second, create an access point Df-k Mkdir-p/opt/app/oracle/10.2.0 Mkdir-p/opt/app/oracle/doc Chown-R oracle:

In daily database maintenance and database programming, we often hesitate to perform DML operations on large data volumes, so that Oracle's undo tablespace can be extended to dozens of GB or dozens of GB. the physical space occupied by the disk will

After receiving the phone number from the O & M personnel, the number of connections to the mysql server is full. log on to the server and check that it is full. Well, first increase the number of connections to 2500 to provide external services

In actual application development, we have a lot of energy devoted to debugging programs and troubleshooting exceptions. The code developed using the design logic and scenario is often broken by the production data ". Quick locating of Error Data

What is the process of SQL statements in the database? What is the execution order? Before answering this question, let's review: in the Oracle database system architecture, SQL statements are generated by user processes and then transmitted to the

The tkprof program is further described as follows:After the tracking function is enabled, Oracle collects the performance status data of the SQL statements being executed in the tracking session to a trace file. This trace file provides many useful

MyBatis 3.2.6 there are two ways to obtain the auto-incrementing primary key when inserting Take MySQL5.5 as an example: Method 1: Insert into person (name, pswd) values (# {name}, # {pswd }) Method 2: Select LAST_INSERT_ID ()Insert into person

I plan to take a technical note on the Oracle index topic, because today I helped a friend in Shenzhen to perform the rman test and found a ORA-XXXXX error while restoring my raw data. The test results are as follows:Run {Allocate channel category

[Problem description] What do I do when a user prompts an error ORA-28002 that the password is about to expire? CIE68 :~ # Su-OracleOracle @ CIE68: ~> System/Atae1234 SQL * Plus: Release 11.1.0.6.0-Production on Tue Jan 19 15:15:50 2010 Copyright (c)

Implementation of almost hot standby MySQL based on LVM Almost Hot Standby: For mysql, if we want to create a snapshot using lvm, the innodb Transaction Log content may be written to the disk at the moment the snapshot is created, therefore, we must

Sometimes, as the business grows, you need to re-plan the redo log. For example, if there are three groups of existing logs, one member in each group, and each member is 50 MB in size, it is obviously unreasonable for the production database. We

1 SQL ordered by Elapsed TimeTop SQL statements that record the total execution Time (note that the total execution Time of the SQL statement within the monitoring range, rather than the execution Time of a single SQL statement Elapsed Time = CPU

Oracle SQL Developer displays the icon on Ubuntu and double-click it to run Terminal Access/usr/share/applications,Create the gedit SqlDeveloper. desktop file.Add the following content: [Desktop Entry]Name = SQLDeveloperComment = SQLDeveloperExec =

When we use catalog instead of controlfile as rman repository, the metadata information about the backup will also be stored in controlfil, so that when we use rman, you can use the information in controlfile even if the catalog is temporarily

After restarting the server, the user finds that a node in RAC cannot view the RAC status.An error occurred while checking the RAC status../Crs_stat-tCRS-0184: Cannot communicate with the CRS daemoBecause it cannot communicate with crs, check the

MySQL multi-row insert Because mysql autocommit is enabled by default, and many production environments are set to write disks when the transaction is committed, the io overhead produced by the commit is very large. In a busy oltp system, this may