Oracle7 Server Manager User's Guide Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

Managing Database Storage


This chapter describes how to use Server Manager to manage database storage. This chapter assumes that you have read Chapter 2, "Overview of the Administration Manager," and are familiar with the interface elements of the Administration Manager.

In the Storage drawer, you can manage the tablespaces, datafiles, and rollback segments in your database. This chapter describes the commands available in the Storage drawer's folders:


The Tablespaces Folder

When you click the Tablespace folder tab, the Tablespaces folder opens and the Tablespace object list and menu appear. The Tablespace object list contains information about the tablespaces in your database.

For information about managing tablespaces, see the Oracle7 Server Concepts, the Oracle7 Server Administrator's Guide, and the Oracle7 Server SQL Reference. The following figure illustrates the Tablespace object list.

Figure 3 - 1. Tablespace Object List

Tablespace Object List

The columns of the Tablespace object list are described below:

Tablespace

Name of the tablespace.

Status

Status of the tablespace: ONLINE or Offline.

Size (K)

Total size of the datafiles that comprise the tablespace (in kilobytes).

Used (K)

Amount of space used in the tablespace (in kilobytes).

Remain (K)

Amount of free space in the tablespace (in kilobytes).

% Used

Space used, as a percentage of the tablespace size.

Creating a Tablespace

To create a new tablespace, choose Create from the Tablespace menu. The Create Tablespace property sheet appears.

The Create Tablespace property sheet consists of the following pages:

The following figure illustrates the General page.

Figure 3 - 2. General Page of the Create Tablespace Property Sheet

Create Tablespace: General Page

The General page of the Create Tablespace property sheet is described below:

Name

Name of the tablespace to be created.

Enter the name of the new tablespace. The tablespace name can only contain characters from your database character set and can be at most 30 bytes long.

Status

Status of the tablespace to be created.

Click Online or Offline to specify the initial status of the tablespace. The default is online.

Datafiles

Scrolling list of the datafiles belonging to the tablespace.

New

Displays the New Datafile dialog box, which allows you to specify each new datafile belonging to the new tablespace. For a description of the New Datafile dialog box, see "New Datafile Dialog Box" [*].

Edit

Displays the Edit Datafile dialog box, which allows you to edit the file specification for the datafile selected in the Datafiles scrolling list. For a description of the Edit Datafile dialog box, see "Edit Datafile Dialog Box" [*].

Remove

Removes the datafile selected in the Datafiles scrolling list.

New Datafile Dialog Box

Use the New Datafile dialog box to specify a new datafile to be added to a tablespace. The following figure illustrates the New Datafile dialog box.

Figure 3 - 3. New Datafile Dialog Box

The New Datafile dialog box is described below:

Filename

Name of the datafile to be created.

Enter the new filename. The filename must be specified according to the conventions of your operating system.

Find File

Displays the standard file selection dialog box for your system, which you can use to select a file.

Use Existing File

Designates that the datafile already exists and should be reused.

New File Size

Designates that Oracle should create the file.

Enter a value for the file size. Use the pop-up menu to specify the units of the new datafile's size as either kilobytes or megabytes.

Additional Information: For information about specifying file names on your system, see your operating system-specific Oracle documentation. For information about the standard file selection dialog box for your system, see your operating system-specific documentation.

Edit Datafile Dialog Box

Use the Edit Datafile dialog box to edit the specification of a datafile. The following figure illustrates the Edit Datafile dialog box.

Figure 3 - 4. Edit Datafile Dialog Box

The Edit Datafile dialog box is identical to the New Datafile dialog box. See "New Datafile Dialog Box" [*] for a description of the elements of the New Datafile dialog box.

Create Tablespace: Default Storage Page

On the Default Storage page, you can specify the default storage parameters for all objects created in the tablespace. The following figure illustrates the Default Storage page of the Create Tablespace property sheet.

Figure 3 - 5. Default Storage Page of the Create Tablespace Property Sheet

The Default Storage page is described below:

Initial Extent

Size of the object's first extent.

Enter the size of the initial extent. Use the pop-up menu to specify either kilobytes or megabytes. If you do not specify a size, the default is the size of 5 data blocks.

Next Extent

Size of the next extent to be allocated to the object.

Enter the size of the next extent. Use the pop-up menu to specify either kilobytes or megabytes. If you do not specify a size, the default is the size of 5 data blocks.

Minimum Extents

Total number of extents to be allocated when an object is created in the tablespace.

