Database Administrator

Comparison Statement of Oracle Database Object growth record query: Select * from (Select a. owner, a. segment_name, a. tablespace_name, B. megas-a.megas diffFrom(Select owner, segment_name, tablespace_name, sum (megas) megasFrom object_rdWhere

Mongodb supports master-slave replication without verification, but only one configuration role is master and oplog, And the other configuration role is slave and master's ip port. If it comes with verification, it will be troublesome. Master: 1.

This type of requirement is usually met in JAVA development. If a piece of data already exists in the table, update it. If it does not exist, insert new data. If you do not use the merge syntax provided by Oracle, you may first need to query the

The following table lists the types of locks added to the table and the compatibility between the locks and other types of operations. Table 13-3 Summary of Table Locks SQL Statement Mode of Table Lock Lock Modes Permitted?

-- 1. Create the fn_Split function. (split string, returns a table with the column name id) If exists (Select*FromDbo. sysobjectsWhereId = object_id ('Fn _ Split')And(Type ='Fn' OrType ='Tf' OrType ='If')) DROP FUNCTIONFn_Split GO

Recently, I have seen people using the with table as statement in the forum. Generally, they are building a temporary table for testing. After studying the usage of this statement, I understand the following benefits: 1) You can easily create a

Previously, we have set up the PAA environment for rac and data guard of a single instance database (see). To facilitate the switchover operation, we have configured data guard broker for the operation here! In the rac environment, you need to store

1. Location of Region In Google's BigTable system,TabletThe storage address is located through the three-layer directory structure ,: Note:TabletEquivalent to Region in HBase Illustration: (1) METADATATable METADATATable is a pre-defined Table.

I. Concept of hash join Hash join (HJ) is a technology used for equi-join (and anti-join is the join when not in is used. In Oracle, it was introduced from 7.3, To replace sort-merge and nested-loop join to improve efficiency. When the optimizer

DBAs are not familiar with this file. What everyone knows most is that sqlnet. ora is used to determine how Oracle parses the strings that appear in a connection. For example:Sqlplus sys/oracle @ orclSo how to resolve this orcl? If your sqlnet. ora

1. Import CSV data The content of the user.csv file is as follows: _ Id, name, ageObjectID (4eed9f9ca939118694cf05e4), "ming", 10ObjectID (4ef1f3cf3bd18218e6bdfa31), "lisi", 20   You can import the data in user.csv to the user set of the localdb

Install ports with FreeBSD Step 2 # Cd/usr/ports/databases/mysql40-server/ Step 2 # Make install Depending on your network speed, it may take more than 10 minutes ... Step 2: Install the database #/Usr/local/bin/mysql_install_db Step 2: # Chown-R

The error message is as follows: SQL> startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device Check 1. The memory size of the operating system. Make sure that the size of the configured SGA + PGA does not exceed the

The snapshot control file is a temporary snapshot control file that RMAN creates to re-synchronize from a read-consistent version of the control file. RMAN only needs a snapshot control file when re-synchronizing with the recovery catalog or when

The lag and lead functions are used to retrieve the data of the first n rows and the data of the last n rows. They must be combined with the over (order by) function.Select id, name from daveId name4 SF3 Oracle4 eygle5 rman4 export The dave table

RHEL5U5 + Oracle 11gr2 does not have many steps to manually create a database on bare devices. Therefore, you can simply paste the steps and do not have any Chinese comments. It is only used as personal notes, if some netizens fail to understand or

Master Server IP Address: 1.1.1.21 Slave Server IP: 1.1.1.22 Note: This document only describes synchronization of the master node and slave node, rather than mutual backup. To achieve mutual backup, perform the following two steps after completing

Use the substr function of Oracle to obtain the string with the specified start position and length Substr (string, start_position,[Length])For example:Substr ('This is a test',6,2) WowouldReturn 'Is'Substr ('This is a test',6) WowouldReturn 'Is a

For the four phases of Oracle Database startup, see: 1. The database is in the SHUTDOWN status. In this status, the database is stopped. External data requests cannot be accepted. You cannot use the operating system command ps-ef | grep ora to see

Directly add content First, the CASE conditions in the Stored Procedure CREATE PROCEDURE p_case(IN parameter1 INT)  BEGIN      DECLARE variable1 INT;      SET variable1 = parameter1 + 1;      CASE variable1          WHEN 0 THEN INSERT