What is tablespaces? Explain the
purpose of tablespaces.
Oracle tablespaces - Dec 03, 2008 at 15:00 PM by Rajmeet Ghai
What is tablespaces? Explain the purpose of tablespaces.
A table space can be considered as a storage location where the database objects
are kept. It forms a part of the physical portion of the database used to
allocate storage to these objects. Once a table space is created, it can
referred by name when creating the database objects.
Purpose:
It can be used to control the disk layout of an installation. It can be used to
optimize performance.
Also read
Tablespaces is a logical storage unit. It is used to group related logical
structures together........
SYSTEM Tablespace, SYSAUX Tablespace, UNDO Tablespace, TEMP Tablespace.........
Tablespace fragmentation can be prevented by using PCTINCREASE command.
PCTINCREASE is the percentage a new subsequent extent will grow................
|
