Hiya Buddies!!!
$grep login $CONTEXT_FILE
It is very easy steps to submit the concurrent
request for Gather Schema Statistics from front-end.
So, we would like explain here as How to run
concurrent program Gather Schema Statistics.
1. We need to login EBS (Oracle Applications)
front-end url as SYSADMIN user and Responsibility as System Administrator
If you are not sure about EBS url, you can login to
back-end host and follow below
Steps:
Steps:
$hostname;id
ebs.oracle.com;applmgr
$. ./APPSEBS_ebs.env
$echo $TWO_TASK
EBSPROD
$grep login $CONTEXT_FILE
<you will get the ebs url as output...>
2. Here, we need to submit a Request, follow
navigation as shown below:
Navigate to:
Request > Run.
In Name: Select as : Gather Schema Statistics
i.e. Press "f11" then type "Gather
Scehma Statistics" thne Press "CTRL and F11" together.
You will get a pop-up with some options such as
Schema Name, Estimate_percent, Degree etc...
3. Enter the appropriate parameters. This can be
run for specific schema's by specifying the schema name or entering 'ALL' to
gather statistics for every schema in the database.
4. Submit the gather schema statistics program.
Estimate_percent
Percentage of rows to estimate. If you left empty
it will take by default to 10%.
The valid range is 0-99. A higher percentage will
be more accurate, but it will take longer time to run.
Degree
Here, we enter the Degree of parallelism. If we do
not enter, it will take by default values to like min(cpu_count,
parallel_max_servers).
And modifying the degree of parallelism on a table
can cause the plan to change.
In a easy language, increasing the degree of
parallelism is likely to make full table scans appear cheaper and more
attractive
while reducing it will make Full Table Scans look
less attractive.
Example which we have done...
Degree - 4
% (percentage) - 40
Some more useful links:
Thanks...
TechorNontech
Team
No comments:
Post a Comment