cancel
Showing results for 
Search instead for 
Did you mean: 

DB02 is empty , no data there why?

Former Member
0 Kudos

Hi Experts,

T-Code DB02 doesn't have any statistics related to space

i mean it is empty no data.

SAB_Basis 700 sp 13 my database is Oracle10g

i don't know the reason

Thanks

Sh...

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

Please check note 1002840 - No data or obsolete data in DB Space Statistic monitor and check your settings.

Markus

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks Guys,

Note 1002840 solved the problem

steps:

1- standard job SAP_COLLECTOR_FOR_PERFMONITOR is scheduled hourly at 0'oclock i mean 9:00 , 10:00 , 11,00 ...

2-tabe ORA_MON_DBCON should contain 1 record as

CON NAME DEFAULT

STATUS A

MAX RUNTIME 1.800

MAX UPLOAD 1.000.000

LOG LIFE 100

DESCRIPTION Local Oracle database

3-table DB02_COLL_PLAN should contains entries

if 2 or 3 not happen so do as follow

-call report RSORACUP from SE38 with parameter:

CON_NAME = DEFAULT

OPERATIO = DELETE

then call it again with

CON_NAME = DEFAULT

OPERATIO = CREATE

after that 2 & 3 will contains entries.

Thatnks

Sherif

Former Member
0 Kudos

Hi Sherif

SAP is changing the DBA transactions, with SP13 you are somewhere in beetween the old transanctions (DB02/ST04/DB13) and the new one (DBACOCKPIT). In your case all need to do might to run SE38 -> RSORACUP -> Execute, then CON_NAME: DEFAULT and OPERATIO: CREATE.

After a while you might see data in DB02 again, but be prepared that not everything will work, because there are a LOT of corrections for SP13 out there.

There is quite a lot of useful notes, you can start with this one: 1028624 - Overview of DBA Cockpit for Oracle

Regards Michael

Former Member
0 Kudos

Hi,

check whether background job SAP_COLLECTOR_FOR_PERFMONITOR running successfully or not.

check Note 966309 - Contents of table TCOLL in SAP_BASIS 700

regards,

kaushal