Database Administrator

Download patches from Metalink Log onto Metalink (https://support.Oracle.com) and Oracle users can use ARU to download it. Click the Patches & Updates tab. In the "Patch Search" area, enter your Patch number, Search, After finding your Patch, pay

The databases we usually use are based on the GUI. In Windows and other graphical operating systems, interactive installation is convenient. However, in many cases, there are many restrictions on Interactive Graphic installation. First, the graphic

Sometimes, users may encounter access to schema... Denied and other error messages. In Postgresql, data access permissions are divided into at least two levels. One is schema and the other is table. Therefore, for a common user test, if a Super

Between RmanAutomatic Recovery: We just backed up the full database, single tablespace, data file control files, and parameter files of the database. The backup content is an indispensable element for database operation, generally, you only need to

Summary:1. Primary keys and composite primary keys have the same query performance (the same index height and the appropriate use of indexes ).2. Primary keys and composite primary keys. The (update, insert) performance is different (because

VPD is used for development in the project. The creation of Database User B objects depends on user A. Because user A objects perform DDL, migration, dump, and other operations, this results in the INVALID of user B. User B is used as the data

Oracle learning can be implemented and maintained independently. Of course, optimization is a long time-consuming experience and requires more experience. The following are some online materials that you can find. In general, SQL statements are

Because the project needs to use the database, and it cannot depend on a specific platform but also requires flexibility, so I thought of SQLite and started to modify and use the source code. Here I will record it for the sake of memo, the following

The storage of the unique index is different from that of the non-unique index. The storage of the non-unique index needs to store the ROWID as a column, and the unique index stores the ROWID in the DATA area, the following shows how to store the

The following error occurs when importing impdp data: ErrorsInFile/Oracle/app/diag/rdbms/gavin/Gavin/trace/Gavin_arc0_5889.trc: ORA-19809: exceeds the limit on the number of recovery files ORA-19804: unable to reclaim 49837568 bytes of disk

Upgrade environment: 1. RAC 11.2.0.1 to RAC 11.2.0.2 2. RAC 11.2.0.1 to RAC 11.2.0.3 3. RAC 11.2.0.2 to RAC 11.2.0.3 The above DB software is upgraded using the out-of-place upgrade method. If there is a problem with the upgrade process after the

Today, a friend tested SQLite and concluded that the efficiency of SQLite was too low. It took 2 minutes to insert 1000 records in batches! Using System. Data;Using System. Data. Common;Using System. Data. SQLite; // Create a database fileFile.

EXP-00024: Export view not installed, please notify your DBA EXP-00000: Export termination failed 1. log on to the database as sysdba Connect username/password as sysdba 2. Terminate the database SQL> shutdown immediate 3. Start the database

Cause: The operating system takes time to kill the process. On some platforms it takes some time to kill processes -- AIX being one of those platforms There have been previous reports of shutdown taking time on AIX and after all Oracle waits were

Time-based recovery Time-based recovery restores the database to a time point between the backup point and the failure point. Time-based recovery can be used not only when the media fails, but also when the database runs normally. For example, if a

Environment: AIX6.1, Oracle10.2.0.3 Create a single instance on a node of RAC and create it using DBCA. An error is reported when the configuration is complete. Error: ORA-29702Text: error occurred in Cluster Group Service operation Cause: An

Ubuntu 12.04 MySQL cannot be started after UTF-8 is changed Default-character-set = utf8 Error: Start mysql. The restart (8) utility is also available.Start: Job failed to start So OK: On MySQL 5.5 I have in my. cnf [Mysqld]Init_connect = 'set

HBase is an open-source implementation of NoSQL and BigTable,From apache, which is the database part of Hadoop. I have set up and run an HBase on a virtual machine for learning. I would like to briefly describe the setup process. Environment: WinXP

Each Block in Oracle has a part called ITL, which is used to store transaction information. The number of ITL of an object is determined by the initrans and maxtrans parameters of the object. The Oracle official documentation records that the

Use scripts to manually back up the database's datafile, redo log file, and control file to the specified directory OS version: [Oracle @ sam tmp] $ cat/proc/version Linux version 2.6.18-274. el5 (mockbuild@builder10.CentOS.org) (gcc version 4.1.2 20