Database Administrator

Oracle has set up a dedicated apt source server for Ubuntu users. You only need to add a line in/etc/apt/source. list:Deb http://oss.oracle.com/debian unstable main non-freeYou can. Before running the apt-get update command, you must add the public

Recently, the disk space of the Oracle server in the development environment is full, so I began to delete things everywhere and finally delete the files. I started to think about oracle data files again, due to the lack of knowledge about oracle,

As the database data volume continues to grow, some tables need to be converted from normal heap tables to partition tables. There are several different methods for this operation, such as exporting table data, creating a partition table, and then

Some objects cannot be compiled after the database is upgraded from 10.2.0.3 to 10.2.0.5 recently. The results show that these objects are mainly manifested in SQL syntax that is not strictly written before, which leads to the failure of compilation

Oracle recommends that the OLTP (on-line TransactionProcessing) system accounts for 80% of the total system memory, and then allocates 80% to SGA and 20% to PGA. That isSGA = system_total_memory * 80% * 80%PGA = system_total_memory * 80% * 20%1.

Once the database is restored, open reports an error ORA-00349, as shown below. Finally, delete the log group. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00349: failure obtaining block size for '+ fra_kg0

The undo tablespace is an important part of the Oracle architecture. The reason why we can roll back is that we have it. Any data modification in the database will generate the pre-image in the undo tablespace. One is rollback, and the other is

Using Oracle PL/SQL code encryption to protect the business logic is very useful in some scenarios. The following is a simple arrangement: 1. Use the Wrap command to encrypt 2. Use the dbms_ddl package for encryption Iii. Oracle encryption

Restoring oracle 10g RAC [restoring OCR] ---- Query OCR status:#/Oracle/product/10g/crs/bin/ocrcheckPROT-601: Failed to initialize ocrcheck  --------- Replacing the original OCR disk, an error occurred:#/Oracle/product/10g/crs/bin/ocrconfig-replace

Originally, LAMP programmers had to use the help of the operating system to complete some periodic database operation tasks, such as Windows scheduled tasks or Linux contab. MySQL5.1 has finally added the Event Scheduler function, which allows you

1. knowledge required in advance1. Every database in redis is stored in a redisDb structure. Here, redisDb. id stores the numbers represented by integers in the redis database. RedisDb. dict stores all key-value pairs of the database. RedisDb.

Starting from 10 Gb, Oracle provides more efficient Data Pump (expdp/impdp) for Data import and export. The old exp/imp can also be used, but it is not recommended. Note: expdp/impdp AND exp/imp are incompatible. In other words, exp exported files

The crs_stat command in Oracle 11g RAC has many new resource types compared with the previous version. By default, crs_stat-t is used to check that resources are a large piece of data, it looks really laborious. The author Paul Elbow and Enkitec

Oracle Data Guard provides the most effective and comprehensive Data availability, Data protection, and disaster recovery solutions for enterprise databases. It integrates management, monitoring, and automated software infrastructure to create and

Oracle Data Guard provides one or more slave databases for the production database (a copy of the database ), to ensure that data is not lost when the master database is unavailable or when exceptions occur, and continue to provide services through

CKPTQ: The data block in the Checkpoint Queue records the LRBA address of each data block. RBA: Redo Block Address (Address of the Redo log Block, which is equivalent to the rowid in the data file. You can use this Address to locate the Redo log

1. First, check whether MySQL or mysql has been installed. command: Rpm-qa | grep MySQL Rpm-qa | grep mysql Because the installation is described here, if both mysql-client and mysql-server have been installed, you can directly use it without

Compared with performance, DB2 import and load log records are slow, and data records are too large, which may cause full transaction logs. However, some operations have to be logged, therefore, it is not applicable to import. However, it can be

Oracle Vault is an important part of the three security technologies. Compared with the other two types, Label Security and Virtual Private Database (VPD), Oracle Vault better reflects the O & M system management and Security rule configuration.

Use of encrypted tablespace under Oracle 11 GB Oracle Undo image data exploration Oracle ROLLBACK and Undo) The Undo tablespace cannot be opened because it is damaged. How to handle Undo tablespace failures Oracle Undo tablespace reconstruction and