Enter the minimum number of extents. If you do not specify a number, the default value is 1.

Maximum Extents

Maximum number of extents that can be allocated to an object created in the tablespace.

Enter the maximum number of extents. If you do not specify a value, the default value applies. The default and maximum values depend on the data block size.

Percentage Increase

Percent by which each extent after the second grows over the previous extent.

Enter a value for percent increase. If you do not specify a value, the default is 50.

Altering a Tablespace

To alter an existing tablespace, select the tablespace from the Tablespace object list and choose Alter from the Tablespace menu. The Alter Tablespace property sheet appears. You can also bring up the Alter Tablespace property sheet by double-clicking on a tablespace in the Tablespace object list.

The Alter Tablespace property sheet consists of the following pages:

The following figure illustrates the General page.

Figure 3 - 6. General Page of the Alter Tablespace Property Sheet

Alter Tablespace: General Page

The General page of the Alter Tablespace property sheet is described below:

Name

Name of the tablespace to be altered.

Status

Status of the tablespace. Click Online or Offline to alter the status of the tablespace.

Datafiles

Scrolling list of the datafiles belonging to the tablespace.

New

Displays the New Datafile dialog box, which allows you to specify a datafile to add to the tablespace. For a description of the New Datafile dialog box, see "New Datafile Dialog Box" [*].

Edit

Allows you to edit the file specification for the datafile selected in the Datafiles scrolling list.

If the selected datafile is one you have just added to the Datafiles scrolling list, the Edit button displays the Edit Datafile dialog box. For a description of the Edit Datafile dialog box, see "Edit Datafile Dialog Box" [*].

If the selected datafile has already been added to the tablespace, the Edit button displays the Rename Datafile dialog box, which allows you to rename the selected datafile. For a description of the Rename Datafile dialog box, see "Rename Datafile Dialog Box" [*]. In order to rename a datafile, its tablespace must be offline.

Remove

Removes the datafile selected in the Datafiles scrolling list.You can only remove a file specification you have just added to the Datafiles scrolling list. You cannot remove a datafile that has already been added to the tablespace.

Attention: When you use the Alter Tablespace property sheet to take a tablespace offline, Server Manager takes the tablespace offline in NORMAL mode. If you want to take a tablespace offline in TEMPORARY or IMMEDIATE mode, choose Take Offline from the Tablespace menu. The Take Offline menu item is described in "Placing a Tablespace Online or Taking a Tablespace Offline" [*].

New Datafile Dialog Box

Use the New Datafile dialog box to specify a new datafile to be added to a tablespace. The following figure illustrates the New Datafile dialog box.

Figure 3 - 7. New Datafile Dialog Box

The New Datafile dialog box is described below:

Filename

Name of the datafile to be created.

Enter the new filename. The filename must be specified according to the conventions of your operating system.

Find File

Displays the standard file selection dialog box for your system, which you can use to select a file.

Use Existing File

Designates that the datafile already exists and should be reused.

New File Size

Designates that Oracle should create the file.

Enter a value for the file size. Use the pop-up menu to specify the units of the new datafile's size as either kilobytes or megabytes.

Additional Information: For information about specifying filenames on your system, see your operating system-specific Oracle documentation. For information about the standard file selection dialog box for your system, see your operating system-specific documentation.

Edit Datafile Dialog Box

Use the Edit Datafile dialog box to edit the specification of a datafile. The following figure illustrates the Edit Datafile dialog box.

Figure 3 - 8. Edit Datafile Dialog Box

The Edit Datafile dialog box is identical to the New Datafile dialog box. See "New Datafile Dialog Box" [*] for a description of the elements of the New Datafile dialog box.

Rename Datafile Dialog Box

The Rename Datafile dialog box allows you to rename a datafile belonging to a tablespace. You must rename a tablespace's datafile if you have changed the name of the corresponding operating system file or if you have moved the file to a new location. In order to rename a datafile, its tablespace must be offline.

The following figure illustrates the Rename Datafile dialog box.

Figure 3 - 9. Rename Datafile Dialog Box

The Rename Datafile dialog box is described below:

From

Old filename.

To

New filename.

Enter the new filename. The filename must be specified according to the conventions of your operating system.

Attention: When you rename a datafile using Server Manager, the name of the operating system file is not changed. The new filename is only associated with the tablespace. Before renaming the datafile using Server Manager, you must change the name of the file through your operating system.

Alter Tablespace: Default Storage Page

