Database Administrator

[DataGuard] DG Series I. New Features of the physical standby Database 1. The physical standby database can be queried in real time. In the physical standby database before the Oracle 11g, the Standby database can be opened in read-only mode, but

Having is different in Oracle and MySQL. In Oracle, having must be used in combination with group by, but in MySQL, the situation is different and can be used separately. C: \ Documents ents and Settings \ guogang> sqlplus test/testSQL * Plus:

Oracle permission management: After Revoking DBA Role Oracle revoking DBA permissions: ORA-01536 After Revoking DBA Role [ID 465737.1] Applies:Oracle Server-Enterprise Edition-Version: 8.1.7.4 to 10.2.0.3This problem can occur on any

Use DbUtils for addition, deletion, modification, and query, and dbutils for addition, deletion, and modification Commons-dbutils is an open-source JDBC tool library provided by the Apache organization. It is a simple encapsulation of JDBC and has

Type conversion causes the execution plan to not go through the index test case, and the Execution Plan Index Test Environment Simulation:SQL> drop table t_col_type purge;Create table t_col_type (id varchar2 (20), col2 varchar2 (20), col3 varchar2 (2

IBatis multi-Table query, iBatis select typeid,typename from producttype where typeid=#typeid# select proid,proname,prodesc,price,img,protime,size,typeid from product

Mongodb background running, mongodb background By default, if shell is disabled, mongodb stops running. To run it in the background, you only need to add the -- fork function at startup. You can add -- logappend to the Log Path to prevent logs from

ArcGIS Engine Q & A: Why cannot the element class of the same name be generated in the geographical database? arcgisengine The reason for such a problem is that no matter whether a element class is directly put in the blank question of work or a

Oracle processes parent-child node relationships, and oracle Parent-Child Nodes It is very complicated to process the relationship between tree structures. We may traverse parent nodes or child nodes layer by layer through program code. The

ON, WHERE, HAVING, wherehaving ON, WHERE, and HAVING can filter data by limiting conditions, but their usage is different. Next we will analyze the differences among the three.1. ON and WHERE All queries generate an intermediate temporary report.

Current online redo logfile loss processing method, redologfile Yesterday, we performed a recovery drill after the rm-rf operation, without any backup. Today, before performing destructive operations, we made an rman full backup, and then deleted

Synchronize tables with MERGE statements Build the test environment first: use tempdbgoif OBJECT_ID ('t1') is not null drop table T1IF OBJECT_ID ('t2') is not null drop table T2GOCREATE TABLE T1 (ID1 INT, VAL1 VARCHAR (50) create table T2 (ID2 INT,

In rac, the vip address of a node cannot be started on this node, but can be started on other nodes ., Racvip This experiment is in a virtual machine! The same problem with the experiment: http://blog.csdn.net/wanghui5767260/article/details/38850335

Use SQL cache dependencies, database cache dependencies (with instances), and SQL instances Use SQL to cache Dependencies The simplest cache policy is to make the cache data expire after a specified time period. However, this simple method means

Oracle Development Series (1): Crazy errors: null value and no value (no result), too lenull Recently, I encountered some problems when I was doing development and writing operations. I found the cause for a long time and did not know it before. In

Redis and MongDB data sharing, redismongdb Refer: Http://blog.nosqlfan.com/html/3537.html redis Data Summary Http://blog.nosqlfan.com/html/3548.html mongDB Data Summary Problems with session sharing in redis How did you create a

Hbase integrates hive and sqoop to export data to mysql and hbasesqoop.Two advantages of hive integration of hbase tables: 1. import data to MYSQL.2. convert an hbase table to another hbase table. Three steps:1. Associate hive with hbase as an

Analysis of OCP questions 053-17 configure controlfile autobackup on, ocpcontrolfile 17. You configure AUTOBACKUP to ON an RMAN session. When will RMAN back up the control file?(Choose all that apply .) A. When you run an rman backup command B. When

MySQL Master/Slave cluster installation and configuration, masterslave This article describes how to install and configure the MySQL Master/Slave cluster. The latest stable version is GA 5.6.19. To support limited HA, we use the Master/Slave simple

SQL JOIN and sqljoin When the charging system of the data room is restructured, many functions need to query matching information in another table based on the information in one table in the database. We use the view, but have you noticed the