on 06-02-2008 9:19 AM
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...
Please check note 1002840 - No data or obsolete data in DB Space Statistic monitor and check your settings.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.