- 浏览: 304414 次
- 性别:
- 来自: 上海
文章分类
- 全部博客 (167)
- <HTML and JavaScript and CSS> (6)
- 《Java2 基础知识及概念》 (3)
- Java2 Tools及其他 (11)
- EJB2.0 相关 (3)
- 英语学习 (4)
- Oracle Database Server (27)
- 计算机理论 (9)
- Java持久层框架 (2)
- 《Linux操作系统》 (24)
- 杂项技术 (4)
- Application Server (15)
- Windows操作系统 (7)
- Java中间件 (6)
- 娱乐生活 (4)
- 《Java设计模式》 (3)
- 《Interview Skill》 (1)
- 《Struts原理及应用》 (1)
- Workflow (2)
- 云计算 (3)
- 项目实践 (3)
- WEB相关技术 (10)
- JavaScript技巧及应用 (1)
最新评论
- show parameter undo;
-
SQL> alter tablespace xxx offline (immediate,temporary or for recovery)
SQL>recover datafile 'xxx'
SQL> show parameter undo - NAME TYPE VALUE
------------------------------------ ---------------------- ---------
undo_management string AUTO(manual)
undo_retention integer 10800
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS1SQL> select * from dba_rollback_segs;
SQL> drop tablespace xxx (先切换,并且老的里面transaction已经都提交了)
SQL> create rollback segment rbs1 tablespace undotbs; (手工创建回滚段)
SQL> execute dbms_flashback.enable_at_time()
SQL> execute dbms_flashback.disable
Undo Data Statistics
SQL> select end_time,begin_time,undoblks from v$undostat;
UndoSpace = [UR(s) * (UPS * DBS)] + (DBS*24)
UR: UNDO_RETENTION
UPS: Number of undo data blocks generated per second
DBS: db_block_size
UNDO Quota for users
UNDO_POOL
DBA_ROLLBACK_SEGS
v$ROLLNAME v$ROLLSTAT v$UNDOSTAT v$SESSION v$TRANSACTION
手工管理回滚段
SQL> show parameter transactions
-
NAME TYPE VALUE
------------------------------------ ---------------------- ------
transactions integer 187
transactions_per_rollback_segment integer 5SQL> show parameter rollback
-
NAME TYPE VALUE
------------------------------------ ---------------------- ------
fast_start_parallel_rollback string LOW
max_rollback_segments integer 37
rollback_segments string ('rbs1','rbs2',...)
transactions_per_rollback_segment integer 5SQL> create (public) rollback segment prbs1 tablespace undotbs;
SQL> alter rollback segment rbs1 online;
发表评论
文章已被作者锁定,不允许评论。
-
Oracle忘记数据库密码
2011-07-01 23:45 772alter user xxx identified by xx ... -
Oracle内存全面分析
2010-07-07 16:49 861http://www.hellodba.com/Doc/ora ... -
(15)Managing User
2010-07-07 13:59 847SQL> alter user xxx quo ... -
(14) Managing Password Security and Resources
2010-07-07 13:59 760Password Management SQL> ... -
(13) Managing Data Integrity
2010-07-07 13:58 753... -
(12) Managing Indexes
2010-07-07 13:58 743a -
(11)Managing Table
2010-07-07 13:57 814Storing User Data(1) Regular t ... -
(9) Storage Structure and Relationships
2010-07-07 13:55 982Extent Allocat ... -
(8) Managing Tablespaces and Data files
2010-07-07 13:55 1103SQL> select * from v$tabl ... -
(7) Maintaining Redo Log Files
2010-07-07 13:54 1147SQL> select * from v$lo ... -
(6) Maintaining Control file
2010-07-07 13:54 713select * from v$database; se ... -
(5)Data Dictionary Content and Usage
2010-07-07 13:53 1017Data Dictionary(1) Data Dictio ... -
(4)Create a Database
2010-07-07 13:52 819Operating System EnvironmentOR ... -
(3)Manage a Oracle Instance
2010-07-07 13:39 814Init Parameter Start Sequences ... -
(2)Getting Start With the Oracle Server
2010-07-07 11:24 802Interactive Installation$ ./r ... -
《Oracle视频教程》
2010-07-07 11:23 22481. Oracle Architectural Compone ... -
Oracle EXP/IMP命令详解
2010-07-07 10:01 1078EXP命令 格式: EXP KEYWORD=value ... -
Oracle EXP Direct
2010-07-07 10:00 1242Oracle提供2种模式导出表数据,传统模式CONVENTIO ... -
EXPDP和IMPDP使用说明
2010-07-07 09:53 1052EXPDP命令行选项 1. ATTACHexpd ... -
Oracle GoldenGate备份软件
2010-07-05 13:46 2570转载:http://edu.codepub.com/2010/ ...
相关推荐
10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...
10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...
10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...
10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...
10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing ...
教程名称:Oracle 11g OCP--1Z0-052 视频集锦课程目录:【】1-Course Introduction【】10-Managing Data and Concurrency【】11-Managing Undo Data【】12-Implementing Oracle Database Security【】13-Database M ...
英文版pdf 1Oracle Architectural Components 2Managing an Oracle Instance 3Creating a Database 4Managing an Oracle Database 5Managing Undo Data 6Managing Tables, Indexes and Integrity...
### Oracle 10g Administration I (1Z0-042) Exam Knowledge Points #### 1. Determining the Size of the Undo Tablespace When deciding on the size of the undo tablespace in your Oracle database, three ...
Undo and preview for all changes, capitalization, search and replace, use parts of file name or directory structure for tags. Directory renaming and restructure based on tags. All customizable and ...
This section discusses the data structures used to implement semaphores, including `struct sem_array`, `struct sem`, `struct seminfo`, `struct semid64_ds`, `struct sem_queue`, `struct sembuf`, and `...
37.zip Microsecond delay 百万分子一的延时(4KB)<END><br>38,38.zip Messagebox with printf capability 有printf能力的Messagebox(4KB)<END><br>39,39.zip Multiple Level Undo/Redo 多级Undo/...
* undo user_content changes to retain compatibility with 0.9.4. * add solaris/ files for easier installation on solaris. * Makefile.am: require automake 1.5 * free() fixes in some card drivers. * fix ...
- **Creating, Opening, and Saving Documents**: Covers the basics of managing files, including saving work in progress and opening existing projects. - **Importing and Exporting**: Supports a wide ...
- **Managing Projects**:涵盖了项目管理的各种方法。 - **Using Automation Designer to Control Toad**:介绍了如何使用自动化设计器来控制Toad。 - **Project Manager**:提供了项目管理器的使用方法。 #### 十...
(16KB)<END><br>87,undo.zip Easily add Undo/Redo to your CDocument/CView Based Applciation(2KB)<END><br>88,PropertyView.zip A "Property Sheet"-like view class for MFC (108KB)<END><br>89,...