- 博客(38)
- 资源 (13)
- 收藏
- 关注
翻译 Undo Tablespaces【每日一译】--2012-10-31
Undo tablespaces are special tablespaces used solely for storing undo information.You cannot create any other segment types (for example, tables or indexes) in undotablespaces. Each database conta
2012-10-31 08:33:35 591
翻译 The SYSTEM Tablespace The SYSAUX Tablespace【每日一译】--2012-10-30
Every Oracle database contains a tablespace named SYSTEM, which Oracle createsautomatically when the database is created. The SYSTEM tablespace is always onlinewhen the database is open.每个ORACLE
2012-10-30 09:39:24 594
翻译 Bigfile Tablespaces【每日一译】--2012-10-29
Oracle lets you create bigfile tablespaces. This allows Oracle Database to containtablespaces made up of single large files rather than numerous smaller ones. This letsOracle Database utilize the
2012-10-29 08:51:09 537
翻译 Introduction to Tablespaces, Datafiles, and Control Files【每日一译】--2012-10-28
Databases, tablespaces, and datafiles are closely related, but they have importantdifferences:数据库,表空间和数据文件是关系密切的,但它们有着重要的区别:■ An Oracle database consists of one or more logical storage units c
2012-10-28 10:51:44 842
翻译 Evaluate the Costs and Benefits of Using DBMS_REPAIR(2)【每日一译】--2012-10-27
Task 3: Make Objects UsableDBMS_REPAIR makes the object usable by ignoring corruptions during table andindex scans.任务3:使用对象可用DBMS_REPAIR使用得对象可用通过忽略损坏块在表和索引扫描时。Corruption Repair: Using the
2012-10-27 22:19:42 935
翻译 Evaluate the Costs and Benefits of Using DBMS_REPAIR【每日一译】--2012-10-26
Before using DBMS_REPAIR you must weigh the benefits of its use in relation to theliabilities. You should also examine other options available for addressing corruptobjects. Begin by answering the
2012-10-26 16:46:09 773
原创 BBED
--BBED参数配置FILE_IDFILE_NAMEBLOCKS1/u01/app/oracle/oradata/kfc/system01.dbf755202/u01/app/oracle/oradata/kfc/undotbs01.dbf256009/u01/app/oracle/oradata/kfc/kf
2012-10-26 15:28:32 373
原创 dbms_repair包修复坏块
需修改的参数:KFC--表空间,AIKI--用户名,BBED--表名从做实验来看---BEGINDBMS_REPAIR.ADMIN_TABLES (TABLE_NAME => 'REPAIR_TABLE',TABLE_TYPE => dbms_repair.repair_table,ACTION => dbms_repair.create_action,TA
2012-10-26 15:15:41 845
翻译 Detect and Report Corruptions【每日一译】--2012-10-26
The first task is the detection and reporting of corruptions. Reporting not onlyindicates what is wrong with a block, but also identifies the associated repair directive.There are several ways to
2012-10-26 08:41:55 818
翻译 Introduction to Automatic Undo Management【每日一译】--2010-10-25
Oracle maintains information to nullify changes made to the database. Suchinformation consists of records of the actions of transactions, collectively known asundo. Oracle uses the undo to do the
2012-10-24 14:29:32 493
翻译 Overview of Segments【每日一译】--2012-10-24
A segment is a set of extents that contains all the data for a specific logical storagestructure within a tablespace. For example, for each table, Oracle allocates one or moreextents to form that
2012-10-24 08:22:23 535
翻译 How Extents Are Allocated When Extents Are Deallocated【每日一译]--2012-10-23
Oracle uses different algorithms to allocate extents, depending on whether they arelocally managed or dictionary managed.ORACLE使用不同的算法去分配区块,这取决于它们是否是本地管理还是数据字典管理。With locally managed tablespac
2012-10-22 10:17:11 595
翻译 Overview of Extents【每日一译】--2012-10-22
An extent is a logical unit of database storage space allocation made up of a number ofcontiguous data blocks. One or more extents in turn make up a segment. When theexisting space in a segment is
2012-10-22 08:10:26 482
翻译 How PCTFREE and PCTUSED Work Together【每日一译】--2012-10-21
PCTFREE and PCTUSED work together tooptimize the use of space in the data blocks of the extents within a data segment.Figure 2–5 illustrates the interaction of these two parameters.PCTFREE和PCTUS
2012-10-21 07:56:09 729
翻译 PCTFREE, PCTUSED, and Row Chaining【每日一译】--2012-10-20
For manually managed tablespaces, two space management parameters, PCTFREEand PCTUSED, enable you to control the use of free space for inserts and updates to therows in all the data blocks of a pa
2012-10-20 20:41:30 535
翻译 Row Chaining and Migrating【每日一译】--2012-10-19
In two circumstances, the data for a row in a table may be too large to fit into a singledata block. In the first case, the row is too large to fit into one data block when it is firstinserted. In
2012-10-19 14:47:04 759
原创 bulk collect forall通过limit批量提交
declare type forall_table is table of tb1%rowtype;test_table forall_table;cursor c1 is select * from infores_nb1.tb1 a where exists (select 1 from infores_nb1.t2 b whe
2012-10-19 09:33:31 1020
翻译 Free Space Management【每日一译】--2012-10-19
Free space can be managed automatically or manually.空闲空间可以被自动或手动管理。Free space can be managed automatically inside database segments. The in-segmentfree/used space is tracked using bitmaps, as
2012-10-19 09:04:28 1081
翻译 Overview of Data Blocks
Oracle manages the storage space in the datafiles of a database in units called datablocks. A data block is the smallest unit of data used by a database. In contrast, at thephysical, operating sys
2012-10-17 17:10:17 567
原创 ORA-29701: unable to connect to Cluster Manager
查看后台日志发现如下报错ORA-01114: IO error writing block to file 90 (block # 957841)ORA-29701: unable to connect to Cluster ManagerORA-01114: IO error writing block to file 90 (block # 957841)ORA-29701:
2012-10-17 08:45:49 3241
翻译 ORA-00600 [12333]【每日一译】--2012-10-17
Applies to:Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.2.0.3 - Release: 8.1.7 to 11.2Information in this document applies to any platform.应用于:ORACLE服务企业版本8.1.7.4-11.2.0.3-发行号8.
2012-10-16 11:51:38 1386
翻译 Introduction to Data Blocks, Extents, and Segments【每日一译】--2012-10-16
Oracle allocates logical database space for all data in a database. The units of databasespace allocation are data blocks, extents, and segments. Figure 2–1shows therelationships among these data
2012-10-16 08:41:44 547
翻译 Dedicated Server Configuration【每日一译】--2012-10-15
Dedicated Server ConfigurationFigure 9–4 illustrates Oracle running on two computers using the dedicated serverarchitecture. In this configuration, a user process runs the database application on
2012-10-15 11:38:31 455
翻译 other backgroud process and alert log【每日一译】--2012-10-15
Other Background ProcessesThere are several other background processes that might be running. These caninclude the following:有几个其它后台进程可能在运行的,包含以下几种:MMON performs various manageability-relate
2012-10-15 09:27:00 623
翻译 ARCN QMNN【每日一译】--2012-10-14
Archiver Processes (ARCn)The archiver process (ARCn) copies redo log files to a designated storage device aftera log switch has occurred. ARCn processes are present only when the database is inA
2012-10-14 08:00:30 3808
翻译 reco job queue process【每日一译】--2012-10-13
Recoverer Process (RECO)The recoverer process (RECO) is a background process used with the distributeddatabase configuration that automatically resolves failures involving distributedtransaction
2012-10-13 19:29:22 722
翻译 SMON PMON CKPT【2012-10-12】--每日一译
Checkpoint Process (CKPT)When a checkpoint occurs, Oracle must update the headers of all datafiles to recordthe details of the checkpoint. This is done by the CKPT process. The CKPT processdoes
2012-10-12 14:42:38 720
翻译 Log Writer Process (LGWR)【2012-10-12】--每日一译
Log Writer Process (LGWR)The log writer process (LGWR) is responsible for redo log buffermanagement—writing the redo log buffer to a redo log file on disk. LGWR writes allredo entries that have
2012-10-12 08:54:40 1142
原创 instr和substr对于分隔符号过滤使用
select * from kfc2 1923.168.2551.取第一个小数点前面的数据select substr(a,1,instr(a,'.',1)-1) from kfc2:19232.取最后一个小数点后的数据select substr(a,instr(a,'.',-1)+1,length(a)) from kfc2:255
2012-10-11 15:54:50 1554
翻译 Database Writer Process (DBWn)【20121011】--每日一译
Database Writer Process (DBWn)The database writer process (DBWn) writes the contents of buffers to datafiles. TheDBWn processes are responsible for writing modified (dirty) buffers in the database
2012-10-11 14:48:01 883
翻译 Overview of Oracle Processes【每日一译】--2012-10-11
Overview of Oracle ProcessesThis section describes the two types of processes that run the Oracle database servercode (server processes and background processes). It also describes the trace files
2012-10-11 08:43:31 636
转载 JDBC连接Oracle RAC的连接串配置
网址: http://www.eygle.com/digest/2008/06/jdbcoracle_rac.htmljdbc连接oracle的连接串如下:String url="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))(ADDRESS
2012-10-10 15:52:55 3897
翻译 Content of the PGA【每日一译】--2012-10-10
The content of the PGA memory varies, depending on whether the instance is runningthe shared server option. But generally speaking, the PGA memory can be classified asfollows.PGA的内存的变化目录,取决于实例是否
2012-10-10 11:36:20 472
转载 Oracle常用dump命令介绍
网址: http://www.eygle.com/digest/2008/04/oracledump.html一.Memory Dumps1).Global AreaALTER SESSION SET EVENTS 'immediate trace name global_area level n';1 包含PGA2 包含SGA4 包含UGA8 包含in
2012-10-09 17:29:07 355
原创 ORACLE 日常诊断工具
1.SQL跟踪(1)10046SQL> alter session set events '10046 trace name context forever,level 12';SQL> alter session set events '10046 trace name context off';(2)跟踪其它会话exec dbms_system.set_sq
2012-10-09 16:15:30 964
翻译 Software Code Areas【1009】-每日一译
Software Code AreasSoftware code areas are portions of memory used to store code that is being run or canbe run. Oracle code is stored in a software area that is typically at a different location
2012-10-09 09:09:46 410
翻译 Connections and Sessions【1008】
Connection and session are closely related to user process but are very different inmeaning.对于用户进程来说,连接和会话是相近相关的但是在意义上却不相同。A connection is a communication pathway between a user process and an
2012-10-08 09:09:24 467
翻译 每日一译【1005】SGA_MAX_SIZE
The SGA_MAX_SIZE Initialization ParameterThe SGA comprises a number of memory components, which are pools of memoryused to satisfy a particular class of memory allocation requests. Examples of
2012-10-05 20:32:35 550
KFC系列之 - Oracle DBA入门Mysql(下)
2017-12-11
精通Oracle.10g.Pl.SQL编程
2009-03-15
经典linux sed与awk(第二版)
2009-03-13
linux与unix shell 编程(下)
2009-03-04
linux与unix shell编程(上)
2009-03-03
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人