-
编辑 删除
RAM Memory and the Swap Disk
Now that we know the amount of RAM on our server, we are ready to investigate the RAM and swap disk usage for the Oracle server. Whenever the memory demands of the server exceed that amount of ...
-
编辑 删除
see how much RAM exists on your server
Display RAM Size on HP/UXIn HP/UX, the dmesg command can display memory information:L 5-12dmesgMemory Information:physical page size = 4096 bytes, logical page size = 4096 bytesPhysical: 5242880 K...
-
编辑 删除
转：在AIX 5L中，怎么创建没有头部偏移的LV（for Oracle datafile）
在Oracle 9iR2以前，在IBM AIX上使用lv raw（裸设备）作为Oracle数据文件的话，lv头部是存在一个4k的lv管理区的。正因为这个4k的lv头部，会导致8k以及8k以上的Oracle block（Oracle块）在使用这样的lv的时候，或者是...
-
编辑 删除
10g wait event: read by other session
查了下官方文档：read by other sessionThis event occurs when a session requests a buffer that is currently being read into the buffer cache by another session. Prior to release 10.1, waits for this e...
-
编辑 删除
bbed实验四 file header reset
noarchivelog模式，从backupset中恢复了一个文件，现在库打不开SQL> alter database open;alter database open*ERROR at line 1:ORA-01113: file 4 needs media recoveryORA-01110: data file 4: '/dev/rzz_01_lv'...
-
编辑 删除
bbed实验二 recovering deleted row
首先看表里的数据SQL> select * from test; A B---------- ---------- 1 ysatnaf &nb...
-
编辑 删除
bbed实验三 corrupted块恢复
HHL-690-1:/oracle/bbed$bbed parfile=par.bbdPassword: BBED: Release 2.0.0.0.0 - Limited Production on Fri Apr 3 23:50:12 2009Copyright (c) 1982, 2007, Oracle. All rights reserved.*************...
-
编辑 删除
bbed实验一 changing data
建立测试表SQL> create table test(a number(10),b varchar2(100));Table created.SQL> insert into test values(1,'fantasy');1 row created.SQL> insert into test values(2,'daily');1 row created.SQL> in...
-
编辑 删除
DB Block Gets & Consistent Gets.
DB Block Gets. Number of times a CURRENT block was requested. Current mode blocks are retrieved as they exist right now, not in a consistent read fashion. Normally, blocks retrieved for a query are re...
-
编辑 删除
SCN的Broadcast-On-Commit和Lamport算法
这几天我有一个客户的数据库出现了这样的情况，在一个3节点的RAC上，其中一个节点上修改的数据，马上在另外一个节点上查，发现有千分之5左右的数据没有更新，要过一会才能查到正确的结果。这造成了应用软件的业务逻...
-
编辑 删除
parallel opration & Distributed Transaction Restrictions
Distributed Transaction RestrictionsA DML operation cannot be parallelized if it is in a distributed transaction or if the DML or the query operation is against a remote object.Examples of Distribut...
-
编辑 删除
parallel dml & referential integrity constraints
lists all of the parallel operations that are possible on tables that are involved in referential integrity constraints. Table 21-1 Referential Integrity Restrictions DML StatementIssu...
-
编辑 删除
Restrictions on parallel DML
parallel DML (including direct-path INSERT):Intra-partition parallelism for UPDATE, MERGE, and DELETE operations require that the COMPATIBLE initialization parameter be set to 9.2 or greater. INSER...
-
编辑 删除
Space Management for Parallel DDL
When creating a table or index in parallel, each parallel execution server uses the values in the STORAGE clause of the CREATE statement to create temporary segments to store the rows. Therefore, a ta...
-
编辑 删除
local extent management tablespace分配方式
dump segment header Map Header:: next 0x00000000 #extents: 23 obj#: 69335 flag: 0x10000000 Inc # 0 Extent Map ----------------...
-
编辑 删除
aix检查参数设置
利用lsattr -Elsys0 检查maxuproc, minpout, maxpout等参数的大小。maxuproc为每个用户的最大进程数,通常如果系统运行DB2或ORACLE是应将maxuproc调整，Default：128、调整到500，maxuproc增加可...
-
编辑 删除
Oracle Automatic Shared Memory Management
Note: There is an advisory on using bitmap free lists (ASMM). ASMM (AMM) and dynamic memory management has measurable overhead for resize operations, and some shop may want to disabl...
-
编辑 删除
Creating an Oracle Database
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#i1008816 Specifying the Shared Pool SizeThe SHARED_POOL_SIZE initialization parameter is a dynamic parameter t...
-
编辑 删除
动态SQL中hint是否失效
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProdPL/SQL Release 10.2.0.3.0 - ProductionCORE 10.2.0.3.0 ProductionTNS for 32-bit Windows: ...
-
编辑 删除
latch (Understanding the spin statistics)
The latch statistics in the V$LATCH family of views record a get whenever aprocess acquires a latch in willing-to-wait mode. If the process fails to get thelatch without spinning, a miss is recorded. ...
