Database Administrator

The CR blocks created:  Oracle metric is the number of CURRENT blocks cloned to create CR (consistent read) blocks. The most common reason for cloning is that the buffer is held in an incompatible mode.   Read consistency is used when competing

SQL> select * from v $ version where rownum BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production Create index I _test_owner on test (owner ); SQL>

Background: Because the Linux server used for development is in a relatively closed environment, only port 22 is accessed through SSH. Therefore, putty is used to create an SSH forwarding, which maps the port 27018 of the local machine to the remote

Many problems occurred when installing RAC. The summary is as follows: 1. During installation, ohasd cannot be started because root. sh is running at the same time at two nodes and an error occurs. Then delete and reinstall the disk. The previously

In the RAC environment, Oracle uses GRD (Global Resource Service) to record the Resource information of each RAC node. The Resource information of each RAC node is recorded by using GCS (Global Cache Service) and GES (Global Enqueue Service) these

The Administrator cannot delete the DB Link created by other users (for example, emcd ): (1) you can log on to the database as an administrator, query dba_users, and write down the values of the user's emcd password: SQL> select username, password

Test Code: DECLARE BEGIN -- Most normal way to handle exception. DECLARE Except_test0 EXCEPTION; BEGIN RAISE effect_test0; EXCEPTION WHEN effect_test0 THEN Dbms_output.put_line ('Test0 effect_test0: SQLCODE ='| SQLCODE | ', SQLERRM ='

Obtaining execution plans and execution costs and writing the optimal SQL statements are required by each Oracle Developer and dba. After Oracle 11g is passed, auto trace is automatically enabled for dba role by default? Configure autotrace: Enter $

The summary in this document is very comprehensive, but I have made some corrections to some of the errors (such as fal_server and fal_client instructions) or some ambiguous descriptions. to differentiate the network connection string and SID, list

ORA-26663 for removing process Errors When configuring Streams:SQL> exec dbms_apply_adm.drop_apply ('target _ APPLY_STREAM ');BEGIN dbms_apply_adm.drop_apply ('target _ APPLY_STREAM '); END; *ERROR at line 1:ORA-26663: error queue for apply process

Exec dbms_job.broken (23, false );Commit; Select t. *, t. rowid from dba_jobs t; Select t. *, t. rowid from sys. user_jobs t; Select job, last_date, next_date, broken, interval, failuresFrom user_jobs; When a job returns an error, Oracle tries

Description:Originally, one-way transmission of Streams was directly configured on two database servers,The original source database is two clusters of 64-bit HP-UNIX Oracle11gR2 database,The original target database is a 64-bit Linux Oracle11gR2

I installed it on RHEL6 32-bit. Use the gnome gui to install all the Development kits in Development Tools, or quickly install them and build a local yum source and then use the group for installation. It is worth noting that swap requires at least 3

The following is an article about SQL Injection found on the Internet. Recently, the project involved the prevention of SQL injection. However, because PYTHON and MYSQL are used, some of the ready-made methods provided in JAVA code cannot be used,

The lock mechanism is used to manage concurrent access to shared resources. In Oracle, the transaction should be committed at the appropriate time, because the transaction is very long or very large, generally there is no pressure on the system; row-

After the database server is set up, the first thing we need to do is not to consider which MySQL-initiated programs should be run on the server that supports the database, but when the database is damaged, how to safely restore to the last normal

1. Introduction to PDM The Physical Data Model (Physical Data Model) PDM provides the basic elements required for the initial design of the system and the relationship between related elements; the physical design stage of the database must be

Oracle Enterprise Manager 10 Gb Database Control is designed to manage a single Database, regardless of whether the Database is a single instance or a cluster Database. This Enterprise Manager 10g Database Control release contains the following

When writing HQL, subqueries can be used except in the where condition. subquery statements are not allowed in other places, such as select and from. If subqueries are to be written after select, you can use the formula attribute to write data. If

When doing GIS engineering, we often use the most famous software in the GIS field of ARCGIS, and the most common file type of ARCGIS is shpfiles, which has three formats of file composition: shp, shx, and dbf. At the same time, the GIS project