-
Rebuilding indexes.....
Hi Gurus,
I am going to Rebuild some of the indexes in our database. I have given the space available in the system,temp and the tablespaces where the indexes are there. Pls guide me whether the tablespaces having enough space to rebuild or not? What r the steps i need to do before rebuild? Thanks in advance.
system tablespace having 155MB freespace.
Temp tablespace having 2475MB freespace.
ds_default_ts has 7 datafiles , which is having freespace of totally 769MB.
ds_index_ts has 5 datafiles, which is having freespace of totally 7477MB.
ds_txn_ts has 7 datafiles, which is having freepspace of totally 1473MB.
ds_par_ts has 4 datafiles, which is having freespace of totally 248MB.
I have given the existing size of the indexes below.
Tablespace Indexes size
---------- ------- -----
ds_default_ts - IDX_PAYTXNPERF 405MB
IDX_PAYSTATPERF 223MB
PK_DS_PAY_STATUSES 111MB
IDX_OATCUSTIDACCTNO 456MB
IDX_OABCUSTIDACCTNO 350MB
SYS_C0061007 833MB
------
TOTAL 2378MB
------
ds_index_ts - IDX_DS_PAY_TXNS 143MB
IDX_PERF_DS_OA_TXNS 503MB
SYS_C0058752 668MB
DS_OA_BALANCES_IDX4 207MB
IDX_CUSTACCT 225MB
SYS_C0058758 1512MB
XIF18DS_OA_BALANCES 750MB
XIF19DS_OA_BALANCES 309MB
XIF17DS_PAY_INVOICE_DTLS 169MB
XIF22DS_PAY_EXCEPTIONS 2MB
------
4488MB
------
ds_txn_ts - SYS_C0058757 77MB
XIF16DS_PAY_STATUSES 80MB
SYS_C0058753 191MB
SYS_C0030685 0.3 (311296 bytes)
SYS_C0030690 0.73 (761856 bytes)
SYS_C0030681 1.5MB
SYS_C0031608 494MB
------
844.53MB
------
ds_par_ts - XIF19DS_PAY_FXCONTRACT_DTLS 0.58 (606208 bytes)
XIF18DS_PAY_DOC_CHECKLISTS 1.31MB
------
1.89MB
------
Rgds,
Saravanan.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|