Oracle Database Administrator's Guide 10g
ISBN : -
Order a printed copy of this book from Amazon --UNAVAILABLE--
Cover Design - Oracle Database Administrator's Guide 10g
For your free electronic copy of this book please verify the numbers below.
(We need to do this to make sure you're a person and not a malicious script)
Sample Chapter From Oracle Database Administrator's Guide 10g
Copyright © Oracle Corp
Oracle Database 10g Release 1 (10.1) New Features
These are the features introduced in the current release.Server manageability features are introduced in 'Server Manageability' on page 1-26.
Automatic system task maintenance is discussed in Chapter 23, 'Managing Automatic System Tasks Using the Maintenance Window'.
Bigfile tablespaces
Oracle Database lets you
create single-file tablespaces, called bigfile
tablespaces, which can contain up to 232 or 4G blocks. The benefits of bigfile
tablespaces are the following:
tablespaces, which can contain up to 232 or 4G blocks. The benefits of bigfile
tablespaces are the following:
– They
significantly enhance the storage capacity of an Oracle Database.
– They reduce the number of datafiles needed for an ultra large database.
– They simplify database management by providing datafile transparency.
– They reduce the number of datafiles needed for an ultra large database.
– They simplify database management by providing datafile transparency.
See'Supporting Bigfile Tablespaces During Database Creation' on page 2-23
and 'Bigfile Tablespaces' on page 8-9.
Multiple default temporary tablespace support for SQL operations You can create a temporary tablespace group that can be specifically assigned to users in the same way that a single temporary tablespace is assigned. A tablespace group can also be specified as the default temporary tablespace for the database.
See 'Multiple Temporary Tablespaces: Using Tablespace Groups' on page 8-21.
Rename tablespace
The RENAME TO clause of
the ALTER TABLESPACE statement enables you to
rename tablespaces.
See 'Renaming Tablespaces' on page 8-32.
Cross-platform transportable tablespacesrename tablespaces.
See 'Renaming Tablespaces' on page 8-32.
Tablespaces can be
transported from one platform to another. The RMAN
CONVERT command is used to do the conversion.
See 'Transporting Tablespaces Between Databases: A Procedure and Example'
on page 8-45.
SYSAUX tablespaceCONVERT command is used to do the conversion.
See 'Transporting Tablespaces Between Databases: A Procedure and Example'
on page 8-45.
Oracle Database creates an
auxiliary system tablespace called SYSAUX at
database creation. This tablespace can be used by various Oracle Database
features and products, rather than saving their data in separate tablespaces or
in the SYSTEM tablespace.
See 'Creating the SYSAUX Tablespace' on page 2-17 and 'Managing the
SYSAUX Tablespace' on page 8-34.
Automatic Storage Managementdatabase creation. This tablespace can be used by various Oracle Database
features and products, rather than saving their data in separate tablespaces or
in the SYSTEM tablespace.
See 'Creating the SYSAUX Tablespace' on page 2-17 and 'Managing the
SYSAUX Tablespace' on page 8-34.
Automatic Storage
Management provides a logical volume manager integrated
with Oracle Database, eliminating the need for you to purchase a third-party
product. Oracle Database creates Oracle-managed files within user-defined disk
groups that provide redundancy and striping.
See Chapter 12, 'Using Automatic Storage Management'.
Drop databasewith Oracle Database, eliminating the need for you to purchase a third-party
product. Oracle Database creates Oracle-managed files within user-defined disk
groups that provide redundancy and striping.
See Chapter 12, 'Using Automatic Storage Management'.
The new DROP DATABASE
statement lets you delete a database and all of its
files that are listed in the control file.
files that are listed in the control file.