Database Administrator

I. IntroductionNoSQL databases become more and more popular because of their scalability. Using NoSQL databases can bring you more benefits. MongoDB is an open-source NoSQL database compiled in C ++ with high scalability. This article describes how

Due to Oracle version problems, the tables exported by 11 GB by default cannot be imported into 10 Gb.The following error is reported:Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit ProductionWith the Partitioning, OLAP

Previously, all the systems installed in the virtual machine were Ubuntu. Later, my colleagues said that the general servers were CentOS, so they reset the centos system. Of course, you must first build a PHP environment. The downloaded source code

Sometimes, the EBS reports insufficient connections. Therefore, we try to improve processes and sessions. After EBS is installed, the default value of the init parameter processes is 200, and the default value of sessions is 400. here I increase the

Redo log files Record Database Change Data. Generally, the failure of redo log files will not cause database data loss, but will affect database recovery. Redo logs can be divided into two statuses: Current online redo logs and non-current online

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

In the previous encountered ORA-00600 Kcbz_check_objd_typ_3 error, and later found a related implicit parameter through the query information: _ db_block_check_objtypWhether to perform object number and object type check for the definition of this

Index performance: 1. Do not design fields such as char (100) as indexes. 2. The number of Index fields cannot exceed 3 3. The Index will also be locked, which may cause performance problems of new locks. 4. Try to avoid using indexes. Index is

There is a problem that has been confusing for a long time. When Oracle 10g rac is upgrading crs, it should fail. RAC is a joke. This test is completed on the Linux platform. Exercise caution when operating the production database. 1. Back up ocr

Overview of temporary tablespace groups In Oracle 10 Gb, you can create multiple temporary tablespaces and form a temporary tablespace group. In this way, you can use multiple temporary tablespaces in the group for sorting, A temporary tablespace

Source: Oracle dba ppt06 Maintaining the Control File1. Learning Objectives1) Explain the use of control files2) List Control File Content3) Diversified Management and control documents4) use OMF to manage control files5) Get Control File

Although the latest MySQL installation files contain MySQL Workbench, which facilitates modeling and database generation, the best database modeling tool is Sybase's PowerDesign, which allows us to easily build a model at a time, A Sihai

SAVEPOINT http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10001.htm#SQLRF01701 provided by official documentation 1. Purpose: Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back. Use the

I.Test Environment SQL> select * from v $ version where rownum = 1; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release11.2.0.3.0-64bit Production SQL> create table

I suddenly thought of testing the real I/O capabilities of the database. Although the hardware engineer has a set of methods to test IOPS, Oracle also launched the ORAXXX test tool. in the actual application environment, IOPS is affected by table

Raw Trace collection method 1. Open Trace, Help> Diagnostics> Trace with Binds and Waits. Meaning of the Trace item No Trace-turns trace off. Regular Trace-generates a regular SQL trace by executing the following statement: Alter session 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

Content Oracle Data Pump technology allows you to quickly move Data and metadata from one database to another. Data Pump Component How to move Data Pump References Data Pump Component Oracle Data Pump consists of three different parts: Command

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

Content One of the most notable features of import is the import mode, because to a large extent, the mode determines what to import. Apply the specified mode to the operation source, such as the source or dump file set, or another database