Home » RDBMS Server » Performance Tuning » dbms_advisor
dbms_advisor [message #244711] Wed, 13 June 2007 20:59 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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.
Re: dbms_advisor [message #244904 is a reply to message #244713] Thu, 14 June 2007 09:32 Go to previous messageGo to next message
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?

Re: dbms_advisor [message #244924 is a reply to message #244904] Thu, 14 June 2007 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
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
Re: dbms_advisor [message #244976 is a reply to message #244924] Thu, 14 June 2007 14:43 Go to previous messageGo to next message
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
Re: dbms_advisor [message #244979 is a reply to message #244976] Thu, 14 June 2007 14:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
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

Re: dbms_advisor [message #244980 is a reply to message #244711] Thu, 14 June 2007 15:06 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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
Re: dbms_advisor [message #245294 is a reply to message #244980] Fri, 15 June 2007 14:44 Go to previous messageGo to next message
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
Re: dbms_advisor [message #245306 is a reply to message #245294] Fri, 15 June 2007 15:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
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
Re: dbms_advisor [message #245744 is a reply to message #245306] Mon, 18 June 2007 12:47 Go to previous message
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
Previous Topic: UPDATE DATE AND TIME OF TABLE
Next Topic: Rebuild index online
Goto Forum:
  


Current Time: Wed Dec 07 02:38:47 CST 2016

Total time taken to generate the page: 0.08899 seconds