- 博客(8)
- 资源 (9)
- 收藏
- 关注
翻译 oracle体系结构(六)
Overview ofSegments段概述A segment is a set of extents that containsall the data for a specific logical storage structure within a tablespace. Forexample, for each table, Oracle allocates one or more
2013-07-16 15:49:17 564
翻译 oracle体系结构(五)
When Extents Are DeallocatedThe Oracle Database provides a Segment Advisor that helps you determine whether an object has space available for reclamation based on the level of space fragmentation wi
2013-07-10 11:00:12 621
翻译 oracle体系结构(四)
Overview of ExtentsAn extentis a logical unit of database storage space allocation made up of a number of contiguousdata blocks. One or more extents in turn make up a segment. When the existingspace
2013-07-08 12:52:00 585
翻译 oracle体系结构(三)
PCTFREE, PCTUSED, and Row ChainingFor manually managed tablespaces, two space management parameters, PCTFREE and PCTUSED, enable you to control the use of free space for inserts and updates to the
2013-07-05 15:44:38 603
原创 oracle之rman恢复redolog
一、环境搭建1、 删除(移走)redologfile[oracle@rac3orcl]$ lscontrol01.ctl control03.ctl redo02.log rhf.dbf system01.dbf undotbs01.dbfcontrol02.ctl redo01.log redo03.log sysaux01.dbf temp0
2013-07-05 14:40:01 2597
翻译 oracle体系结构(二)
FreeSpace Management 可用空间的管理Freespace can be managed automatically or manually.Freespace can be managed automatically inside database segments. The in-segmentfree/used space is tracked using bitm
2013-07-04 10:15:50 511
原创 oracle之rman恢复spfile练习
今天开始学习rman恢复技术,今天初入门,先学习spfile丢失后的恢复操作,分为两部分:1、环境搭建以及前提准备;2、恢复操作过程一、环境准备先对数据库进行全备份1、 连接数据库[oracle@rac3 ~]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jun 300
2013-07-03 17:15:17 803
翻译 oracle体系结构(一)
Introduction toData Bloc ks, Extents, and SegmentsOracleallocates logical database space for all data in a database. The units of database space allocation are data blocks, extents, and segments. Fi
2013-07-02 23:26:50 650
oracle 10G常见进程
2013-05-16
RHLinux5.4磁盘空间不够挂载硬盘.doc
2012-12-27
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人