Database Administrator

Steps for building a physical standby database on the same machine Lab environment: LInux EnvironmentORacle 11.2.0.1 Master Database: orcl Slave Database: stby 1 CheckSupervisionStart listening? 2. Configure the initialization parameter file for the

You can view the current configuration through dba_hist_wr_control. The current awr is a data snapshot every hour, and the retention time is 7 days. SYS @ peng SQL> select * from dba_hist_wr_control;     DBID SNAP_INTERVAL             RETENTION      

This problem occurs during programming in C. Generally, the time format is incorrect. The time format generally uses a STRING object when saving variables, However, when you use an SQL statement to input a database, you need to convert the STRING

(1) Update the Ubuntu 10.04 LTS system to the latest version and install the following package: Sudo apt-get install alien binutils gcc ia32-libs lesstif2 lesstif2-dev lib32stdc + + 6 lib32z1 libaio1 libc6 libc6-dev libc6-dev-i386 libc6-i386

DBMS_Job package usageIt contains the following sub-processes:Broken () process.Change () process.Interval () process.Isubmit () process.Next_Date () process.Remove () process.Run () process.Submit () process.User_Export () process.What () process.1,

An instance corresponds to an SGA, which can occupy 80% of the physical memory.Shared poolDatabase buffer cacheRedo log bufferOther structures Run the show sga command to view the SGA SGA basic unit: granules (10 M. 16 M) Select componet, If one

After installing a series of software development programs under Ubuntu 10.10 in the early stage, we have installed the final database MySQL 5.1.56. Basically, the environment for building the LNMJ or LAMJ Architecture Based on Java Web applications

Xwindow must be enabled for Oracle 10g installation in Linux. The installation interface is very ugly!The patch and Installer are generally large and daunting for the first time. Record the startup process: Su oracleExport ORACLE_BASE

Install MySQL 5.5.10 for LinuxOperating System: CentOS 5.5MySQL: 5.5.10 Use the yum Command provided by CentOS Linux to install and upgrade the required libraries (RedHat and other Linux distributions can find the RPM packages of these libraries

// Construct a table that is the same as a known table. The common methods are as follows:// Create table t_name// Select col_name from t_exists// Where 1 = 0;// This construction method reduces our workload and brings great convenience;// But do

Create or replace procedure proc_query_prior_departmentIs Cursor department_list_nosub isSelect dep. id, dep. name, dep. parent from department dep where org_id = 7;Union_mc varchar2 (200 ); Begin Delete from ma_department_role;Commit;For varDep in

Method 1:SELECT 'create SEQUENCE '| SEQUENCE_NAME | 'crement BY' |INCREMENT_BY | 'start with' | LAST_NUMBER | 'maxvalue' |MAX_VALUE | 'cache' | CACHE_SIZE | 'order NOCYCLE ;'FROM user_SEQUENCES;The result is similar:Create sequence ARTCOMMENT_SEQ

Since the Oracle course design involves image processing, it took a long time to test and read a lot of information, and finally solved the problem. Here we will share with you: 1. Save images to the database In oracle, the image storage type is

Insert a data entry in Oracle and return the id of the data entry: /*Create or replace procedure worktask_content_Insert(Theme varchar2,Type varchar2,Status varchar2,Source varchar2,Content varchar2,Slave varchar2,Progress

I am not quite familiar with the related RAC structure. Now let's see what it means. Oracle clusterware has the following main components:CSS: Cluster Synchronization ServiceIt mainly manages the situation between nodes in the entire cluster,

(1) Check the AIX packages required by Oracle10g according to the installation instructions: Bos. adt. base Bos. adt. lib Bos. adt. libm Bos. perf. libperfstat Bos. perf. perfstat Bos. perf. proctools XlC. aix50.rte: 7.0.0.4 or later XlC. rte: 7.0.0.

Select f. TABLESPACE_NAME,(T. TOTAL_SPACE-F. FREE_SPACE) "USED (MB )",F. FREE_SPACE "FREE (MB )",T. TOTAL_SPACE "TOTAL (MB )",(ROUND (F. FREE_SPACE/T. TOTAL_SPACE) * 100) | '%' PER_FREEFROM (SELECT TABLESPACE_NAME,ROUND (SUM (BLOCKS *(Select value/1,

Recently, an Oracle 10 Gb database was installed. When dbca created the database, the character set was not selected or the database was incorrectly selected. After the data was imported, all Chinese characters were garbled (funny, chinese garbled

After Oracle 10.2.0.1 is upgraded to 10.2.0.4, an error occurs in the EM console. This is because the authorization of the enterprise manager database control component and the CA certificate has expired. The official solution is to apply Patch 83502

There is still a rollback segment in Oracle10g named system, which was created by Oracle when the database was created, and the rollback segment exists in the SYSTEM tablespace. It is used to roll back system events. That is to say, the modified