Database Administrator

On the ASM instance of 11.2, execute show parameter spfile:[Grid @ rac1 ~] $ Sqlplus/as sysasm SQL * Plus: Release 11.2.0.1.0 Production on Sun MAY 11 15:56:12 2014Copyright (c) 1982,200 9, Oracle. All rights reserved.Connected:Oracle Database 11g

New Features of Oracle 12C Temporary UNDO can reduce the amount of data stored in the undo tablespace and the generation of redo logs [Oracle @ db12c ~] $ Sqlplus/as sysdba SQL * Plus: Release 12.1.0.1.0 Production on Mon Apr 28 14:18:21

Today, we used to import all the information from one Oracle user to another. For example, if one user on one machine is aa, all information of the aa user, such as tables, tablespaces, and indexes, needs to be copied to the local database on

The UTL_FILE package can be used to read and write text files on the operating system. UTL_FILE provides file access functions on the client (FORM, etc.) and on the server. Create a test directory: Create a new command window; Create a directory:

A customer is concerned about the recovery of logical errors. The solution we recommend to him is to use the flashback Technology on the disaster recovery database. Below is a simple Linux script. #! /Bin/bash Export LOGIN_USER = testExport

I can only say that it seems that I have solved this Configure problem, but I still want to recommend that you confirm the input method when you press the Enter key. This is what I felt afterwards. I believe you have already searched the internet.

In 2013, IBM DB2 was 30 years old and was released in DB2 10.5. One of the most eye-catching features was the BLU accelerator, which introduced columnar storage technology into traditional databases, currently, BLU only supports databases of DB2

This DB2 script is very good. When exporting data, you just need to add the table name. In fact, you can refer to the same method for import or load data: #! /Usr/bin/sh Db2 connect to webList ="DB2INST1. ACCESS_IDDB2INST1. ACCESS_ID_HISTDB2INST1.

1. The Oracle 10g rac server is configured with 128G memory, and the sga pga is very large. After restart, it is found that ipcs show sga is correct, that is, free-m is incorrect, and the difference is very long. 2. You can configure hugepage, but

Redis is very easy to use, but it is still troublesome for people who are used to relational databases. Especially for a hash key, they want to obtain all the feild domains, there is no direct interface officially, but it can be implemented through

MongoDB has been widely used as a NoSQL Database in recent years. More and more enterprises are trying to use MongoDB instead of the original Database. MongoDB also performs well in clusters, sharding, and replication. I will introduce various

Go to non-CDB Database View the location of the data file [Oracle @ shuang ~] $ Sqlplus/as sysdba SQL * Plus: Release 12.1.0.1.0 Production on Wed Feb 26 13:17:45 2014 Copyright (c) 1982,201 3, Oracle. All rights reserved. Connected to an idle

Mongodb does not recommend master-slave replication. We recommend that you create a Replica Set to ensure that one service is down. If there are other services on top, the program runs normally and the data of several services is the same, automatic

+++ 10gR2If the host name is modified and the corresponding information of/etc/hosts is not changed, an error will be reported during database shutdown and startup. [Oracle @ oracle ~] $ Sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on

Oracle has been started. After connecting to sqlplus, perform the query. the following error occurs: A ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directorySQL> shutdown

I. Here we mainly use the Oracle-validated package to simplify some configurations for installing the oracle software.2. Install the oracle database software 10.2.0.1.0. 3. Upgrade the oracle database software 10.2.0.2.0. Recommended reading:Install

Problem description: It takes 12 minutes for Oracle to delete 2000 records by using the primary key id. Solution Process: 1. First, check the SQL Execution Plan. The execution plan is normal, and the cost is only 4. The primary key index is used. 2.

Diagnose and resolve ORA-04031 errors When we try to allocate large blocks of continuous memory in the Shared Pool, Oracle first clears all the objects currently not used in the pool to merge idle memory blocks. A ORA-04031 error occurs if the

Generally, no one modifies the dbid and dbname of Oracle unless in special cases, such as database cloning.Steps: 1. back up the database 2. start data to mount status 3. nid command modification (if you only modify the dbid, you do not need the

Database locking Contention is a common problem in practice. Serious Contention may cause overall database performance degradation, or even connection failure. In actual production, Contention is usually an urgent situation. It is a challenge for O &