dba

oracle| Data | database first, some concepts of relational databases 　　 1, the value of the primary key can not be changed generally 　　 2. Foreign key: A field that points to another table or to the primary key or unique key of this table. The

Master Eygle's seven tips for DBAs What is the job responsibility of the DBA? What should the DBA do every day? How can a DBA in a stable environment grow and work? This is a question that a lot of people have raised, I scribble, the arbitrary

Oracle "Recycle Bin" in Oracle 10G by fenng Http://www.DBAnotes.net In Oracle 10G, the concept of a Recycle Bin (recycle Bin) is introduced. The Recycle Bin, in principle, is a data dictionary table, where the user drops the database object

Oracleenterprisemanager (Oracle Enterprise Manager, abbreviation OEM) provides management services for managing distributed environments through a set of Oracle programs. OEMs include a set of DBA tools, a repository, and a graphical display of the

Help is not in sqlplus after the manual build, and the following records how to install and delete the help command in Sqlplus. Note: The Sqlplus help command is available only when the database is open. Non-open state use help also error: Sp2-0171:

1, Application development (application Development) Sql*plus E:\Oracle\Ora81\BIN\SQLPLUSW. Exe 2. Database management (DB administration) DB Configuration Assistant Database Configuration Assistant: Creating, configuring, and deleting Databases DBA

No database system can avoid a crash situation, even if you use clustered, dual-machine hot standby and so on, still can not completely eliminate the single point of failure in the system, not to mention for the majority of users, cannot afford such

Oracle Installing Oracle 10g on RHEL as 3 step-by-step--Reprint Author: fenng Installing Oracle 10g on Red Hat Enterprise Linux Advanced Server 3 (RHEL 3) V 0.21 Oracle's 10g database and Oracle RAC have created a new world in the Tpc-h benchmark

Just passed OCP last exam, from the training to review and complete the exam for a total of one months, the whole process is very compact also very nervous, very lucky or passed the exam, also not in vain this month's hard. First is the training,

The use of bbed requires attention: 1, win under Oracle does not provide 2, with Oracle software release 3, Unix/linux under the use of the need for prior relink 4, Oracle initially used bbed to repair bad block, starting from 9i can be

Oracle recently in the toss hp-ux11.11, I will be the Oracle 8I in HP-UX installation and configuration process written out, I hope to share with you, if you can help, Diao greedy feel gratified. If you have any questions or your experiences and

Oracle subject:qref:blockdump-8.x Data Segment Header in Oracle creation date:25-apr-2000 CACHE block:see note:47132.1 type : 0x10=data SEGMENT header-unlimitedextent control:extent HEADER:: spare1:0 space2:0 #extents: #blocks: 1429 Last Map 0x000000

Oracle 11g on July 11, 2007 11 O'Clock (Beijing time 11th 22 o'clock) officially released, 11g is Oracle 30 years to release the most important version of the database, according to the needs of users to achieve information lifecycle management

The reason why I want to write an article today is that MySQL5.1 's release brings a powerful weapon to design a super power database, and any MySQL DBA should learn and use it as soon as possible. I think that if you can use the new features of

MySQL Storage engine MyISAM 1, create MyISAM table Mysql> CREATE TABLE t (ID int, name varchar (), msg varchar ()) engine = MyISAM; Mysql> Show Table status like "T" \g; 1. Row

Oracle's official documents are large and often without focus, making Oracle novices look laborious. However, there are still many Oracle users who believe that any Oracle learning materials are not as authoritative and concise as Oracle's official

Oracle Install Oracle 9i/10g on RHEL as 3 Author: ern (yaoyongping@gmail.com) This article describes the steps and knowledge necessary to install Oracle 9i/10g on red Hat Enterprise Linux Advanced Server 3 (RHEL as 3). A lot of related articles,

The DBA sees an example as follows: Dba_data_files Information about the database file Dba_db_links All database links in the database Dba_extents Include all partitions in the database Dba_free_space Free partitions in all table spaces Dba_

Error Fenng (Fenng@itpub.net) Copyright NOTICE: Reprint Please indicate the author and the source Objective Every DBA will inevitably encounter a variety of errors (ORA-XXXX) in the process of database management. Some of the errors have been

Solve Problem Description: In the afternoon, the site said that the product library was terminated unexpectedly, followed by the possibility that the array was damaged because the lights were not lit. So the emergency dial to the remote, check the