Database Administrator

Define data tablesAssume that a computer manufacturer stores the product information of the whole machine and accessories in its database. The table used to save the product information of the entire machine is called Pc; the table used to save the

Oracle's system is too huge. For Beginners, it is inevitable that they will not start to feel like they want to learn anything, and the results will not be good. So share their learning experience, we hope that the beginners will have a general

Installing and configuring PostgreSQL in Ubuntu is relatively simple, but you need to pay attention to some details. The installation steps are as follows: You need to pay special attention.1-$ sudo apt-get install postgresql-8.1 # Apt-get install

When debugging our test server, Oracle on the machine is always unable to start. After debugging, the problem is finally solved.When the command line in linux starts oracle, the TNS error is reported: the net service name is not incorrectly ......,

An example of how to solve MySQL startup failure in Linux: When you press the mysql commandCan't connect to local MySQL server through socket '/var/lib/mysql. sock' When you press the service mysqld start command, or/etc/init. d/mysqld start Timeout

I want to develop a database on the Ubuntu7.10 platform. I saw on the Ubuntu Forum that mysql installation was quite simple, so I chose mysql. I did not expect that I had spent two days on this simple problem. It seems that the simplicity of things

Manage password security and parameters in the resource profile (configuration file) configuration file 1. Resource Restriction Parameters Session-level resource restrictions   Invocation-level resource restrictions   2. password management

Today again encountered ORA-01033: Oracle initialization or shutdown in progress this oracle service initialization error, generally I will first listen to the file to see if the host name has let me change, the port number has changed. The result

Use of instance update for Oracle Stored Procedure usage Body section -- Update changes Procedure proc_sy_syjs_updateChangeItem (fcoursecode in Rule XT. sy_syjs_proitem.fcoursecode % type,Fcoursename in Rule XT. sy_syjs_proitem.fcoursename %

MySQL 5.5 series has become a stable version for some time, but according to my survey, it is still dominated by the 5.1 series in the production environment. In large Chinese companies, it is only determined that Jinshan is using 5.5.I have been

There is no problem in running Oracle 10g environment, as shown below: For c in (SELECT * from table (pkg_1__common.f_split (P_IN_IDS _, ',') LOOP.... Omitted hereEnd loop; However, in Oracle 9i execution, the ORA-22905: cannot access rows from a

Today, the customer wants to use Oracle 9.2.0.5, which is no longer supported by aix 6.1, so he has to copy the software from other databases and recompile it. However, you can only create a database manually. I haven't used manual database creation

Today, we found that the exported tables from Oracle 11gR2 Exp are incomplete, and some non-recorded tables are not exported. I checked it online and said it was caused by the new Deferred Segment Creation of Oracle 11g R2. Check the user_tables

Description of statistics in AUTOTRACE: RECURSIVE cballs: RECURSIVE readTo ensure the smooth execution of SQL statements sent by users, Oracle must execute some additional statements. These statements are called recursive reads.For example, if you

We all know that each archivelog information is recorded in controlfile. Of course, after deleting these physical files under OS, the archivelog information is still recorded in our controlfile, the Oracle OEM manager displays visualized logs. After

I saw the rlwrap tool on the Forum. It feels good. I will make a summary. (Rlwrap download) In Windows, when running SQL * Plus in the doscommand window, you can use the up and down keys to skip the previously executed SQL statements. you can modify

Oracle index access method This article records some Oracle index access operations For more information about table access, see: For the stored procedure of displaying the execution plan, see (1) INDEX UNIQUE SCAN A unique index scan means a single

(I) download and decompress RDA: RDA download Free in http://linux.bkjia.com/ The username and password are both www.bkjia.com The specific download directory is in/July 6,/July 23,/Oracle inspection tool: RDA usage Overview [Oracle @ localhost

The V $ view contains information about the data structure maintained by the kernel in the memory, which can be accessed through a DBA account with the SYS permission. The following is a summary of the recovery-related views: Articles: Oracle

The redo log describes all changes to the data block. This section describes the operations performed when a database is opened and logs are written. Articles: Oracle recovery Internal principles http://www.bkjia.com/search.aspx? Where = nkey &