On the Default Storage page of the Alter Tablespace property sheet, you can alter the default storage parameters for objects subsequently created in the tablespace. The following figure illustrates the Default Storage page of the Alter Tablespace property sheet.

Figure 3 - 10. Default Storage Page of the Alter Tablespace Property Sheet

On the Default Storage page of the Alter Tablespace property sheet, Server Manager displays the current storage characteristics of the tablespace.

The Default Storage page is described below:

Initial Extent

Size of the object's first extent.

Enter the size of the initial extent. Use the pop-up menu to specify either kilobytes or megabytes. If you do not specify a size, the default is the size of 5 data blocks.

Next Extent

Size of the next extent to be allocated to the object.

Enter the size of the next extent. Use the pop-up menu to specify either kilobytes or megabytes. If you do not specify a size, the default is the size of 5 data blocks.

Minimum Extents

Total number of extents to be allocated when an object is created in the tablespace.

Enter the minimum number of extents. If you do not specify a number, the default value is 1.

Maximum Extents

Maximum number of extents that can be allocated to an object created in the tablespace.

Enter the maximum number of extents. If you do not specify a value, the default value applies. The default and maximum values depend on the data block size.

Percentage Increase

Percent by which each extent after the second grows over the previous extent.

Enter a value for percent increase. If you do not specify a value, the default is 50.

Dropping a Tablespace

To drop an existing tablespace, select the tablespace to be dropped from the Tablespace object list and choose Drop from the Tablespace menu. The Drop Tablespace alert box appears.

When you drop a tablespace, all objects in the tablespace are dropped as well. Server Manager also drops all referential integrity constraints from tables outside the tablespace that refer to primary or unique keys in the tables stored in the dropped tablespace.

The following figure illustrates the Drop Tablespace alert box.

Figure 3 - 11. Drop Tablespace Alert Box

The Drop Tablespace alert box indicates if the tablespace to be dropped contains any objects or contains any tables referenced by integrity constraints from tables outside the tablespace being dropped.

Suggestion: Before dropping a tablespace, take it offline. This ensures that SQL statements that are currently running transactions do not access objects in the tablespace.

Adding a Datafile to a Tablespace

To add a datafile to an existing tablespace, select the tablespace from the Tablespace object list and choose Add Datafile from the Tablespace menu. The Add Datafile dialog box appears.

The following figure illustrates the Add Datafile dialog box.

Figure 3 - 12. Add Datafile Dialog Box

The Add Datafile dialog box is described below:

Filename

Name of the datafile to be created.

Enter the new filename. The filename must be specified according to the conventions of your operating system.

Find File

Displays the standard file selection dialog box for your system, which you can use to select a file.

Use Existing File

Designates that the datafile already exists and should be reused.

New File Size

Designates that Oracle should create the file.

Enter a value for the file size. Use the pop-up menu to specify the units of the new datafile's size as either kilobytes or megabytes.

Placing a Tablespace Online or Taking a Tablespace Offline

To place a tablespace online, select the tablespace from the Tablespace object list and choose Place Online from the Tablespace menu. The tablespace is placed online.

To take a tablespace offline, select the tablespace from the Tablespace object list and choose Take Offline from the Tablespace menu. The Take Tablespace Offline dialog box appears.

The following figure illustrates the Take Tablespace Offline dialog box.

Figure 3 - 13. Take Tablespace Offline Dialog Box

The Take Tablespace Offline dialog box is described below:

Offline Mode: Normal

Takes the tablespace offline in normal mode.

A checkpoint is performed for all datafiles in the tablespace (all of these datafiles must be available). You need not perform media recovery on this tablespace before placing it back online. You must use this option if the database is in NOARCHIVELOG mode.

Offline Mode: Temporary

Takes the tablespace offline in temporary mode.

A checkpoint is performed for all online datafiles in the tablespace but does not ensure that all files can be written. Any offline files may require media recovery before you place the tablespace back online.

Offline Mode: Immediate

Takes the tablespace offline in immediate mode.

Oracle does not ensure that the datafiles are available, and no checkpoint is performed. You must perform media recovery on the tablespace before placing it back online.

Use the SQL Worksheet to perform media recovery on a specific tablespace or datafile. For information about the SQL Worksheet, see Chapter 9, "Overview of the System Monitors."


The Datafiles Folder

When you click the Datafiles folder tab, the Datafiles folder opens and the Datafile object list and menu appear. The Datafile object list contains information about the datafiles in your database.

