Database Administrator

The db_recovery_file_dest_size parameter is used to limit the total size of files that can be stored in the Flash recovery area. Once the db_recovery_file_dest_size parameter is set to a non-zero value, it is "difficult" to restore to the default

1: When installing Linux, install X Window System, GNOME Desktop Enviroment, Development Tools, Legacy Software Development 2: After installation, run the rpm-q command to ensure that the following packages are successfully installed:Binutils-2.15.92

Source code download wget http://admin.ooopic.com/soft/linux/cmake-2.8.3.tar.gz  wget http://www.wapm.cn/uploads/csft/4.0/coreseek-4.0.1-beta.tar.gz  wget http://ftp.jaist.ac.jp/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.9.tar.gz  Tip: the

Today, I upgraded MySQL from 5.1.26-rc to 5.5.15. The source code packages downloaded from the official website are compiled. MySQL 5.5.15 is provided by my colleagues. Because the existing database uses the innodb engine, mysqldump is used to

Problem: After enabling SQL Server 2008, you do not need to manually add the local administrator group because it is added by default during installation. You only need to manually add the current user to the local administrator user. This means

A data dictionary is used to store database information. It can be used to understand the internal information of an Oracle database, such as the table creator, creation time, tablespace, and user access permissions. DBAs must fully understand the

In Oracle, you must query the non-repeated columns t. address and t. mermer_name in the customer table: The general idea is: Select distinct t. address, t. customer_name from customer t However, this method is incorrect in oracle. Therefore,

The comparison between the round () function and trunc () function in Oracle is very practical. Round (x [, y]) [Function] returns the rounded value. [Parameter] x, y, numeric expression. If y is not an integer, the y integer is truncated. If y

SQLite statement: Select count (*) FROM sqlite_master where type = 'table' and name = 'student '; If yes, 1 is returned; If it does not exist, the return value is 0. C # statement: SQLiteCommand mDbCmd = mDbConn. CreateCommand (); MDbCmd.

I. Summary of list Common commands THE list command lists the backup information in the control file and RMAN recovery directory, which is one of the most intuitive ways to understand all visible database backup files. List incarnation; List backup

I have created a test data table and want to test the difference between creating an index and not creating an index. The data volume of the created table is 108631962 rows. Insert 9999999 rows at a time, about half an hour at a time. It takes 37

Preface After installing MySQL, you must optimize and adjust various MySQL Parameter options. Although the MySQL system is highly scalable, it can run efficiently in an environment with sufficient hardware resources or in a few resource environments.

Error: [Oracle @ prudentwoo admin] $ sqlplussystem/oracle @ PRUDENTWOO SQL * Plus: Release 11.2.0.1.0 Production onWed Dec 12 03:23:29 2012 Copyright (c) 1982,200 9, Oracle. All rights reserved.   ERROR: ORA-12514: TNS: listenerdoes not currently

1. The binlog logs are deleted several more times and the MySQL master is not synchronized. Mysql> show slave status \ G; Slave_IO_Running: NoSlave_ SQL _Running: Yes View the error log [ERROR] Slave I/O: Got fatal error 1236 from master when

For example, in the employee basic information table, there are employee names, employee positions, birth dates, and so on. If the three fields in the current view are displayed in the same field, there is a delimiter in the middle. For example, I

Currently, BI presentation is generally based on historical data analysis. To achieve real-time BI, it is not impossible to achieve it. Some time ago, due to work needs, Microsoft's Active cache mechanism was specifically verified.I. Basic

1. create any directory ): SQL> create user Oracle identified by oracle; The user has been created. SQL> grant dba to oracle; Authorization successful. SQL> grant create any directory to oracle; Authorization successful. SQL> conn

I accidentally read the following figure: This is the structure of a scores table, which has two faminly: course, grade   Next let's take a look at the regrioninfo information: 2147483647 BLOCKCACHE 2147483647 BLOCKCACHE REGION => {NAME => '

Oracle uses the spfile . ora file as the startup parameter file. If the file does not exist, search for the spfile. ora file. If the spfile . ora and spfile. ora files do not exist The init . ora file is used. If none of the preceding three files

Q: How to back up data under a field in a table in the Oracle database? This problem has plagued me and found a lot of information about it through Baidu search. But none of them can help me solve this problem. Solution: try to create a temporary