on 02-26-2012 2:33 PM
Dear all,
I've successfully finished Oracle upgrade on the production environment from 10.2.0.4. to 11.2.0.2 on HP-UX 11.31
When upgrading on development and quality assurance systems I didn't notice that in RZ20 for Database -> Oracle-> Space management-> PSAPTEMP tablespace have Free space 0% and 0MB.
In Oracle Enterprise manager it is not this picture it shows the 88% used space and I tried resize of one of the datafiles it succeeded without problems.
I checked the brtools and it is exactly like RZ20:
.....
26 - PSAPSTABI DATA ONLINE LOCAL AUTO NO NO 6/0 NO NO
15601664 87.22 ; 1994304 15601664 0 3 1864640:128960:704:0:0
27 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO NO 4/0 NO NO
9226240 0.00 9226240 9226240 0 0 0:0:0:0:0
28 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO NO 3/0 NO NO
6054168 0.00 ; 6053952 6054168 0 896 2351040:1232832:1083584:8192:8192
29 - PSAPUSER1D DATA ONLINE LOCAL AUTO NO NO 2/0 NO NO
.....
It says it is online.
I've checked the look in the 10.2.0.4 instance and RZ20 is not saying this 0MB free space.
Is it some known issue in Oracle 11g ...
Can this be a problem?
Thank you in advance.
I found the note Note 1528754 - Incorrect space display for PSAPTEMP in RZ20 with Oracle 11g
It says to implement SAPKB70024, but we are stil on SAPKB70012. When I started implementing just BASIS patches also needed some Developers intervention in MOdification ajustments and this actions were stoped for I some period
Thats why I need to implement just the correction instructions.
Can I just implement the correction instuctions ???
BR,
Ruzica
Edited by: Ruzica Kalkasliev on Feb 26, 2012 3:39 PM
Hello Ruzica,
Can I just implement the correction instuctions ???
sorry i don't get the point. There is a correction available for SAP_BASIS 620 to 730 regarding sapnote #1528754.
You can use the view V$TEMPSEG_USAGE to manually monitor your temporary tablespace usage:
http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3107.htm#REFRN30285
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Stefan,
I was asking is it OK to skip patch-ing with SAP_BASIS 700, just to implement this Note corections.
I've checked the V$TEMPSEG_USAGE and it is empty.
> sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 27 08:54:04 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from V$TEMPSEG_USAGE;
no rows selected
SQL> desc V$TEMPSEG_USAGE
Name Null? Type
-
-
-
USERNAME VARCHAR2(30)
USER VARCHAR2(30)
SESSION_ADDR RAW(8)
SESSION_NUM NUMBER
SQLADDR RAW(8)
SQLHASH NUMBER
SQL_ID VARCHAR2(13)
TABLESPACE VARCHAR2(31)
CONTENTS VARCHAR2(9)
SEGTYPE VARCHAR2(9)
SEGFILE# NUMBER
SEGBLK# NUMBER
EXTENTS NUMBER
BLOCKS NUMBER
SEGRFNO# NUMBER
SQL>
BR,
Ruzica
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.