Introduction

- A database = Logical Storage + Physical Storage.
- Logical storage units called tablespaces.
- A tablespace consists of one or more physical data files.
- When you create an Oracle database, some tablespaces already exist, SYSTEM, SYSAUX, UNDO, TEMP and USERS.

Common Issues Involving Oracle Tablespace Management

Most of the issues involving tablespaces deal with -

- space management
- monitoring space
- and knowing what should be done when particular out of space/unable to extend errors are encountered.

Screenshot:










Master Note: Troubleshooting Oracle Tablespace Management (Doc ID 1522807.1)


Learn More documentMaster Note: Overview of Oracle Tablespace Management(1493350.1)
Troubleshooting documentMaster Note: Troubleshooting Oracle Tablespace Management(1522807.1)
Troubleshooting documentMaster Note: Troubleshooting Oracle Temporary Tablespaces(1524594.1)
Troubleshooting documentMaster Note for Tablespace Issues(1270839.1)

No comments:

Post a Comment