urgent: stuck and process not started!

[Former Member]

this morning the oraarch became full, so the system gone in stuck.

In sm66 i found

No Typ PID Status Reaso Se Start Err CPU Time

0 DIA 10276 running Yes *6 1

1 DIA 10356 running Yes *5 476

3 DIA 10364 Complet No *6 2347

6 DIA 10300 running Yes *5 751

7 DIA 3700 running Yes 91

8 DIA 10412 Complet No 1 2355

11 DIA 3368 running Yes 197

14 DIA 2208 running Yes 169

20 SPO 2836 running Yes 1 2

1 DIA 12720 Complet No *6

2 DIA 12608 running Yes *5 235

5 DIA 12528 running Yes *5 73

6 DIA 12672 Complet No *6

9 DIA 4196 Complet No 1

10 DIA 4172 Complet No 1 2362

12 DIA 4168 Complet No 1

13 DIA 6252 Complet No 1 789

14 DIA 1364 Complet No *8 2383

15 DIA 4972 Complet No 1

2 DIA 1044704 running Yes 2069

4 DIA 942314 running Yes 664

5 DIA 1200372 Complet No 1

6 DIA 1351736 Complet No 1

7 DIA 823320 Complet No 1

8 DIA 983274 Complet No 1

9 DIA 1064972 Complet No 1

10 DIA 1200128 Complet No 1

11 DIA 934108 Complet No 1

what i have to do?

i must restart the process not started?

pls is urgent

[JPReyes · Accepted solution]

Hi Sleep,

First find some space for oraarch... once this is done you can try restarting the processes but ideally you should restart the system.

Regards

Juan

Please reward with points if helpful

[Former Member · Accepted solution]

thanks

at least i moved some dbf.

About the wp, in sm51 restart after error.

But i'm with you that it's better to restart the system

[JPReyes · Accepted solution]

Hi Sleep,

You can also use dpmon at OS level to restart work processes.

Hope it helps!

Juan