 |
| ADVICE: |
| >> |
Basic Oracle space monitoring scripts
TIP :To keep your Oracle databases running 24x7, you need some basic space monitoring scripts. Here are three useful ones. |
| >> |
A simple way to reorganize a table and release the unused space
TIP :A simple way to reorganize a table and release the unused space is by
using the following simple command. |
| >> |
How to use Resumable Space Allocation in Oracle 9i
TIP :Here's how to use Resumable Space Allocation in Oracle 9i. |
| >> |
Guessing whether tablespace has sufficient space
ASK THE EXPERTS :We perform a load of several million records a day
in a Oracle 9i database.
We can roughly estimate the total size the ... |
| >> |
Generate a bar graph for tablespace utilization
TIP :An Oracle SQL script that will generate a bar graph showing the status of tablespaces in the database. |
| >> |
Generate a bar graph for tablespace utilization, part 2
TIP :A PERL script that will generate of bar graph of Oracle tablespace utilization. |
| >> |
Space check before data LOAD
TIP :Here's a script to check table space before loading millions of records; especially useful in data warehousing situations. |
| >> |
Compute a table's rowsize
TIP :This script computes the average rowsize of an existing Oracle table to help you determine required table space requirements. |
| >> |
Unix script to gather tablespace information
TIP :This Unix script is used to gather tablespace information, including space, used_space and fragmentation. |
| >> |
Getting accurate measures of table space
ASK THE EXPERTS :I am having a problem with the dba_free_space view.
We have a large amount
of purging going on in our database recently, ... |
| >> |
Calculating space used by one table and index
ASK THE EXPERTS :Soon, one system is going to move to a production
database.
Are there any formulas for calculating the space to be
used ... |
| >> |
Determine used and free space in a tablespace
TIP :Use this script to determine total size, used space, free space and percentage of used and free space in all tablespaces. |
| >> |
Defragmenting a tablespace to free up contiguous space?
ASK THE EXPERTS :I have a tablespace consisting of four data files.
Each data file is 1 GB. Overall, the tablespace has
around 1.5 GB of ... |
| >> |
More on defragmenting a tablespace to free space
ASK THE EXPERTS : Did I miss something?
The question below regards tablespace
free space. You state that prior to 8i,
free space ... |
| >> |
Tablespace still has 80% usage after large deletion
ASK THE EXPERTS :I have a 100 MB tablespace. When I viewed
it through DBA studio, I found that 80% of the space was
utilised. I deleted ... |
| >> |
RBS tablespace is full
ASK THE EXPERTS :I installed Oracle 8.1.7 on a Unix box and client on
Win2K box. I created a
test database db1 using the dbassist ... |
| >> |
Will tablespace show more free space after deleting records?
ASK THE EXPERTS :I have a tablespace of 100 MB. Current usage is that 70 MB has 6 Lakh records. Now if I delete 4 lakh records, will the ... |
| >> |
Does 9iR2 release temporary tablespace that is no longer used?
ASK THE EXPERTS :Does Oracle 9iR2 release temporary tablespace that
is no longer being used? I am running it on Red Hat
Linux (not ... |
| >> |
Squeeze the size of files in a tablespace
TIP :This script lets you squeeze all the files in a tablespace at once. |
| >> |
Reducing the amount of space used during exports
TIP :This Oracle tip shows how to reduce the amount of space used during exports. |