For information about datafiles, see the Oracle7 Server Concepts and the Oracle7 Server Administrator's Guide.

The following figure illustrates the Datafile object list.

Figure 3 - 14. Datafile Object List

Datafile Object List

The columns of the Datafile object list are described below:

Filename

Name of the datafile.

Tablespace

Tablespace to which the datafile belongs.

Status

Status of the datafile: Available or Invalid.

Size (K)

Size of the datafile in kilobytes.

Creating a Datafile

To create a new datafile, choose Create from the Datafile menu. The Create Datafile property sheet appears. The Create Datafile property sheet consists of one page, called the Datafile Specification page.

The following figure illustrates the Datafile Specification page.

Figure 3 - 15. Datafile Specification Page of the Create Datafile Property Sheet

Datafile Specification Page

The Datafile Specification page of the Create Datafile property sheet is described below:

Tablespace

Name of the tablespace to which the new datafile belongs.

Use the pop-up menu to choose the tablespace.

Filename

Name of the datafile to be created.

Enter the name of the new datafile. The filename must be specified according to the conventions of your operating system.

Find File

Displays the standard file selection dialog box for your system, which you can use to select a local file. Remote files cannot be seen.

Use Existing File

Designates that the datafile already exists and should be reused.

New File Size

Designates that Oracle should create the file.

Enter the size of the new datafile. Use the pop-up menu to specify either kilobytes or megabytes.

Renaming a Datafile

To rename an existing datafile, select the datafile to be renamed from the Datafile object list and choose Rename from the Datafile menu. The Rename Datafile dialog box appears. You can also bring up the Rename Datafile dialog box by double-clicking on the datafile in the Datafile object list.

You must rename a datafile if you have changed the name of the corresponding operating system file or if you have moved the file to a new location. To rename a datafile, its tablespace must be offline.

The following figure illustrates the Rename Datafile dialog box.

Figure 3 - 16. Rename Datafile Dialog Box

Rename Datafile Dialog Box

The Rename Datafile dialog box is described below:

From

Old filename.

To

New filename.

Enter the new filename. The filename must be specified according to the conventions of your operating system.

Attention: When you rename a datafile using Server Manager, the name of the operating system file is not changed. The new filename is only associated with the tablespace. Before renaming the datafile using Server Manager, you must change the name of the file through your operating system.


The Rollback Folder

When you click the Rollback folder tab, the Rollback folder opens and the Rollback object list and menu appear. The Rollback object list contains information about the rollback segments in your database.

For information about managing rollback segments, see the Oracle7 Server Concepts, the Oracle7 Server Administrator's Guide, and the Oracle7 Server SQL Reference.

The following figure illustrates the Rollback object list.

Figure 3 - 17. Rollback Object List

Rollback Object List

The columns of the Rollback object list are described below:

Segment

Name of the rollback segment.

Tablespace

Tablespace that contains the rollback segment.

Status

Status of the rollback segment: ONLINE, Offline, Invalid, Needs Recovery, or Partly Available.

Extents

Number of extents allocated to the rollback segment.

Max

Maximum number of extents allowed for the rollback segment.

Size (K)

Space allocated to the rollback segment (in kilobytes).

Optimal

Optimal size, in kilobytes, of the rollback segment (blank if optimal is not specified for the rollback segment). Optimal is not displayed for offline rollback segments.

Creating a Rollback Segment

To create a new rollback segment, choose Create from the Rollback menu. The Create Rollback Segment property sheet appears.

The Create Rollback Segment property sheet consists of the following pages:

The following figure illustrates the General page.

Figure 3 - 18. General Page of the Create Rollback Segment Property Sheet

Create Rollback Segment: General Page

The General page of the Create Rollback Segment property sheet is described below:

Rollback Segment

Name of the rollback segment to be created.

Enter the name of the new rollback segment. The rollback segment name can only contain characters from your database character set and can be at most 30 bytes long.

Tablespace

Name of the tablespace in which to create the rollback segment.

Use the pop-up menu to choose the tablespace.

Status

Status of the rollback segment to be created.

Click Online or Offline to specify the initial status of the rollback segment.

Create Rollback Segment: Storage Page

On the Storage page you can specify the storage characteristics of the rollback segment. The Storage page of the Create Rollback Segment property sheet is illustrated in the following figure.

Figure 3 - 19. Storage Page of the Create Rollback Segment Property Sheet

The Storage page is described below:

Initial Extent

