Database Administrator

There are many optional gather _ *** _ stats in Dbms_stats. For example, cascade/estimate_percent, You can manually modify its default value.10G provides set_param for modification, but it can only be used for global modification. 11G provides a lot

The master-slave replication configuration of apsaradb for redis is quite simple. Only two sentences are required. Through master-slave replication, multiple server Load balancer instances can have the same database copies as the master server. The

Oracle storage structure, which can be divided into physical and logical structures. The latter is born to facilitate management of the former. Oracle stores data in tablespaces logically and physically in data files.There are two views that we may

What are the differences between the following three SQL statements for join queries? SELECT * FROM film JOIN film_actor ON (film. film_id = film_actor.film_id)SELECT * FROM film JOIN film_actor USING (film_id)SELECT * FROM film, film_actor WHERE

Assume that the data in the test database is to be synchronized, but the test. secret table is not synchronized. A. Perform the backup operation and refresh the log on rdb1.Mysqldump -- flush-logs-uroot-p $ pwd -- default-character-set = gbk --

After a data recovery, encountered the ORA-00600 kcbz_check_objd_typ_3 error, record here.First, the error kcbz_check_objd_typ_3 indicates:When Oracle checks the data block in the memory, it finds that the object number on the data block is

DUPLICATE Overview The rman duplicate command can be used to create a copy database (DuplicateDatabase) based on the backup of the target database (TargetDatabase) while retaining the target database ). This copy can be exactly the same as the

1. Create Table T2SQL> create table t2 (A1 number (10 ),A2 char (10) tablespace users; 2. Insert two rows of dataSQL> insert into t2 values (33, 'cc ');SQL> commit;SQL> alter system switch logfile;SQL> insert into t2 values (44, 'dd ');SQL> commit; 3

SQLPLUS> alter database datafile 2 ONLINE;Alter database datafile 2 ONLINE*ERROR is located in row 1st:ORA-01190: control file or data file 2 comes before the last RESETLOGSORA-01110: data file 2: 'e: \ Oracle9I \ ORA9I \ undotbs01.dbf'Next, because

Rman backup appears ORA-19625: The reason is that the archive log is deleted in the operating system and has not been backed up yet. When rman backs up the log, the archive fails to be found. You can solve this problem by using the following

1. Create a table T2 to insert two rows of data. If the first row of data is written into the archived log, the second row of data is in the online log.SQL> create table t2 (A1 number (10 ),A2 char (10) tablespace users;SQL> insert into t2 values (11

1. Create a function in Oracle Create[Or Replace]FunctionFunction_name [(Parameter_name [In|Out|In Out] Type [,...])] Retutn type Is|As Begin Function_body; End; Note: The function must return values.Or replace: If the function already

[Grid @ vm11gr2]/home/grid>Sqlplus "/as sysasm"SQL * Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:16:21 2009Copyright (c) 1982,200 9, Oracle. All rights reserved.Connected to an idle instance.SQL>StartupORA-01078: failure in processing

Cancel-based Inconsistency Recovery (archive) Article 1   Cancellation-based recovery only applies to the following situations: loss of archived logs leads to full recovery failure; loss of data files and Unarchived redo logs (online redo logs );  

Redis is a distributed NoSQL Database System Oriented to "key/value" pairs of data types. It features high performance and persistent storage, and is suitable for high-concurrency application scenarios. It started late and developed rapidly. It has

1. DUMP DatafileBlock example There are three types of SCN in a data block of Oracle: The Block header SCN, the CSC (cleanout SCN) and the commit SCN recorded in ITL. If we want to view the content of a block or some blocks, we can dump these blocks

Remote access to the mysql database:1. First, make sure that the firewall blocks the mysql database port (default: 3306 ).In Linux, you can use the following command to disable the Firewall:# Service iptables stopFor more information about how to

1. Create a data table CREATETABLETEST ( ID NUMBERNOT NULL ,NAMEVARCHAR2 (20 BYTE)NOT NULL , BOSS_ID NUMBER ,CONSTRAINTTEST_PKPRIMARYKEY ( ID ) ENABLE ); ID indicates your employee code BOSS_ID indicates the code of the superior

Profile SettingsINV: Debug Trace: YesINV: Debug Level: 10 (or greater than 10, less than 15, the higher the Level, the higher the log details) INV: Debug file:/usr/tmp/invdebug. log Note: The path specified by INV: Debug file must be in the

These two days are busy studying postgresql. The basic usage is similar to that of other databases. I will not explain it myself. Today I want to record the postgresql cluster solution hot standby. Set the Cluster Environment myself: Three computers: