- 浏览: 304289 次
- 性别:
- 来自: 上海
文章分类
- 全部博客 (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)
最新评论
- Extent Allocation and Deallocation
SQL> alter table xxx allocation extent (size 1m datafile 'xxx');
SQL> alter table xxx deallocation unused; - Database Block
(1) set at tablespace creation
SQL> create tablespace kong2 datafile 'xxx' blocksize 8k; (必须指定db_8k_cache_size)
(2)DB_BLOCK_SIZE is the default block size -
initrans maxtrans
pctfree: 导致row migration(系统开销)
pctused:通知可以再使用
- Configuring Automatic Segment-Space Management
SQL> create tablespace xxx ... SEGMENT SPACE MANAGEMENT AUTO; - Manual Segment Space Management (pctfree,pctused,freelist)
发表评论
文章已被作者锁定,不允许评论。
-
Oracle忘记数据库密码
2011-07-01 23:45 772alter user xxx identified by xx ... -
Oracle内存全面分析
2010-07-07 16:49 858http://www.hellodba.com/Doc/ora ... -
(15)Managing User
2010-07-07 13:59 846SQL> alter user xxx quo ... -
(14) Managing Password Security and Resources
2010-07-07 13:59 759Password Management SQL> ... -
(13) Managing Data Integrity
2010-07-07 13:58 751... -
(12) Managing Indexes
2010-07-07 13:58 743a -
(11)Managing Table
2010-07-07 13:57 812Storing User Data(1) Regular t ... -
(10) Managing Undo Data
2010-07-07 13:56 800show parameter undo; ... -
(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 1146SQL> select * from v$lo ... -
(6) Maintaining Control file
2010-07-07 13:54 712select * from v$database; se ... -
(5)Data Dictionary Content and Usage
2010-07-07 13:53 1015Data Dictionary(1) Data Dictio ... -
(4)Create a Database
2010-07-07 13:52 816Operating System EnvironmentOR ... -
(3)Manage a Oracle Instance
2010-07-07 13:39 813Init Parameter Start Sequences ... -
(2)Getting Start With the Oracle Server
2010-07-07 11:24 800Interactive Installation$ ./r ... -
《Oracle视频教程》
2010-07-07 11:23 22471. Oracle Architectural Compone ... -
Oracle EXP/IMP命令详解
2010-07-07 10:01 1077EXP命令 格式: EXP KEYWORD=value ... -
Oracle EXP Direct
2010-07-07 10:00 1240Oracle提供2种模式导出表数据,传统模式CONVENTIO ... -
EXPDP和IMPDP使用说明
2010-07-07 09:53 1051EXPDP命令行选项 1. ATTACHexpd ... -
Oracle GoldenGate备份软件
2010-07-05 13:46 2568转载:http://edu.codepub.com/2010/ ...
相关推荐
The entity-relationship (ER) diagram is employed to illustrate the structure and relationships among entities in the database, ensuring data consistency and integrity. The data dictionary is used to ...
The ER (Entity-Relationship) diagram is used in the design phase to represent the relationships between different entities in the database, helping to structure the tables and fields effectively. ...
In the system design phase, the entity-relationship (ER) diagram was crucial for visualizing the data structure and defining relationships between entities, such as users, children, vaccines, and ...
incorporating chunking memory strategies to organize words into different groups and semantic relationships, enhancing the organizational structure among words and facilitating learning and retention...
In the Entity-Relationship model, properties that characterize entities and relationships are modeled as (a) attributes (b) participation constraints (c) entity types (d) weak entities Correct...
模块 division, and thereby designed the database structure and application program. The running result of the system proves that the data management system designed by myself can meet the requirements...
SQL Server 2000 offers efficient storage and management of structured data, essential for an e-commerce platform where product catalogues, customer details, and transaction records need to be stored ...
The MySQL database is chosen for its reliability, performance, and wide adoption in the industry, ensuring the storage and retrieval of data are seamless. In terms of functionality, the system is ...
Database design is a crucial aspect, where entities, attributes, and relationships are defined using Entity Relationship (ER) diagrams. Data dictionaries provide detailed descriptions of each data ...
Creating a Data Mining Structure and Model Exploring Data Mining Models Validating Data Mining Models Consuming a Data Mining Model Using the Excel Data Mining add-in After completing this ...
2. Conceptual structure design is to reflect the original data form of entities, attributes, and relationships in the real world. 3. Logical structure design is to design the logical structure of the ...
2.12.1 Storage and Loss Moduli 124 2.13 Rubber Elasticity 126 2.14 Mooney--Rivlin Equation 131 2.15 Elastic Properties of Biological Materials 134 2.15.1 Blood Vessels 134 2.15.2 Articular Cartilage ...
2.12.1 Storage and Loss Moduli 124 2.13 Rubber Elasticity 126 2.14 Mooney--Rivlin Equation 131 2.15 Elastic Properties of Biological Materials 134 2.15.1 Blood Vessels 134 2.15.2 Articular Cartilage ...
Windows 2000 Server Operations Guide, Storage, File Systems, and Printing; Chapters: Evaluating Memory and Cache Usage Advanced Windows, 4th Edition, Jeffrey Richter, Microsoft Press Related ...
- **关系作为约束(Relationships as Constraints)**:在数据库设计中,实体之间的关系不仅仅是连接表的方式,还涉及到约束条件,如外键约束。 **3.6 函数依赖与规范化** - **函数依赖(Functional Dependencies)**...
10.5.9. 取回多条记录 10.5.10. Adding Domain Logic 10.6. Zend_Db_Table_Row 10.6.1. 简介 10.6.2. 取回一条记录 10.6.3. 修改数据 10.7. Zend_Db_Table_Rowset 10.7.1. 简介 10.7.2. 取回结果集 10.7.3....