Database Administrator

Configure Cacti to monitor MySQL database status MySQL itself is not powerful in performance monitoring, which makes many MySQL DBAs sleep at night. Fortunately, the MySQL database status is monitored through Cacti (monitoring rather than monitoring.

Use mysqlbinlog to restore data based on location or time point MySQL backup generally uses full backup and log backup. For example, a full backup is performed every day and a binary log backup is performed every hour. In this way, you can use full

Query the size of a table with a lob field in the Oracle database Note: Because the lob field has an independent lob segment for storage, for a table with a lob field, you cannot only query dba_segments. The following scripts are from: How to

Redhat 6 Oracle 11g RAC Installation notes I recently installed 11g RAC on RedHat 6. I have encountered several precautions to share with you: Install Oracle 11gR2 (x64) in CentOS 6.4) Steps for installing Oracle 11gR2 in vmwarevm Install Oracle 11g

Oracle Study Notes: Use of the graphic management tool EM Use of common Oracle learning notes tools-EM Graphics Management Tool em Server 1 Ensure Listening Starts -----> grid Lsnrctl status Or Netstat-tunlp | grep 1521 If not Lsnrctl start 2.

Summary of Oracle SQL Execution Plan and Analysis Oracle has multiple ways to obtain a query plan for an SQL statement, such as using the explain plan command and pressing the F5 shortcut in PLSQL Developer. However, it is easier to use it for SQL

Analysis of database downtime caused by ORA-04031 Background On February 5, the user's database went down unexpectedly. After restarting the server, the Oracle database went back to normal. The user hoped to troubleshoot the problem and avoid

Oracle Upgrade ORA-04063 DBMS_REGISTRY has error When upgrading the Oracle database from 11.2.0.1.0 to 11.2.0.2.8, the software upgrade is normal, the instance upgrade is normal, and the psu is upgraded.Run @? /Rdbms/admin/catbundle psu when

[Translated from mos] oracle NUMA support and 11gr2numa support are enabled in Oracle db 11gR2.Enable oracle NUMA support in Oracle db 11gR2Reference Original:Enable Oracle NUMA support with Oracle Server Version 11gR2 (Document ID

How to optimize QuerySet query by the select_related and prefetch_related functions of Django (1), djangoqueryset When the database has a foreign key, the use of select_related () and prefetch_related () can greatly reduce the number of database

[Translated from mos] What is the maximum value of Db_recovery_file_dest_size? dbrecoveryfiledestWhat is the maximum value of Db_recovery_file_dest_size?Reference Original:What Is Maximum Size For Db_recovery_file_dest_size In Oracle 10.2, 11.1, 11.2

Mysql Stored Procedure example DELIMITER $Create procedure generate_Equipment (district INT, warehouseNO VARCHAR (10 ))BEGINDECLARE l_no VARCHAR (50 );DECLARE l_address VARCHAR (20 );DECLARE l_name VARCHAR (20 );DECLARE l_city VARCHAR (20) DEFAULT

Grant authorization for Oracle cainiao and oraclegrant 1. Authorize the database user (the object is the user table) GRANT privilege [,...] ON object [,...] TO {PUBLIC | GROUP group | username} privilege: select: Query insert: insert update: update

Oracle Database 11g Release 2 Standard Edition and Enterprise Edition Software Downloads, oracle11g Download Oracle Database 11g 2nd Standard Edition and Enterprise Edition Software Microsoft Windows (32-bit) disc 1, disc 2 (2 GB) 1Microsoft Windows

Implement a micro-database and a micro-Database Write a simple database by yourself,PrincipleThere are the following points: 1. Data is saved as text Write the data to be saved to a text file, which is a database. For easy reading, data must be

[Translated from mos] relationship between oracle linux and external storage systems, mosoracle Relationship between oracle linux and External Storage Systems Reference Original:Oracle Linux and External Storage Systems (Doc ID

Abmr: test the automatic block Recovery feature and abmr test feature Abmr: test the automatic block Recovery feature Reference Original:ABMR: How to test Automatic Block Recover Feature (Doc ID 1266059.1) Applicable:Oracle Server-Enterprise Edition-

[Translated from mos] Main Note, mos mainnote Main Note-Supplemental Logging and TRANDATA of ogg Original article:Main Note-Supplemental Logging and TRANDATA for OGG (Doc ID 1537838.1) ApplicableOracle GoldenGate-Version 9.5 _ EA and

Oracle TIMESTAMP processing, oracletimestampPublic class Test {Private static final SimpleDateFormat FORMAT = new SimpleDateFormat ("yyyy-MM-dd HH: mm: dd ");Public static void main (String [] args) throws SQLException {Oracle. SQL. TIMESTAMP temp =

Java connects to the Oracle database, javaoracle Generally, an error is reported after the import oracle. jdbc. driver. *; statement is written. In this case, you need: 1. Add the JDBC driver to classpath Two methods. 1. graphical,