Database Administrator

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

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_

I. Functions of redo log files: 1. Record all data changes 2. Provide a recovery mechanism 3. group-based Management (there are at least two groups. The default value is 3. Each group has one redo log file. Oracle officially recommends that the size

Step 1:Create two directories C: \ mwagui \ lib and C: \ mwagui \ log, and download patch: 4205328 (Mobile Wireless Applications (MWA) j2-telnet GUI Client 11.5.10) to C: \ mwagui \ lib.(Patch: 4205328 has a zip file containing the java

Paste a configuration example using cassandra 1. Configure the jdk1.6 and later environments.Check the java version after installation. It must be java version "1.6.0 _ 24" or later. Otherwise, an error similar to out of memory will be reported

There is an SQL statement, similar to the following: Select..., createdate from A left join B on... where... The createdate field exists in both table A and table B. The local Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 runs normally,

In the Oracle database, we can use oracle internal events to adjust the SCN. There are two common methods to improve SCN: 1. alter session set events 'immediate trace name ADJUST_SCN level x ';-- Database OPEN is required 2. Event 10015Alter session

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

Differences between recover and restore in Oracle rman: Restore just copy the physical file, recover will consistent the database. Restore is a file-level restoration. Physical file restoration.A recover is a data-level recovery. Logical recovery,

Recently I encountered the problem of "TNS-12535: TNS: Operation timeout. 1. First, check whether the server has enabled the firewall. The firewall blocks connections.Linux Firewall shutdown command: service iptables stop or chkconfig iptables off2.

1. view the maximum number of Oracle connectionsSQL> show parameter processes # maximum number of connections 2. Modify the maximum number of connectionsSQL> alter system set processes = value scope = spfile # value indicates the number of

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

Recently to http://forge.mysql.com/worklog/task.php? The binlog pre-allocation mentioned in id = 4925 is implemented based on percoan5.5.18. In worklog, the tps is increased by 10 times when sync_binlog = 1. It is indeed possible that no group

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 () ......

Triplicate Select mbid00, mbmc00, llurl0, cfwz00, mbsltp, sycs00, lrsj00 from (Select mbid00, mbmc00, llurl0, cfwz00, mbsltp, sycs00, lrsj00, rownum as con from (Select * from JZ_MBXXB0 where 1 = 1 and lbid00 ='123'Order by lrsj00)Where rownum 10)

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

I am a man-level character in Oracle, so I have encountered many problems. In the last few days, oracle data queries have encountered a strange phenomenon. A database is running on a different computer and in the same environment when pl/SQL is

Oracle ref Dynamic Cursor: Create or replace procedure pro_cursor_type_V AsT_tmp table3 % rowtype;Type c_type is ref cursor;Cur c_type;V_taname varchar2 (100 );BeginV_taname: = 'a ';Open cur for 'select * from table3 where taname =: a order by taid