Database Administrator

Oracle 11g cannot export empty tables in multiple ways Oracle 11g empty table cannot be exported: Data Query shows a new feature in Oracle 11G: The new parameter "deferred_segment_creation" indicates that the segment delay is created. The default

PostgreSQL MVCC source code implementation MVCC is no stranger to every DBA, that is, Multi-Version-Control ). Because the data has multiple versions, the read and write operations are separated to a certain extent, improving the database's ability

How to configure the STATSPACK performance report of Oracle 11g ADG Create a normal STATSPACK report user on the master database Sqlplus/as sysdba SQL> @? /Rdbms/admin/spcreate. SQLSQL> -- cancel some settings of $ Oracle_HOME/sqlplus/glogin.

GoldenGate Security Configuration When implementing GoldenGate, security is often ignored. However, as a complete GoldenGate system, basic security settings are still necessary, such as password encryption. GoldenGate has the following five Security

Oracle RMAN-06023 and ORA-19693 errors When restoring a 0-level backup database to another machine, first encountered a RMAN-06023 and then encountered a ORA-19693 error, the error occurred in the environment and content is roughly as

Case of ORA-00020: No more process state objects available fault Today, a user consulted about database downtime. At that time, the database showed symptoms that users could not log on. To learn the cause, he checked the warning Log alert of the

PostgreSQL physical file ing We know that in PG, each relation, that is, the table, has several fork mappings. "MAIN" fork is used to store the data in the master table, "FSM" fork is used to manage the free space, and "visibility" fork is used to

SQLyog keyboard shortcuts and sqlyog shortcuts SQLyog keyboard shortcut ConnectionCtrl + M create new connectionCtrl + N create a new connection with the current connection PropertyCtrl + F4/Ctrl + W disconnect the current connectionCtrl + Tab

Mongo java and/or multi-condition query, using java// And, or multi-condition joint Query// Age condition (and condition)BasicDBList condList = new BasicDBList ();BasicDBObject cond = new BasicDBObject ();Cond. put ("$ gt", 0 );Cond. put ("$ lte", 40

One-click excel export and excel Export How to export an excel file with one click Public function input (){ Ob_end_clean (); // clear the buffer to avoid garbled characters. Header ("Content-Typ: text/html; charset = UTF-8 "); Vendor ('excel.

Basic php Method for operating memcache cache, phpmemcacheHow to operate memcache in phpTo use memcache, you must configure the memcahche environment on the server! After confirming that memcahce can be connected normally, it can be used in the

Redis memory management code comment, redis memory management comment Zmalloc. h /* Zmalloc-total amount of allocated memory aware version of malloc () ** Copyright (c) 2009-2010, Salvatore Sanfilippo * All rights reserved. ** Redistribution and

The DB query analyzer allows you to easily create DB2 user-defined functions. The DB query analyzer allows you to easily create DB2 user-defined functions.Magenfeng(Guangdong Union Electronic Service Co., Ltd., Guangzhou 510300, China) SummaryThis

Updates to join table queries and table updates Background: I wrote a blog about database join Table query, "read database -- (6) Connection". It mainly talks about the connection type and how to use the connection for multi-Table query. This blog

When deduplication is, temporary processing is disabled, and 80 Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally

Is SQL Server's clustered index really the best ?, -- Simulate the environment first. The following describes how to USE [Temp] GO-drop table [TestTab] truncate table [TestTab] create table [dbo]. [TestTab] ([UserAcount] [varchar] (50) not null,

12-SQLite transactions and 12-sqlite transactionsI. Transaction Overview A transaction is a series of operations performed as a single logical unit. Multiple operations are submitted to the system as a whole, either executed or not executed.

Oracle internal and external connections, oracle internal connections Inner join: We usually connect tables to display data with matched IDs. SELECT * FROM a, B WHERE a. aid = B. bid only retrieves matched data. Outer connections: Left

What does Sequence mean?SQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production the following is an

Redis data structure (2) dictionary, redis Data Structure dictionary The Redis dictionary is actually a Hash table. Its implementation is similar to the hashmap structure in JAVA. Key-Value pairs are stored in Key-Value mode, but there are some