Home » RDBMS Server » Server Administration » large table (Oracle 7.3.4.5.0, Solaris 8)
large table [message #675535] |
Thu, 04 April 2019 03:34 |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
|
|
Gurus,
Please help me on what to do with the table that would take much time
before you retrieve its record count by:
select count(*) from user_ledger_trans;
This table has a PCT_FULL percentage of 99.95% (ALLOCATED_MB=12,680; USED_MB=12,673.87).
We only identified it's num_rows (141,704,779) by executing:
select * from dba_tables
where table_name='USER_LEDGER_TRANS';
Our end-users cannot proceed anymore to process any update on this table.
The table size is around 2GB already.
Thank you in advance.
|
|
|
Goto Forum:
Current Time: Fri Mar 29 04:05:10 CDT 2024
|