No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

expensive insert into wri$_adv_objspace_trend_data
Next thread: Query generating a sequence
Prev thread: Index not being used

Message Score Author Date
In my system i see : call dbms_space.auto_space...... Frans Trip May 28, 2009, 09:46
Hi, Bug No.5376783 is quite same with your issu...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Murtuja Khokhar May 28, 2009, 11:29
Solved problem by disabling the job. execute db...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Frans Trip May 28, 2009, 11:45

Follow up by mail Click here


Subject: expensive insert into wri$_adv_objspace_trend_data
Author: Frans Trip, Norway
Date: May 28, 2009, 09:46, 4018 days ago
Os info: Linux
Oracle info: 10.2.0.2
Error info: None
Message: In my system i see :

call dbms_space.auto_space_advisor_job_proc ( )#

And

insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))#

As resource consuming SQL, high disk i/o and using lots off CPU.

Are there way's to fix/tune this performance issue ?

Can it be fixed by SAP merge fix 7237154 ?

(Yes it a SAP system)
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: expensive insert into wri$_adv_objspace_trend_data
Author: Murtuja Khokhar, United Arab Emirates
Date: May 28, 2009, 11:29, 4018 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hi,

Bug No.5376783 is quite same with your issue.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: expensive insert into wri$_adv_objspace_trend_data
Author: Frans Trip, Norway
Date: May 28, 2009, 11:45, 4018 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Solved problem by disabling the job.

execute dbms_scheduler.disable('sys.auto_space_advisor_job');

We dont use space advisor info for enterprisemanager. We use the common SAP tooling for extent management.

The real problem is solved if we go to 10.2.0.4.

And yes it has to do with bug 5376783.

All users on 10.2.0.2 have this performance problem !!!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here