database capacity planning oracle

default schema for that user. This is the reason why we see schema names as database user names under the Enterprise Manager scheme.A schema cannot be created in an Oracle database, and to create a schema can only be resolved by creating a single user (although there is a CREATE SCHEMA statement in Oracle, it is not u

The data de-duplication technology can provide more backup capacity, achieve longer data retention, maintain continuous verification of backup data, improve the level of data recovery service, and facilitate data disaster tolerance. Duplicate data may have two scenarios, the first one being only some of the fields in the table, and the second is exactly the same as two rows of records. The Oracle

Physical memory requirements: Minimum 1G, minimum 2G on windows7,windows8,windows8.1.Virtual memory (or paging space) capacity requirements: Available RAM Swap Space Required Between 2GB and 16GB Equal to the size of RAM More than GB 16GB Database software hard disk space requirements: Installation Type Requirement

Tip: Article written in 2018/04/24 daily notes generally just as a note, will not do too much is explainedNotes Main content: Oracle simple structure diagram, create database table space User Basic authorizationNotes purpose: Prepare a basic Oracle database for a project when building a new project1.

In my development of the BS structure program, because of the frequent need to process some large-capacity text data in Oracle, so after repeated testing and finally with ASP successfully solved the large text data under Oracle access problem. 　　 　 first, the operating environment:1. Microsoft Windows Server + IIS 5.02. Oracle8i Chinese Standard Edition 　　 secon

Original address: http://blog.sina.com.cn/s/blog_5014663501007n40.htmlin the design of the database, choose the right data type, often can avoid a lot of problems, correctly understand the type of database, for storage space planning, application performance adjustment will be very helpful, here is my personal summary:1. CharFixed-length format string, stored in

1: Create user Copy Code code as follows: Create temporary tablespace user_temp Tempfile ' D:\app\topwqp\oradata\orcl\user_temp.dbf ' Size 500m Autoextend on Next 50m maxsize 2048m Extent management Local; Create Tablespace Ts_mydb Logging DataFile ' D:\app\topwqp\oradata\orcl\ts_mydb.dbf ' Size 500m Autoextend on Next 50m maxsize 2048m Extent management Local; Drop user mydb cascade; Create user mydb identified by mydb Default Tablespace ts_mydb

of the query table space 　　 Select Tablespace_name,count (tablespace_name) from Dba_free_space GROUP by Tablespace_name Having count (Tablespace_name) >10; Alter tablespace name COALESCE; ALTER TABLE name DEALLOCATE unused; Create or replace view Ts_blocks_v as Select Tablespace_name,block_id,bytes,blocks, ' free spaces ' segment_name from Dba_free_space UNION ALL Select Tablespace_name,block_id,bytes,blocks,segment_name from Dba_extents; SELECT * from Ts_blocks_