OraFAQ Forum: Performance Tuning » dbms

Home » RDBMS Server » Performance Tuning » dbms_advisor

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_advisor [message #244711]

Wed, 13 June 2007 20:59

adee_saleh
Messages: 30
Registered: May 2007
Location: Yemen

Member

i need help for this problem please as fast as possible

i just want to know what is wrong with this code because it always give me the same error as the following

declare
begin_snap number;
end_snap number;
BEGIN
SELECT max(snap_id)INTO begin_snap FROM DBA_HIST_SNAPSHOT
WHERE trunc(end_interval_time, 'MI') <= TO_DATE('10:10 (06/05)',
'HH24:MI (MM/DD)');
SELECT min(snap_id) INTO end_snap FROM DBA_HIST_SNAPSHOT
WHERE end_interval_time <=TO_DATE('10:10 (06/10)',
'HH24:MI (MM/DD)') ;
DBMS_ADVISOR.create_task (
advisor_name => 'ADDM',
task_name => '9700_1032_AWR_SNAPSHOT',
task_desc => 'Advisor for snapshots 970 to 1032.');
DBMS_ADVISOR.set_task_parameter (
task_name => '9700_1032_AWR_SNAPSHOT',
parameter => 'START_SNAPSHOT', value => begin_snap);
DBMS_ADVISOR.set_task_parameter (
task_name => '9700_1032_AWR_SNAPSHOT',
parameter => 'END_SNAPSHOT',value=> end_snap);
DBMS_ADVISOR.execute_task(task_name => '9700_1032_AWR_SNAPSHOT');
end;

ORA 13709: ??? ????? ??????? ???????? "START_SNAPSHOT" ??? ???????.
ORA-06512: ??? "SYS.PRVT_ADVISOR", line 1283
ORA-06512: ??? "SYS.DBMS_ADVISOR", line 186
ORA-06512: ??? line 1

[Updated on: Wed, 13 June 2007 21:02]

Report message to a moderator

Re: dbms_advisor [message #244713 is a reply to message #244711]

Wed, 13 June 2007 21:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Are you unwilling or incapable of following the posting guidelines enumerated in the #1 Sticky post at the top of this forum?

You're On Your Own (YOYO)!

13709, 00000, "Required parameter \"%s\" must be set before execution."
// *Cause:  The parameter needs to be set before running the ADDM
// *Action: Set the parameter to a valid value and retry.

Report message to a moderator

Re: dbms_advisor [message #244904 is a reply to message #244713]

Thu, 14 June 2007 09:32

adee_saleh
Messages: 30
Registered: May 2007
Location: Yemen

Member

actully it seems that i have serous problem in the language setting of my computer.
but can you explain to me what is that parameter required and how can i use it in order to execute my commands correctly?

Report message to a moderator

Re: dbms_advisor [message #244924 is a reply to message #244904]

Thu, 14 June 2007 10:41

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe you should read a bit about DBMS_ADVISOR before using it?

Regards
Michel

Report message to a moderator

Re: dbms_advisor [message #244976 is a reply to message #244924]

Thu, 14 June 2007 14:43

adee_saleh
Messages: 30
Registered: May 2007
Location: Yemen

Member

maybe i don't have full information about dbms_advisor but i read about it and i think that i know something good about it.
but i can't really understand know what is this parameter mean and what should i do to solve the above errors.
please its about my project and i don't have time for further read
all i want to know is how to get that code executed correctly

with my regards
Adee

Report message to a moderator

Re: dbms_advisor [message #244979 is a reply to message #244976]

Thu, 14 June 2007 14:57

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I just type START_SNAPSHOT in the search field of Oracle documentation and get 3 hits.

Quote:

Setting the required parameters to run a specific type of task, such as START_SNAPSHOT and END_SNAPSHOT parameters, using DBMS_ADVISOR.SET_TASK_PARAMETER. Valid parameters for an ADDM task include:

START_SNAPSHOT (mandatory)

...

Quote:

The analysis is based on Automatic Workload Repository snapshots, which you must specify by setting parameters START_SNAPSHOT and END_SNAPSHOT. In the following example, ...

Quote:

START_SNAPSHOT ... The starting time for the system to perform analysis using the snapshot numbers in the AWR repository.

I think you don't search or read many things.

Regards
Michel

Report message to a moderator

Re: dbms_advisor [message #244980 is a reply to message #244711]

Thu, 14 June 2007 15:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

As in MANY/MOST cases a working example can be found on http://asktom.oracle.com

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:12257624552691

Report message to a moderator

Re: dbms_advisor [message #245294 is a reply to message #244980]

Fri, 15 June 2007 14:44

adee_saleh
Messages: 30
Registered: May 2007
Location: Yemen

Member

actully i don't get it i repeated the read and repeated the check of the code and nothing wrong i gusee.
you can see similar of this code in Oracle documentation.
any way thanks for everything

with my regards
Adee

Report message to a moderator

Re: dbms_advisor [message #245306 is a reply to message #245294]

Fri, 15 June 2007 15:36

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you sure you end_snap is less than your begin_snap.
Maybe we would have a look at your code if you have formatted it.

How to format your posts

Regards
Michel

Report message to a moderator

Re: dbms_advisor [message #245744 is a reply to message #245306]

Mon, 18 June 2007 12:47

adee_saleh
Messages: 30
Registered: May 2007
Location: Yemen

Member

hey thank you very much
i make full checking to everything in dbms_advisor and checked all the snapshots and you will do you what happend
it seems that the date and time that specified is not exist Embarassed

I am sorry
but what i want to say that i want to thank you very much that you really helped me and you make me checking back everything without showing bothering from my questions
i really apreciate that
with my regards
Adee

Report message to a moderator

Previous Topic:	UPDATE DATE AND TIME OF TABLE
Next Topic:	Rebuild index online

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 23:09:58 CDT 2024