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 Go to previous message
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: automatic restart of teh instance
Next Topic: invalid datafile
Goto Forum:
  


Current Time: Fri Mar 29 04:05:10 CDT 2024