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

A dimension statistics statement in the backgroundSELECT products_id, sku, px_id, sj_id, cat_path, COUNT (*) AS pv, COUNT (DISTINCT ip) AS ip_numbers, SUM (is_bounce) AS bounce_numbers, SUM (remain_time) AS remain_timeFROM dm_pv_records_searchWHERE 1

Overview of dynamic sampling Dynamic Sampling was initially proposed in Oracle 9i R2, where segments (tables, indexes, partitions) are not analyzed, A technique invented to enable the CBO optimizer to obtain sufficient information to ensure a

I. Data Backup Methods MySQL parameter description: MySQL management-data backup and recovery 1. Physical backup 1.1 Cold Standby cp tar and so on 1.2 Hot Standby mysqlhotcopy can only back up tables whose storage engine is myisam and rely on

1. experiment environment ConfigurationThis experiment is carried out in the vmware9.0 environment, the installation of the operating system CentOS-6.4-x86_64, database version is Oracle10g10.2.0.1, the source database and the target database are

If the default Kernel Parameter of the Solaris system is used, the Out of memory error occurs during database creation. In versions earlier than Solaris 10, system parameters were set in/etc/system. This method is not used in Solaris 10/OpenSolaris. 

ORA-14300: partition keywords map to partitions that exceed the maximum number of partitions allowed Environment: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production The object table is an automatic partition table by day:

The following error occurs when you use Hibernate to save data to an Oracle database: 19:52:35, 156 WARN JDBCExceptionReporter: 100-SQL Error: 1461, SQLState: 7200019:52:35, 156 ERROR JDBCExceptionReporter: 101-ORA-01461: Can only bind the LONG

1. MyISAM does not support transactions. InnoDB is a storage engine for transaction types. When transaction support is required for our tables, MyISAM cannot be selected. 2. MyISAM only supports table-level locks. BDB supports page-level locks and

Compile a doscommand script to generate a batch command file, and then add a scheduled task to the host server. Backup method: Create a bak folder in the root directory of any disk, create week0.dmp In the bak folder, copy the following DOS command

Exp/Imp is a commonly used logical backup method.   Use of Exp/Imp tools 1. data transmission between two databases. Different database versions and operating systems are supported. 2. database backup and recovery 3. transfer data from one database

It is found that there are many problems if the character is poor and the fstab is written incorrectly at night. As a result, the system cannot get up. Because the fault was not handled at the time, I found several images online, general

Oracle clears table data during storage 1. Specify the table name for data clearing Create or replace procedure storage nameAsBeginExecute immediate 'truncate table name ';Execute immediate 'truncate table name ';Commit;End; 2. The following is the

In the first quarter of 2014, the PSU update mainly includes three versions: 12.1, 11.2.0.4, 11.2.0.3, and 11.1.0.7. In the 2nd quarter, Oracle will release version 12.1.0.2, and version 11.2.0.4 will also be the ultimate version of version 11.2,

Today, I used PL/SQL to connect to the server without any response. I can log on to the server and connect to sqlplus directly. Then I found that the lsnrctl status is always connect. Try shutdown immediate and stop there. You can only use shutdown

Archive logs are stored in the following ways: I. ASM Method If the operating systems of Oracle 10G, oracle11g, and oracle 12C are AIX, HPUX, and Linux, the ASM database creation method is generally adopted, especially for oracle 11g and oracle12C,

Restoration of Oracle online redo log loss (1) Loss of members of the inactive online redo log file If the database has not been closed and the member of the active redo log group or the current redo log group is lost, use alter database checkpoint

1. restore refers to accessing the previously generated backup set, obtaining one or more objects, and then restoring these objects at a location on the disk.Recovery is an actual process that allows a database to be opened at a given time point,

In actual development, connect by can replace the cyclical code in plsql or java to improve development efficiency. The following is a problem I encountered during my work Usage of Oracle CONNECT Oracle recursive start with... connect by prior

In the Data Guard environment, Standby Redo Log is a special Log type. We recommend that you configure the Standby Redo Log on the Primary and Standby ports from the latest DG Installation Guide. To put it simply, Standby Redo Log is the online Redo