| Tablespace [message #575377] |
Tue, 22 January 2013 12:17  |
 |
lahiri7
Messages: 2
Registered: January 2013
|
Junior Member |
|
|
Hello everybody,
I'm new at administrating a database (10gR2 on RHEL5).
1)What are the things need to be considered while creating tablespace?
2)What factors need to be considered when adding space to a tablespace?
Thanks in advance
[Updated on: Tue, 22 January 2013 12:18] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Tablespace [message #576341 is a reply to message #575381] |
Sun, 03 February 2013 17:16  |
 |
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
|
Senior Member |
|
|
The number one thing that I look at is the next size. If you use a small next size it will fragment the OS.
ECSCDAD3 > alter database datafile '/u02/app/oracle/oradata/CSCDAD/CDA_PV_APPS_TBS_01.dbf' autoextend on next 1000m;
Database altered.
ECSCDAD3 > select increment_by,file_name from dba_data_files;
INCREMENT_BY FILE_NAME
------------ ------------------------------------------------
128000 /u02/app/oracle/oradata/CSCDAD/users01.dbf
128000 /u02/app/oracle/oradata/CSCDAD/undotbs01.dbf
128000 /u02/app/oracle/oradata/CSCDAD/sysaux01.dbf
128000 /u02/app/oracle/oradata/CSCDAD/system01.dbf
128000 /u02/app/oracle/oradata/CSCDAD/CDA_APPS_TBS_01.dbf
128000 /u02/app/oracle/oradata/CSCDAD/CDA_PV_APPS_TBS_01.dbf
128000 /u02/app/oracle/oradata/CSCDAD/CLUBS_01.dbf
128000 /u02/app/oracle/oradata/CSCDAD/PLATMAN_TBS_01.dbf
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