Size of the rollback segment's first extent.

Enter the size of the initial extent. Use the pop-up menu to specify either kilobytes or megabytes. The default is the size of 5 data blocks.

Next Extent

Size of the next extent allocated to the rollback segment.

Enter the size of the next extent. Use the pop-up menu to specify either kilobytes or megabytes. The default is the size of 5 data blocks.

Optimal

Optimal size for the rollback segment. Optimal is not displayed for offline rollback segments.

Enter the value for Optimal. Use the pop-up menu to specify either kilobytes or megabytes. Oracle tries to maintain the optimal size of the rollback segment by dynamically deallocating extents when their data is no longer needed for active transactions. A blank field assumes the default value.

The default value of Optimal is null. If Optimal is null, Oracle never deallocates the rollback segment's unused extents.

The value of Optimal can never be less than the space initially allocated to the rollback segment, as specified by the values of Initial Extent, Next Extent, and Minimum Extents.

Minimum Extents

Total number of extents to be allocated when the rollback segment is created.

Enter the minimum number of extents. The default and minimum value is 2.

Maximum Extents

Maximum number of extents that can be allocated to the rollback segment.

Enter the maximum number of extents. The default and maximum values depend on the data block size.

Altering a Rollback Segment

To alter an existing rollback segment, select the rollback segment to be altered from the Rollback object list and choose Alter from the Rollback menu. The Alter Rollback Segment property sheet appears. You can also bring up the Alter Rollback Segment property sheet by double-clicking on the rollback segment in the Rollback object list. The Alter Rollback Segment property sheet consists of the following pages:

The following figure illustrates the General page.

Figure 3 - 20. General Page of the Alter Rollback Segment Property Sheet

Alter Rollback Segment: General Page

The General page of the Alter Rollback Segment property sheet is described below:

Rollback Segment

Name of the rollback segment to be altered.

Tablespace

Tablespace to which the rollback segment belongs.

Status

Status of the rollback segment.

Click Online or Offline to alter the status of the rollback segment. For information about placing a rollback segment online or taking it offline, see "Placing a Rollback Segment Online or Taking a Rollback Segment Offline" [*].

Alter Rollback Segment: Storage Page

On the Storage page you can alter the storage characteristics of the rollback segment. These changes apply to any subsequent extent allocations to the rollback segment. The Storage page of the Alter Rollback Segment property sheet is illustrated in the following figure.

Figure 3 - 21. Storage Page of the Alter Rollback Segment Property Sheet

The Storage page of the Alter Rollback Segment property sheet is described below:

Initial Extent

Size of the initial extent that was allocated to the rollback segment when it was created.

Next Extent

Size of the next extent to be allocated to the rollback segment.

Enter the size of the next extent. Use the pop-up menu to specify either kilobytes or megabytes.

Optimal Size

Optimal size for the rollback segment. Optimal is not displayed for offline rollback segments.

Enter the value for Optimal. Use the pop-up menu to specify either kilobytes or megabytes. For more information on Optimal, see "Create Rollback Segment: Storage Page" [*].

Minimum Extents

Number of extents that were allocated to the rollback segment when it was created.

Maximum Extents

Maximum number of extents that can be allocated to the rollback segment.

Enter the maximum number of extents. The default and maximum values depend on the data block size.

Dropping a Rollback Segment

To drop an existing rollback segment, select the rollback segment to be dropped from the Rollback object list and choose Drop from the Rollback menu. The Drop Rollback Segment alert box appears.

The following figure illustrates the Drop Rollback Segment alert box.

Figure 3 - 22. Drop Rollback Segment Alert Box

Attention: You can only drop a rollback segment that is offline.

Placing a Rollback Segment Online or Taking a Rollback Segment Offline

To place a rollback segment online, select the rollback segment from the Rollback object list and choose Place Online from the Rollback menu. The rollback segment is placed online.

To take a rollback segment offline, select the rollback segment from the Rollback object list and choose Take Offline from the Rollback menu. The rollback segment is taken offline.

When you change the status of a rollback segment to offline, Oracle takes the rollback segment offline immediately if the rollback segment does not contain information necessary to roll back any active transactions. If the rollback segment does contain information for active transactions, Oracle makes the rollback segment unavailable for future transactions and takes it offline after all the active transactions are committed or rolled back.

Attention: Because Oracle does not take a rollback segment offline until all its active transactions have completed, there may be some delay before the status of the rollback segment is changed to Offline in the Rollback object list.




Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index