Database Administrator

How to operate MySQL database instances using JSP I. Overview Before starting the introduction, let's talk about why we should write this article. I personally think that as an O & M engineer, we should be familiar with the knowledge network, not

 Summary of MySQL query table data size I. Data size of mysql tables   We know that mysql generally uses table space storage to store data files. When mysql uses the innodb Storage engine, Mysql uses table store data in two ways:

In general, DBA should focus on the SYSTEM, SYSAUX, UNDO, TEMP, and SYSTEM tablespaces in addition to the tablespace where business data is stored, the size of the UNDO and TEMP tablespaces is determined by the business conditions of the database.

1. Permission System introduction: The implementation of the MySQL permission system is relatively simple. The relevant permission information is mainly stored in mysql. User, mysql. db, mysql. Host, mysql_table_priv, and mysql. column_priv tables.

Recently, ORACLE databases in the unit are unstable. by querying the oracle alert Log, the following error message is displayed: Thread 1 cannot allocate new log, sequence 108922Checkpoint not completeCurrent log #1 seq #108921 mem #0: + DATADG/apts/

The method is as follows:1. first, make sure to back up the database to reduce or clear the database with log files) 2. right-click the database, select and open the "properties" window, find the "option" column, and change "complete" in the fault

Mapper. xml configuration Call pro_emp (# {emps, mode = OUT, jdbcType = CURSOR, javaType = java. SQL. ResultSet, resultMap = empMap})]> Stored Procedure: Create or replace procedure pro_emp (cur_sys out sys_refcursor) As Begin Open

Association between "beaten" and "Peking University"-one of the interesting data mining series (Tang changjie) (Note: This is the first article in the 12 interesting data mining series on the science blog. I discussed it with my friends. The blog

Recently, the company was using the postgresql database and developed many ddl/dml statements for us. So I spent two days completing this script to Create Table spaces and users, script for Automatic Data Import #!/bin/bash# 2013/07/26, DD.#

Today, we are doing experiments to help identify machines and use them at will.Hostname sourceCommand to change the linux host name and then start the database to report the following error:[Oracle @ source dbs] $ sqlplus/as sysdba SQL * Plus:

Q: SYBASEStored ProcedureWhy is this sentence not executed? Select @ nSerialNo = serialno from schedule where phonenum = @ strPhoneNum and type = @ nTypeIf @ rowcount = 0Begin...EndElseBegin...EndThe aboveSelectThe result is an empty record set.

Q: What is NULL? A: When we do not know the specific data, it is also unknown. We can use NULL. We call it NULL. in ORACLE, the column length containing NULL values is zero. ORACLE allows blank fields of any data type, except for the following two

This article uses examples to explain how to useLogMinerMethod to Analyze database logs. ◆ 1. Install LogMiner The following two scripts run as SYSDBA) @$ORACLE_HOME\rdbms\admin\dbmslm.sql;@

Multiple ORACLE databases physically stored in the network can be logically considered as a single large number.Database. Users can access data in remote databases through the network at the same time, whileCollaborative processing is completely

 We know that Oracle, as a large database, is widely used in financial, post and telecommunications, electric power, civil aviation, and other important sectors with huge data throughput and extensive computer networks. For system administrators, it

Oracle Advanced Replication, also known as symmetric replication. Unlike other Oracle functions, Oracle Advanced Replication is not plug-and-play. Users must have a deep understanding of how it works and the advantages and disadvantages of various

Oracle 8i Database Server is a highly optimizable software product. Regular adjustments can optimize system performance and prevent data bottlenecks. By adjusting the database system, we can achieve optimal performance to meet user needs. Below, I

Developers often use Access as the prototype or use Access to develop applications that are not critical. However, as the company's business grows, the problems to be solved will become more and more complex, and the Access environment may not meet

I. Multi-resident Multiple Residency) means to run Multiple OnLine instances on the same host. Each OnLine instance has and manages its own processes, shared memory, and disk space. Multi-resident does not mean to install OnLine software to multiple

######################################## The input amount of this function, returns the amount of uppercase Chinese characters ### Bellchiu AT NanJing CITIC: em13 :#########################################FUNCTION F_CONV_GB (pf_money)DEFINE pf_money