Roger,
Classic potential CTD (compulsive tuning disorder). If nobody
complains, then it's probably not an issue...
But sometimes too, end-users are stunned into -- or have become
apathetic to -- not reporting problems. So, to verify, check your top
wait-events, whether globally by looking at STATSPACK or specifically
for a session looking at TKPROF, and see whether you have waits the
"enqueue" wait-event and on "TS" enqueues in particular. Recalling the
running of large apps on v7.1.6, when "temporary" tablespaces didn't
exist, I recall huge waits on "TS" (i.e. temporary segment) enqueue in
permanent tablespaces...
If this comes up negative, then migrating to a true "temporary"
tablespace on TEMPFILEs should be a low-priority issue that falls into
the category of "preventative maintenance". It should still be done,
but it should be cleared with SAP Support, tested, and slotted in with
other maintenance items.
Hope this helps...
-Tim
Roger Xu wrote:
Hi,
I
inherited a SAP R/3 4.0B database in Solaris 9 / Oracle 9i.
And
it uses a permanent tablespace for temporary tablespace.
Any
comments and thoughts? It has been like this for at least
3
year and nobody report any problems because of this.
a629pse0:oraps1 3% sqlplus "/ as
sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on
Fri Oct 27 10:06:45 2006
Copyright (c) 1982, 2002, Oracle
Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> select
USERNAME,TEMPORARY_TABLESPACE from dba_users;
USERNAME
TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYS PSAPTEMPD
SYSTEM PSAPTEMPD
SAPR3 PSAPTEMPD
OPS$PS1ADM PSAPTEMPD
DBSMON PSAPTEMPD
DBSNMP PSAPTEMPD
OUTLN PSAPTEMPD
OPS$ORAPS1 PSAPTEMPD
THEGUARD PSAPTEMPD
NEXUS PSAPTEMPD
10 rows
selected.
SQL> select
CONTENTS,EXTENT_MANAGEMENT,SEGMENT_SPACE_MANAGEMENT
2 from dba_tablespaces
3 where tablespace_name = 'PSAPTEMPD';
CONTENTS
EXTENT_MAN SEGMEN
--------- ---------- ------
PERMANENT DICTIONARY MANUAL
SQL> select TABLESPACE_NAME
from dba_tablespaces where CONTENTS != 'PERMANENT';
no rows selected
SQL> select count(*) from
dba_temp_files;
COUNT(*)
----------
0
Thanks,
Roger
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Any review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 27 2006 - 12:39:22 CDT
