DBAcockpit - Oralce 10g - Space - Overview - Stats all zero 1

[Former Member]

Hi,

We are running Solution Manager 4.0 SP13 on Oracle 10.2.0.2 patch 16.

When we run transaction dbacockpit.

We highlight the SPACE Overview for the Local ( default ) database - size=0, free space = 0...

ALL the stats for tablespaces, size, etc are all zero !!!!

In transaction DB17 all the Database check conditions are marked.

The job SAP_COLLECTOR_FOR_PERFMONITOR runs every hour - RSCOLL00

The table TCOLL has the entry rsoracol.

The table ORA_MON_DBCON has CON_NAME = default database

Due to applying patch 16 we have ran - brconnect -u / -c -f stats -t oradict_stats

We decided to increase a tablespace and the ran - brconnect -u / -c -f stats -t system_stats

However if we run the old transaction DB02OLD, all the database performance, tables and indexes stats are available.

We can run - DB02OLD - Current Sizes - DB Analysis - refresh - perform DB checks - that Tablespace Stats are updated !

Please Help !

[Former Member]

Very good. I am glade you have solved your own..

THanks,

[Former Member]

Hi,

use brtools to setup auto extend tables.

also do this>> stopsap and clean buffer...

Hope this will fix your problem..

Thanks,

[Former Member]

Thanks for the response,

The Tablespaces are set to auto extend.

The structure of the Database and tablespaces are Local managed as apposed to Dictionary mananaged. Because it was a new install of Netweaver 2004s the new SAP Standard layout with a single large tablespace, PSAP<SAPSID> has been applied.

If anyone wants that info see below:

http://help.sap.com/saphelp_nw70/helpdata/en/11/06a53fa6503c17e10000000a114084/frameset.htm

However this dos not fix the problem.

[Former Member]

I eventually fixed the problem.

Here is the fix:

Database = Oralce 10.2.0.2 Patch 16 ( patch 15 should be OK aswell)

SAP Netweaver 2004s SP12 or SP13

Run DbaCockpit - System configuration - Active System = 1( for Local database) -click On Default System - ( the Bottom Message Wiindow Will "pop" telling you what system is default )

Run Transaction DB17 and ensure all Conditions are active.

Run Transaction SM36 and Schedule Job SAP_COLLECTOR_FOR_PERFMONITOR to run every hour - (RSCOLL00)

Run se16 - table = TCOLL - Table of Contents ( F7 ) - ensure it has the entry rsoracol.

Run SE38 - RSORACUP - execute - CON_NAME = DEFAULT - OPERATIO = CREATE - execute

Run SE16 - table = ORA_MON_DBCON - table of Contents - ( leave all options blank ) - execute - the result will be similar to below:

CON NAME DEFAULT

STATUS A

MAX RUNTIME 1.800

MAX UPLOAD 1.000.000

LOG LIFE 100

DESCRIPTION Local R/3 Database

run SE16 - Table= DB02_COLL_PLAN - Table of Contents (F7) - Leave all entries blanke - Execute - Results will have found around 60 to 65 modules (the exact number depend on your R/3 release/patch) per DB connection - example of one of the entries below:

CON NAME DEFAULT

SMON ID 100

SMON NAME DB-GE-MD

FUNCNAME ORA_COLL_DB_GENERAL_MAIN_DATA

MONIFILL DEF100

RANK 2

STATUS A

SCH DATE XXXXXXX

SCH TIME X X

PROCESS TYPE S

Run transaction dbacockpit - Jobs - dba planning calender - action pad - check database - run immediately - Let job complete - highlight and check log

Run se16 - table = DB02_COLL_LOG = table of contents ( F7 ) - Leave all fields blank - Execute - page down and you will see a number of entries similar to the following:

COLL DATE 15.11.2007

COLL TIME 07:57:19

CON NAME DEFAULT

SMON ID 901

SMON NAME AD-GE-CM

MONIFILL DEF901

RCODE 0

UPLOAD 10

DURATION 1

Run transaction - dbacockpit - space - bouble click sapce overview - in the right hand pane you will see size - freespace - etc etc.

For further inforamtion note number: 1002840 ( Specifically steps 4 and 5 ) If stats not updated .. run the SAP_COLLECTOR_FOR_PERFMONITOR job - repeat steps 4 and 5 in the note and run the dba planning job check Database.

Run DBACockpit