Database Administrator

Differences between user, user account, and schema A user isa person who connects to a user account by establishing a session against theinstance and log on with the user account name A schemais a set of objects owned by a user account. User Account

Oracle efficient paging storage process: Create Or ReplacePackage JT_P_pageIs Type type_curIsRefCursor;-- Defines the cursor variable used to return the record set ProcedurePagination (PindexInNumber,-- Index of the number of pages to be

From mysql 5.5, mysql source code installation began to use cmake, and compilation and installation were a little different from previous versions. 1. installation steps: 1. Preparations before installation A. Download the mysql Source Code package.

MongoDB provides the Replica pairs mode to start the database. After the database is started in this mode, the database automatically negotiates who is the master and who is the slave. Once a database server loses power, the other server

1. Run the TOPAS command in the AIX system. It is found that the cpu in the user is too high, and the Oracle process CPU is relatively high. For example, the highest process pid in Oracle is 1138782, accounting for 27% of the CPU. 2. Identify sid

1. symptom The database instance cannot respond to client-initiated requests. 2. Type -Oracle processes are waiting for a resource or event -Oracle Process Spins: Spin refers to a loop in which the code in the Oracle Process is executed. In the v $

1. Overview Oracle introduces Redo log for data recovery Related Oracle processes: redo the log write process (LGWR) Related data dictionaries v $ log, v $ logfile Author permission: sys, system permission 2. View redo log information View redo log

PO --> supply source --> approved supplier list Find the supplier corresponding to the material "105010000056"-> click "properties" to enter the "supplier material properties" form, When "inventory" is set, "supplier delegate" cannot be selected,

Oracle's RMAN configuration information is stored in the control file of the target database by default. Of course, you can configure a recovery catalog server to store this information. The following is a comparison between the control file and

We have already installed Ubuntu 11.04. We found that apt-get can only install MySQL 5.1. If you want to use MySQL 5.5, you can only compile it by yourself.The compilation and installation process records are as follows: 1. Go to mysql.com to

Use the cursor and temporary table in the MySQL stored procedure: BEGIN DECLAREC_egidINTEGER; DECLAREDoneINT DEFAULT0; DECLAREMy_testCursorCURSOR FOR (SELECTCp. tb_electricGroup_idFROMTb_chargingPoleASCpWHERECp. tb_chargeStation_id = 12 );

1. query and modify the undo_retention parameter: Run the show parameter undo command to view the current database parameter undo_retention settings. Shown as follows: Undo_management string AUTOUndo_retention integer 10800Undo_suppress_errors

DataGuardAbbreviationDGIs a database-levelHAThe main functions of the solution are redundancy, data protection, and fault recovery,DGProduction database"Transaction consistencyCopy ",Use the physicalCopyAfter the slave database is created, the

Today, at the customer's request, the password for creating a user must be the same as that for the source database. However, I found that the source database password is 123456, which is very simple and starts with a number. This Oracle is not

1. TRUNC Function 1. TRUNC (for dates) The date value intercepted by the TRUNC function for the specified element.The syntax format is as follows:TRUNC (date [, fmt])Where:Date: A date value.Fmt date format, which is truncated by the specified

To increase the query speed, generally: 1.Create a primary key for fields that do not need to be deleted; create an index for fields that may be deleted. 2. If you submit 5 million numbers at a time, each of them must be compared with the 90 million

The role of undo tablespace and redo log files in Oracle is very important. This article focuses on the role and features of undo rollback segments, and briefly introduces the differences between undo and redo and their respective roles: 1. Features

[Root @ rac1 ~] #/Etc/init. d/Oracleasm configureProcessing the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM libraryDriver. The following questions will determine whether the driver isLoaded on boot and

The database instance is disabled.Startup nomount database instance starts to the First Stage (Steps:1. Search for the parameter file spfile . ora. If no, search for spfile. ora. If no, find init . ora.2. Allocate SGA3. Start the background process4.

(1) multiple databases can be configured in Oracle, and only one listener can be enabled. You only need to configure the corresponding service name (for example) for multiple databases to connect. Note the following points:1. generally, if multiple