on 11-12-2007 10:45 PM
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 !
Very good. I am glade you have solved your own..
THanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
use brtools to setup auto extend tables.
also do this>> stopsap and clean buffer...
Hope this will fix your problem..
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.