on 06-13-2011 8:16 PM
Hello
The tablespace PSAPUNDO is growing rapidly on one of client server how to .
PSAPUNDO 1,736.13 151.2
PSAPUNDO 441.125 42.6
PSAPUNDO 183.125 15
PSAPUNDO 142.125 12.6
PSAPUNDO 81.125 5.9
PSAPUNDO 74.125 3.3
PSAPUNDO 44.125 1.9
PSAPUNDO 35.125 1.7
PSAPUNDO 39.125 0.3
PSAPUNDO 20.125 0.3
this growth in six days...? can any one help me as im new to sap
You can check the SQL scripts from SAP note 1438410. E.g. Transactions_Rollback.txt shows you relevant information.
I prefer this SQL script, it is more to the point and shows for each Oracle session the overall undo change vector size (which is the usage of space in PSAPUNDO):
SELECT a.sid, b.name, a.value, c.sql_id
FROM v$sesstat a, v$statname b, v$session c
WHERE a.statistic# = b.statistic#
AND a.sid=c.sid
AND b.name = 'undo change vector size'
AND a.value>0
ORDER BY a.value;
Regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai ..
Oracle Undo segments support read consistent operations and other database operations such as flashback operations, So check weather data base in flashback mode.
KHS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
>
> The tablespace PSAPUNDO is growing rapidly on one of client server how to .
>
> PSAPUNDO 1,736.13 151.2
> PSAPUNDO 441.125 42.6
> PSAPUNDO 183.125 15
> PSAPUNDO 142.125 12.6
> PSAPUNDO 81.125 5.9
> PSAPUNDO 74.125 3.3
> PSAPUNDO 44.125 1.9
> PSAPUNDO 35.125 1.7
> PSAPUNDO 39.125 0.3
> PSAPUNDO 20.125 0.3
>
>
> this growth in six days...? can any one help me as im new to sap
Hi,
Did you check the note 1035137 - Oracle Database 10g: Automatic Undo Retention?
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.