Tuesday 4 June 2013

How to execute mscplan.sql file?

Metalink id:
======
mscplan.sql to Retrieve Plan Parameters [ID 259907.1].

Description from user side in ticket.
Could you please provide output of the script mscplan.sql and run it on ascp production ebsoltp2 instance.ASCP Production means where your plans run.Please run the script two times and select plan id 1 and 4 and provide the ouput for the same.

1)Download file from support.oracle.com
2)Move the file to server
3)Connect to database as apps schema and run it.
4)Provide ouput to the user.
SQL> @mscplan10.sql

===The following are the available plans in this instance:=====

Plan Name Plan ID
---------- ----------
Collection -1
INTER-OP 2022
OPER-BACK 1022
OPERATION 4
TACTICAL 1

Please enter Plan Name: TACTICAL



SQL> @mscplan10.sql
===The following are the available plans in this instance:=====

Plan Name Plan ID
---------- ----------
Collection -1
INTER-OP 2022
OPER-BACK 1022
OPERATION 4
TACT-BACK 2
TACTICAL 1

Please enter Plan Name: OPERATION
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$

It will generate two files give it to user.
mscplan10_23052013_0538_diag.txt and mscplan10_23052013_0528_diag.txt.

No comments:

Post a Comment