Re: tpc reports, does anyone read them?
Date: Fri, 11 Apr 2008 12:55:37 -0700 (PDT)
Message-ID: <02166656-0655-4de7-9b7b-961cd371744d@k13g2000hse.googlegroups.com>
On Apr 11, 2:11 pm, bdbafh <bdb..._at_gmail.com> wrote:
> 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
It appears that 8.1.7.4 allows such errant behaviour:
SQL> select *
2 from v$version;
BANNER
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.4.0 - Production NLSRTL Version 3.4.1.0.0 - Production
.
SQL> alter user bing temporary tablespace system;
User altered.
SQL> And, gee whiz, so does 9.2.0.8:
SQL> select *
2 from v$version;
BANNER
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production NLSRTL Version 9.2.0.8.0 - Production
SQL> alter user bing temporary tablespace system;
User altered.
SQL> It isn't until 10g that this is 'illegal':
SQL> select * from v$version;
BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio NLSRTL Version 10.2.0.3.0 - Production
SQL> alter user bing temporary tablespace system;
alter user bing temporary tablespace system
*
ERROR at line 1:
ORA-12911: permanent tablespace cannot be temporary tablespace
SQL> David Fitzjarrell Received on Fri Apr 11 2008 - 14:55:37 CDT