Database Administrator

The Oracle storage outline is used to provide stable execution plans. Starting from oracle 11g, it is gradually replaced by the SQL plan. The following describes the specific process of the storage outline. The results are tested in oracle 11g r2.--

Scenario 1:[Oracle @ www.bkjia.com ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.1.0 Production on Tue Jun 26 20:52:47 2012Copyright (c) 1982,200 9, Oracle. All rights reserved. Connected:Oracle Database 11g Enterprise Edition Release

Take utf8 as an example. Assume that you have installed MySQL in Ubuntu (SEE) and the installation is successful. 1. Stop mysql Sudo/etc/init. d/mysql. server stop 2. modify my. cnf Sudo gedit/etc/my. cnf Find the corresponding part and add the

First, I have a general understanding of the Oracle architecture. Oracle architecture, I think, can be divided into: memory structure, process structure and storage structure. The process structure serves as a bridge between the memory structure and

One node of a core library went down last night, and then reboot, The following information is found in alert: Thu Jul 5 03:03:50 2012 Errors in file/u01/Oracle/app/oracle/admin/crm/bdump/crm1_dbw9_142.16.trc: ORA-07445: exception encountered:

Deploy the Rman backup plan and find the error message in alert. log after execution:Fri Jul 6 00:30:16 2012Errors in file/Oracle/admin/live/udump/***** _ ora_3652.trc:Fri Jul 6 00:30:16 2012Errors in file/oracle/admin/live/udump/***** _

When we sign the contract with the boss, there is a very important parameter: fast_start_mttr_target 1 fast_start_mttr_target: The target for quickly starting the average fault recovery time. Unit: s. The default value is 0 (disabled ). 2 fast_start_

The following error occurs when importing impdp data: ErrorsInFile/Oracle/app/diag/rdbms/gavin/Gavin/trace/Gavin_arc0_5889.trc: ORA-19809: exceeds the limit on the number of recovery files ORA-19804: unable to reclaim 49837568 bytes of disk

1 create or replace procedure stored PROCEDURE name2 IS3 BEGIN4 NULL;5 END;　　Row 1:Create or replace procedure is an SQL statement that notifies the Oracle database to CREATE a stored PROCEDURE called skeleton, and overwrites it if it exists;Row

Learning Objectives 1. Describe the logical structure of the Oracle database2. Create a tablespace3. Change the tablespace size4. Allocate space for temporary segments5. Change the tablespace status6. Change the storage settings of the

Recently encountered a problem in the project, and the current affairs of updating expired data were not rolled back. The transaction configuration was carefully checked before and after, and the problem was not found. Finally, after one-step

When performing a multi-table joint query, if we view its execution plan, we will find a connection method between multiple tables. I was planningSqlplusThe execution plan is used, but the format looks

1. Introduction Use synonyms to access the same object: (1) convenient access to other user objects (2) Shorten the Object Name Length 2. Create a synonym SQL> create synonym syn_emp for scott. emp; You have created a synonym. 3. Delete

I received a call from my colleague at home, saying that the database could not be connected. The following error was reported during connection: ORA-12516: TNS: The Listener cannot find the available handler that meets the protocol stack

Date contains the year, month, and date.Time contains hours, minutes, and seconds.Timestamp includes year, month, day, hour, minute, second, And 1‰ seconds. SQLite contains the following time/date functions:Datetime ()...Date () ......Time () ......

Oracle job is a function provided by oracle to regularly execute a stored procedure or package. Main scenariosPerform related operations on the background at regular intervals. For example, save the data of one table to another at every night, and 2.

HWM in Oracle) Find a table with a large number of records, for example, test1. Create table test2 as select * from test1 where 1 = 2; Insert into test2 select * from test1; The session is forcibly interrupted before the insert operation is

Recently, when I was working on a project, I encountered a problem. During the select Operation on the Oracle 11g database of Windows 2003 system, the result was "dependent on ", at that time, the O & M personnel did not know much about oracle, So

1. rollback and Revocation Refer: In-depth Oracle parsing by eygle (1) In order to ensure read consistency among multiple users and to roll back transactions, oracle provides the old values before the modification for the modified data. (2)

Typical Oracle recursive algorithms are used. For example, under a multi-level department, a sub-department cannot be the parent department of the parent department. For example, the father department has a son department and B son department. The