Database Administrator

[MySql fast insertion of large data volumes and statement optimization], mysql statements INSERTStatement speed The time required to insert a record is composed of the following factors, and the number indicates the approximate proportion:

[Translated from mos] computing the workday days between two dates in the Oracle database, mosoracle Calculate the number of working days between two dates (excluding those two dates, excluding weekend) Reference:How to Compute Business Days for a

3.0 Optimize Query-introduce view, 3.0 query and import View Under the efficient cloud platform, I am responsible for the students of the basic system. This includes addition, deletion, modification, and query of student information. The Student

The case sensitivity of table names in various databases Case sensitivity of database table names My colleague asked me a question about how HighGoDB connects to Oracle. It is probably because the table name in lower case is used when HighGoDB is

Create and use two temporary tables in Oracle In addition to permanent tables, the ORACLE database can also create temporary tables. These temporary tables are used to save the data of a SESSION or the data required in a transaction. When the

High-performance MySQL Reading Notes-Multi-version concurrency control algorithm, high-performance mysql1. AUTOCOMMIT Mysql uses automatic submission by default. You can view and modify it using the following command: Mysql> show variables like

Code note (7): Code note 1. Quickly change weblogic Data source: Close weblogic, under domain, find config \ jdbc \ xxx-jdbc.xml to modify2. Flashing: (implemented using setInterval) Var msecs = 500; // intervalID = setInterval ("shine ()", msecs);

About the new parameter DB_UNRECOVERABLE_SCN_TRACKING and unrecoverablefault DB_UNRECOVERABLE_SCN_TRACKING is available in 11.2.0.2. See the official documentation for the following information: Default value true Modifiable

A mysql query ProblemYesterday I wrote a complicated SQL statement. The following figure is shown:The required data now obtains the id and name fields from the product table, the quantity and totalMoney fields from buy_contract_Item and

ORA-00911 error, ora00911 ORA-00911, "911" looked very domineering error number, although I am still a beginner of Oracle, but every time I encounter a not seen ORA error number, there is a kind of catch-up, based on the error code, OERR, and

MySQL changes the storage engine of database tables. MySQL changes the storage engine of database tables 1. view the original storage engine of the table show create table user; 'user', 'CREATE TABLE `user` (\n `id` int(11) NOT NULL DEFAULT \'0\'

NoSql journey-mongoDB shell command summary, nosql-mongodbMongoDB three elements. Database, set, and document.A set is equivalent to a table in a relational database, and a document is equivalent to a row in a table.Document is json extension (Bson

Two solutions for OGG Director web hang: directorhang There are two solutions for OGG Director web hang: Description of Director web hang of OGG: It indicates that the web interface can be logged in, but the refresh date is a long time ago and does

High-performance MySQL Reading Notes-lock, transaction, isolation level, mysql transaction isolation level1. Why should I lock the lock? Because the database needs to solve the concurrency control problem. At the same time point, multiple clients

Mysql jdbc getting started, mysqljdbc getting startedI. Basic concepts of jdbcJdbc: Java Database ConnectivityTo unify database operations, sun defines a set of Apis called jdbc.This api is completely composed of interfaces. We call the api when

Aerospike C client manual --- key-value storage-Batch read records, aerospike ClientBatch read records In addition to reading a single record each time, you can also read multiple records from the cluster in a transaction. The API calls of the

In Oracle 11g, recyclebin is already a static parameter and cannot be modified online. 11 grecyclebin [oracle@rhel63single ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 20 17:19:32 2015Copyright (c) 1982, 2013, Oracle.

Windows Oracle ODBC installation configuration, oracleodbc Environment: Windows 7, 32-bit OS 1. Download the driver package The official Oracle website can be downloaded.Base package: instantclient-basic-win32-10.2.0.4.zipOdbc package: instantclient-

Oracle Database cursor case and source code (2), oracle cursor For detailed analysis of this case, see the Oracle database cursor case and source code. Http://blog.csdn.net/sinat_26342009/article/details/45199827Case requirements: Use a cursor to

SQL Server paging stored procedures, SQL stored procedures USE [ReportServerTempDB] gocreate procedure [dbo]. [SeachTablePage] (@ TableName VARCHAR (200), -- table name @ Fileds VARCHAR (500), -- query field @ OrderFiled VARCHAR (100), -- Sort field