Home » RDBMS Server » Server Administration » Tablespace (Oracle DB, 10.2.0.4, RHEL5)
Tablespace [message #575377] Tue, 22 January 2013 12:17 Go to next message
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 #575378 is a reply to message #575377] Tue, 22 January 2013 12:19 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
https://forums.oracle.com/forums/thread.jspa?messageID=10807288#10807288
Re: Tablespace [message #575381 is a reply to message #575377] Tue, 22 January 2013 12:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59296
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First read:

Database Concepts
Administrator's Guide

Read and watch
Database 2 Day DBA
Oracle DBA Lite

Regards
Michel
Re: Tablespace [message #576341 is a reply to message #575381] Sun, 03 February 2013 17:16 Go to previous message
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
Previous Topic: OFA confuse me - why 3 mount points for datafiles?
Next Topic: NLS date format in Oracle
Goto Forum:
  


Current Time: Thu Oct 02 09:46:15 CDT 2014

Total time taken to generate the page: 0.11446 seconds