Database Administrator

An example of ORA-07445 troubleshooting The tester reported an error when running SQL statements on a test database (the specific SQL statement is not mentioned here. In short, it is a complicated SQL statement with more than rows .), The error

Oracle stored procedure description for determining whether a point falls on the surface 1. Background In the leting project, our engineering colleagues proposed that they should be able to determine whether the point is located in the leting

RMAN backup Error 1.1.1RMAN backup Error1.1.1.1 problems and phenomenaChannelORA_DISK_1: starting piece 1 at 05-MAY-15 RMAN-00571: ========================================================== ============================== RMAN-00569: =================

Mysql innodb engine's shared and independent tablespaces, mysqlinnodb For innodb data storage files, we must first solve two conceptual problems: Shared tablespace and exclusive tablespace. (The innodb engine and MYISAM engine are very different. In

OGG rep process startup encounters sys. dbms_streams_adm_utl_invok.SET_FOO_TRIGGER_SESSION_CONTXT (fire => TRUE);, excelcontxt GGSCI (jjtest) 2> view report repzp***********************************************************************

Obtain different scn information from control file and datafile header, datafilescn Database checkpoint scn -- The following dump from control file: Database checkpoint: Thread=1 scn: 0x0000.0006b6fe Datafile checkpoint scn -- The following is the

Oracle Exadata All-in-One and cloud computing applications (2), oracleexadata3. Main Exadata Technologies 3.1 unit shunting In the database cloud server, storage is not just a dumping storage. Storage units are smart enough to handle certain

[Mybatis] one-to-one and one-to-many implementations of Mybatis association query. mybatis one-to-one Original works of Lin bingwen Evankaka. Reprinted please indicate the source http://blog.csdn.net/evankaka This article mainly describes how to use

Shmmax, linuxshmmaxThe shmmax Kernel Parameter defines the maximum value of a single shared memory segment allowed by the system.Now the shmmax simulation settings are small:[Root @ localhost kernel] # cat/etc/redhat-releaseRed Hat Enterprise Linux

MySQL is upgraded from 5.5 to 5.6, the TIMESTAMP changes, and 5.6 timestampPreface Some time ago, the system MySQL was upgraded from 5.5 to 5.6, and a large number of exceptions occurred. Most of the exceptions are caused by changes in TIMESTAMP

DS-based linked list for reverse local configuration The reverse setting of data elements in a linked list is a very common example. An additional inverse function is required for the blog to reverse the input data in an ordered table, to implement

RMAN duplicate database, rmanduplicate Use the RMAN duplicate command to create a secondary database. Once the secondary database is created successfully, it is out of the source database. You can use the secondary database for some

Redis data structure (1) Simple Dynamic string and redis Data Structure Redis uses a custom struct string called simple dynamic string (SDS ).The structure is as follows: struct sdshdr{int len;int free;char buf[];}; The advantages of using such a

SQL Server Force Case sensitivity method, SQL case sensitivity1. Change a power system in the database to case sensitive. For example, if you want to modify the userPWD14 column in the table tb_TestTable400 ALTER TABLE tb_TestTable400ALTER COLUMN

Database paradigm-General handouts and database paradigm HandoutsWang Shan's introduction to database systems, a textbook used by most colleges in China, does not provide a very detailed and clear explanation in some aspects, and is not closely

Sqlserver locks a row of data, prohibit reading, modifying, and deleting, and a row In SQL transactions, you sometimes need to lock a row and release the row after the transaction is completed. Use with (ROWLOCK, UpdLock) to lock the current row.

Use innobackupex to build a mysql master-slave architecture based on the slave database, innobackupexmysql There are many ways to build MySQL Master/Slave databases. The traditional mysqldump mode is one of the choices of many people. However, this

Aerospike C client manual --- aggregation-record aggregation, aerospike ClientRecord Aggregation There are various forms to process the secondary index query results. A common form of aggregation is to apply a function to the entire query result set.

7 Managing Database Workload Using Services, managingworkload7. Managing Database Workload Using ServicesNote:A database service can only be offered on a single network.Caution:By default, any named user may create a server pool. to restrict the

SQLite tutorial (7): Data Type Details, sqlite Data Type I. Storage types and data types: SQLite divides data values into the following Storage types: Copy codeThe Code is as follows:NULL: The value is NULL.INTEGER: unsigned INTEGER value.REAL: