RE: Statspack consolidation

OK, maybe I missed this but why are they doing this? What expected gains/reporting ability/monitoring ability etc...do they need to achieve by doing this? Or is this another way we DBA's find to waste time (I am guilty of this also), let's face it we love to tinker.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman Sent: Friday, April 29, 2005 3:09 PM
To: Oracle-L
Subject: FW: Statspack consolidation

Table compression can only help if you are using "direct-path" inserts. The
standard STATSPACK package does "conventional" (i.e. not direct-path) inserts, as does the IMP utility, so data loaded from either would not compress.

Table compression would only help if one was transferring data using INSERT
/*+ APPEND */ selecting from a database link or loading data using SQLLDR
DIRECT=3DTRUE.

--
http://www.freelists.org/webpage/oracle-l