Database Administrator

Oracle 10 Gb Standby Database real-time application of redo data ------- Physical standby database: Standby redo log needs to be configured for real-time apply; When real-time applications are enabled, log application service directly receives

Buffer sort in Oracle execution plan The buffer sort in the Oracle execution plan is not actually sorted. It only loads data to the memory and does not scan tables multiple times. -- Manufacturing data Drop table test purge;Drop table test1

How to Use RMAN Incremental backup to restore data guard log gap) The minimum scn information of the master database:SQL> col current_scn for 999999999999999SQL> SELECT CURRENT_SCN FROM V $ DATABASE; Select min (fhscn) from x $ kcvfh; Select min (f.

How does one determine whether the SQL statements are actually sorted in Oracle? In Oracle, sometimes when you see the sort keyword in the execution plan, some people think that the sorting is actually not necessarily. You can experiment with the

Analysis on Redis implementing lock mutex Resource Access Redis is a popular open-source key-value database. At present, ruisi's background architecture adopts a combination of Redis and MySQL on the database layer. Redis is mainly used to store

Common Redis commands and master-slave Database Configuration Redis provides a variety of commands to operate databases and various data types. (1) keys Returns all key values that meet the specified pattern. For example, to return all keys, use:

Redis database (set type and zset type) 1. set Type Set is a collection of unordered string types. set is implemented through hash table. the time complexity of adding, deleting, and searching is O (1 ), for a set, we can take the Union,

ORA-32701 troubleshooting I. Version Information Operating system version: AIX 61009 Oracle Database Version: 11.2.0.3.11 (RAC) Ii. Error description Check found that a set of rac two instances Using ASM basically reported a ORA-32701 error every

Make HAProxy 1.5 aware of the delay of MySQL Replication In the MySQL world, HAProxy is usually used as a software Load balancer. Peter BOLOs explained in his past emails how to use the percona xtradb cluster (pxc) to set it. Therefore, it only

On linux, java uses javasqlite and linuxjavasqlite.Use objective qlite in java on linux Http://www.ch-werner.de/javasqlite/ 1) download: Http://www.ch-werner.de/javasqlite/javasqlite-20140624.tar.gz 2) decompress the package and enter the

Use ORACLE External tables to load complex data and oracle External tables Original article: http://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13asktom-1886639.html I am using SQL Loader to load data into tables from a flat file. Some

How to solve the 1366 error in mysql, mysql1366 Recently, I made a project for the school. oracle is used for the database. If oracle is installed in windows, it is relatively simple, but unfortunately, before I took over the project, I just

Sharp SQL2014: Join algorithm, sql2014 join algorithm  When performing a query in Microsoft SQLServer Management Studio, if you select the button in the toolbar, you can see the execution plan generated for the query. The execution plan graphically

Mongodb installation and VerificationInstallation plan:System Environment: Centos-6.5Software: mongodb-linux-x86_64-2.6.5.tgz: Http://www.mongodb.org/downloadsInstallation machine: 10.10.10.110Upload location:/dataSoftware installation

How can I use the IP address after ORACLE modifies the IP address? Author: iamlaosong After the IP address of the oracle database server changes, the listening process cannot be started. You need to modify the corresponding configuration file: 1.

The specified SID already has a solution on the local machine.After the Oracle is uninstalled abnormally, it is installed again. If the configured SID is the same, "the specified SID already exists on the local machine. Please specify a different

[10] An error occurred while starting the Integration Service. integrationserviceError message: LM_44229 Failed to authenticate login. [PCSF_10342] [PCSF_10342] Exception occurred: [[AUTHEN_10000] The Service Manager failed to authenticate user

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

In the hpux operating system, select the lv from the vg, make the lv into a file system, and then mount the file system, In the hpux operating system, select the lv from the vg, make the lv into a file system, and then mount the File System Create

Extended root partitions managed by lvm in rhel5.9, rhel5.9lvm Extended root partitions managed by lvm under rhel5.9 Core steps: Add sdb -----> pvcreate -----> vgextend -----> lvextend -----> resize2fs The file system information is as