Question Re: DB02-Space Orveriew empty in Technology Q&A

DB02-Space Orveriew empty

Former Member — Mon, 02 Dec 2013 18:41:35 GMT

Hi ,

In transaction DB02-space overview, is not showing any value. Only this option doens't shows value.

I checked the notes 1002840, 868063 and 1028624. I verified that the DB02_COLL_PLAN table, the function ORA_COLL_OVERVIEW is with status "I", but I don't know if this is the real problem or how I do activate this function.

I tried to change the status to "A" in SE16 but the status back to "I".

any ideas ?

SAP ECC6 EHP4

Windows/Oracle 10.2.0.4

tks

Re: DB02-Space Orveriew empty

Reagan — Mon, 02 Dec 2013 22:11:16 GMT

Hello

There will be a refresh icon at the top which will trugger a job called REFRESH SPACE STATISTIC:SID

Have you tried this ?

Regards

Re: DB02-Space Orveriew empty

Former Member — Tue, 03 Dec 2013 01:36:41 GMT

Hi,

Have you tried db02old transaction and does that also give the same result.

Thanks

Rishi Abrol

Re: DB02-Space Orveriew empty

former_member206552 — Tue, 03 Dec 2013 06:03:08 GMT

Go SA38 and run program RSORACUP and use the following variables

once that has completed run the job RSORACUP again with CREATE

Last execute RSORACOLR to populate DB02

Re: DB02-Space Orveriew empty

Former Member — Tue, 03 Dec 2013 13:28:04 GMT

Hi Reagan,

Yes , I performed the "REFRESH".

Note: db02old is ok.

tks

Re: DB02-Space Orveriew empty

Former Member — Tue, 03 Dec 2013 13:28:44 GMT

Hi Rishi,

In db02old is Ok.

tks

Re: DB02-Space Orveriew empty

Former Member — Tue, 03 Dec 2013 14:44:13 GMT

Tks Marius,

This solution solved my problem.

best regards