Database Administrator

Implementation of standalone database in Redis Principle The Redis server saves all databases in the db array of the redis. h/redisServer structure in the server status. Each item in the db array is a RedisDb structure, and each redisDb structure

Database Stored Procedure introduction and instance, database Stored Procedure instance I. Differences between stored procedures and functions: 1. In general, the functions implemented by stored procedures must be more complex, while the functions

Application of nextVal and currVal in the database., nextvalcurrval X. nextVal gets the next sequence value of x sequence, and x. currVal gets the current sequence value of x sequence. Note:X.CurrVal must be referenced beforeX. NextVal; otherwise, a

Oracle performance optimization operation 4: Remove "IN", "OR" whenever possible, oracle Performance Optimization The Where clause containing "IN" and "OR" usually uses a worksheet to invalidate the index; If a large number of duplicate values are

Oracle performance optimization operation 2: Avoid unnecessary type conversion and oracle Performance Optimization It should be noted that the potential data type conversion should be avoided as much as possible. For example, if you compare the

Install the MySQL-server and MySQLdb modules in ubuntu14.04, and ubuntu14.04mysql Install Ubuntu14.04 on a VM 1. Check that the IP address can be connected to the Internet. Ii. sudo apt-get install aptitude Note: aptitude features similar to apt-

Oracle deletes data and oracle deletes data. The syntax for Oracle to delete data in a table is: Syntax structure: Delete from table name WHERE Condition Code Demonstration: SQL> delete from infos where stuid = 's100103 '; 1 row deleted SQL>

Summary of connection timeout in Hibernate + C3P0, Recently, the background always encounters a connection timeout problem when several game zones concurrently notify the background to write statistics. The following exception is thrown, causing

A bug ORA-00064 encountered when sga_target is set to be greater than GB: object is too large, sgatarget Host memory 256 GB, sga_target ready to be set to 160 GB, DBCA always reports an error ORA-00064 when creating a database: object is too large

Jdbc connects to the mysql database and executes the insert statement to obtain the self-increasing primary key value. jdbcmysql Package cn. baokx; import java. SQL. connection; import java. SQL. preparedStatement; import java. SQL. resultSet;

MySQL Server alarm script, mysqlserver Author: SkateTime: 2014/12/30   MySQL Server email alert : Http://download.csdn.net/detail/wyzxg/8314745   Implementation Method: The system's load and session are used to determine whether the system's current

[MongoDB] MongoDB aggregation framework (I): mongodb aggregation framework Question: There are three days to end on March 13, 2014. The plan for this month has been completed in addition to the plan for summarizing Mongodb. Recently, due to laziness,

MFC printing and mfc Printing Although more and more people are turning to C # For interface development, for a person who is used to the semi-object-oriented language C ++, the existence of MFC is still difficult. Recently, I am doing some database-

Add 23 common MySQL query statements to favorites1. query numeric data:SELECT * FROM tb_name WHERE sum> 100;Query predicate:>, =, ,! =,!> ,! =,  2. query stringsSELECT * FROM tb_stu WHERE sname = 'Liu'SELECT * FROM tb_stu WHERE sname like 'Liu

The defects of using the skewonly parameter to collect histograms under 11G have been fixed, 11. We have previously verified the defect of using the skewonly parameter to collect histograms in 10 GB and fixed it in 11 GB. The histogram is becoming

[Oracle] implements ledba17 The database returns and error and the database instance shuts down, implements ledba17shuts A media failure has occurred. This has resulted in all the membe Rs of the next hop log group being rendered inaccessible to the

[Oracle] export ledba18 You can not set a value for the DB_8K_CHCHE_SIZE parameter., oracleparameter You have set some of the initialization parameters: DB_BLOCK_SIZE = 8 KB SGA_MAX_SIZE = 2 GB SGA_TARGET = 0 SHARED_POOL_SIZE = 120 MB DB_CHCHE_SIZE =

Backup _ use word to write and export multi-Table statements and word statements Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be

ORACLE-005: Create a JOB (2), oracle005 create a job How to Create a job with parameters. We can directly declare the parameters and assign values, and then pass them to the stored procedure called by the job. For example, the stored procedure

EntityFramework delayed Loading Delayed loading: load (read) only when we need to use it)   When we want to view the order information, we want to use delayed loading to display the detailed records of the corresponding order. This not only