Database Administrator

To set latency Apply, you need to use "DELAY =" on the log_archive_dest_n parameter. For example, DELAY = 360 (in minutes) indicates that the latency is 360 minutes (6 hours ). For example:SQL> alter system set log_archive_dest_2 = 'service =

First, let's introduce the history. In Oracle 9i/10g, if one database instance needs to be evicted (an ora-29740 error occurs in the evict, alert file) for another instance, you need to write the relevant information in the control file (CF) through

Environment: OS: Red Hat Linux As 5DB: Oracle 10.2.0.4 10 Gb later, Oracle launched the Storage method managed by Using ASM (Auto Storage Management). As the Oralce version keeps changing, the ASM storage management method is becoming more and more

I.Oracle Binary OptionsDescription For more information about OracleOptions, see Oracle component series summary. We can view the related information through the v $ option view: V $ OPTION displaysOracle Database options and features. typically,

In the Oracle world, you can use: 1) case expression or 2) decode Function To realize logical judgment. Oracle's DECODE function is very powerful. If you use it flexibly, you can avoid multiple scans to improve query performance. CASE is a syntax

The mysqlcheck client tool can check and repair MyISAM tables, and optimize and analyze tables. In fact, it integrates the functions of check, repair, analyze, and optimize in mysql, There are three methods to call mysqlcheck: Shell> mysqlcheck

1. Enable binlog Mysql Servers-id = 151 Log-bin =/opt/soft/mysql/binlog/mysql-bin Binlog_format = MIXED 2. obtain basic backup /Opt/soft/mysql/bin/mysqldump-p123456 -- single-transaction -- master-data = 2 AdDataCenter | gzip> AdDataCenter. SQL .gz 3

Every mysql server node needs to run mmmd_agent, and run mmmd_mon on another machine [it can be an independent server or a server shared with the AppServer ].Mmm uses the virtual IP technology. One network card can use multiple IP

Finally, we have installed Oracle 11g in RedHat. First, we will write a summary, and I will repeat it over the weekend. 1. Download oracle11g for

Oracle Forms provides six special system variables: $ DATE $ $ TIME $ $ DATETIME $ $ DBDATE $ $ DBTIME $ $ DBDATETIME $ Among them, $ DATE $, $ TIME $, $ DATETIME $ three system variables can be used to get users Client Operating SystemThe

I had to learn mysql for a month in my last job, and soon I forgot a lot of things. Now I want to learn more about sqlite because of my work,Data Types supported by Sqlite3 NULL,INTEGER,REAL,TEXT,BLOB And:Smallint is an integer of 16 bits.An integer

Test the Mongodb + V8 JavaScript Engine I know that Mongodb's JavaScript Engine is SpiderMonkey, so I want to compile a v8 version of Mongodb and test it with the following JavaScript file. Prepare the test code: Code highlighting produced by

Basic information: Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production Operating system version: CentOS release 5.6 To speed up index creation, consider the following: Use nologging Parameters Use parallel

In OCM, the deployment uar configuration is implemented on the same host. 1. Enable the logging function of the primary database.Alter database force logging;2. Enable the archiving function of the primary databaseAlter database archivelog;3. Shut

Oracle time addition and subtraction Recently, due to the time-frame addition and subtraction tests, I found some time addition and subtraction algorithms on the Internet, which can solve the pressing problem and help more Oracle

1Decompress the installation package # Gunzip v9.7_linuxia32_server.tar.gz # Tar-xvf v9.7_linuxia32_server.tar 2, Enter the decompressed file directory, and execute the installation:(We choose to install it manually) Note:DB2_installFor manual

Tutorial 18: Table connection Query The purpose of this experiment is to master basic joint queries. Table join To obtain information from multiple tables, we can join the tables for query under certain conditions. Related reading: Basic query

The incremental checkpoint is used to balance the load. It is triggered by the fast_start_mttr_target parameter and is incrementally written out. Therefore, CHECKPOINT_CHANGE # is delayed and will not be updated immediately.Three methods are used to

No indexof () function in OracleHowever, an instr () method is provided for specific usage:Select instr ('South city of Baoding City ', 'city', 1, 1)-1 from dual;Explanation: 1. 'baoding City South region' => it can be an expression or a specific

Mysql5.5 master-slave replication of triggers, functions, storage engines, and events. I. There are three modes for MySQL master-slave replication. 1. binlog_format = row: the log records each row of data in the modified form (record page), and then