Database Administrator

Indirect interruption of ORA-12519 database connection Current number of connections Select count (*) from v $ process; Set the maximum number of connections (default value: 150) Select value from v $ parameter where name = 'processs '; Modify

ERROR 1129 is reported during MySQL connection. Problem description: ERROR 1129 is reported when the mysql command is used to connect to the mysql database; ERROR Description: ERROR 1129 (HY000): Host 'mysql02' is blocked because of unknown

The execution sequence of ROWNUM and order by in Oracle Database When SQL is used to query Oracle table data, the following two results may be required. Sorts the query result set and obtains the row number before sorting. After sorting the result

Common Methods for adding GoldenGate extraction processes The OGG configuration is very flexible. Each component has multiple configuration methods and can be prepared as needed. The following lists several common ways to add extraction processes.

How to install MariaDB10.0.X in the latest version in Linux 1. Linux installation environment CentOS7-64 bit, latest version: MariaDB10.0.14 2. Linux terminal command line Create a file: vim/etc/yum. repos. d/MariaDB. repo File Content: #

Validate command-RMAN for backup and recovery Verification As an Oracle backup and recovery tool, RMAN provides us with powerful functions, including physical and logical detection of data files and validity detection of backup files. First, let's

ORA-00600 event resolution When the Oracle database is started, close it directly to view the alarm log: Errors in file/opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_mmon_3749.trc (incident = 65276 ):ORA-00600: internal error code, arguments: [

Set the size of the Shared Pool in Oracle In Oracle 10g or 11G version, how to properly set the shared pool size has a great impact on the performance of Oracle databases. The size setting rules of the Shared Pool are as follows: 1. Check the

Shell extracts msyql and specifies the statement used to create a table in the database as a single file, dbcn="mysql -h172.16.1.194 -uroot -p123456";db=dsp_ad_center;ii=0;ct=`$dbcn -N -e " SELECT COUNT(1) FROM information_schema.TABLES AS t WHERE

Mysql auto-increment ID start value modification method, mysql modification methodMany friends in mysql think that the field AUTO_INCREMENT Type Auto-increment ID value cannot be modified. In fact, this is an incorrect understanding. The following

Mysql statement Summary Some time ago, my project was finally completed. The project mainly involves reports and a lot of SQL statements, so I would like to summarize it.I. Basics 1. Database-related commands A>. Create a database Create database

Mysql Access denied for user 'root' @ 'localhost' (using password: YES), deniedlocalhost [Symptom description] C/S program remote access is normal, local access reports the following exception MySql.Data.MySqlClient.MySqlException (0x80004005):

Drop dual, dropdualSome netizens have problems deleting dual tables: When the dual table is deleted, hang stays, and then shutdown abort directly. When you restart the database, you find that the database remains in the hang State during the open

Import and export without landing dataIn this case, the local disk space is insufficient, but some data needs to be migrated. We met such a situation yesterday: A friend needs to import a GB log table from 10 GB Data to 11 GB, but he wants to export

Database Row Operations (2), Database Row Operations Continued: You can arrange it FOR not only UPDATE, but also an UPDATE flag. For example: To update a TABLE, the field ID is the primary key. Then A performs the following operations: Select

SQLServer ----- use jTDS to connect to the SQLServer database, sqlserver ----- jtds 1. Introduction to jTDS JTDS is an open-source JDBC3.0 driver implemented in Java 100%. It is used to connect Microsoft SQL Server (6.5, 2012,) and Sybase (10, 11, 12

Oracle 11g new virtual column partition, oracle11g There is a need: a document table should be partitioned by month. If it is on Oracle 10 Gb, only one field can be added. It will be different after the Oracle 11g. You can use virtual column

SQLSever: how to generate different random numbers for each row in the select statement ?, Sqlseverselect The random function of the select statement is a bit false, maybe because it is based on time. In the same select statement, random numbers are

Mysql replication principle and Function Analysis (), mysql2014-11-11Replication Principle 1. The master writes data to the binlog. 2. slave enables two threads: I/O thread and SQL thread. 3. The slave I/O thread connects to the master and reads the

Mysql advanced triggers and mysql triggers A trigger is a special type of transaction that can monitor certain data operations (insert/update/delete) and trigger related operations (insert/update/delete ). Check the following events: Complete the