tpc reports, does anyone read them?
From: bdbafh <bdbafh_at_gmail.com>
Date: Fri, 11 Apr 2008 12:11:04 -0700 (PDT)
Message-ID: <5a669cf2-7a36-409d-8e26-857164e974bd@f63g2000hsf.googlegroups.com>
Date: Fri, 11 Apr 2008 12:11:04 -0700 (PDT)
Message-ID: <5a669cf2-7a36-409d-8e26-857164e974bd@f63g2000hsf.googlegroups.com>
http://www.tpc.org/results/FDR/TPCC/HP_ML370G5_TPCC_071112_FDR.pdf Page 96
spool createmisc.log
set echo on;
alter user tpcc temporary tablespace system;
So ... when is the last release in which a user account could have a
temporary tablespace that was system?
I'm quite certain that it pre-dated 8i.
One explanation is that no one ever reviews the log files that are generated ... even though an auditor signs off on the report.
Yeah, the statement simply fails and the user's temporary tablespace
remains unchanged.
No big deal.
It just seems to me that they likely haven't reviewed their scripts
since they outsourced their dba operations prior to moving to 8i.
-bdbafh Received on Fri Apr 11 2008 - 14:11:04 CDT