You upgrade your Oracle database in a multiprocessor environment. As a recommended you
execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?
A.
Parallel compilation of only the stored PL/SQL code
B.
Sequential recompilation of only the stored PL/SQL code
C.
Parallel recompilation of any stored PL/SQL code
D.
Sequential recompilation of any stored PL/SQL code
E.
Parallel recompilation of Java code
F.
Sequential recompilation of Java code
Explanation:
utlrp.sql and utlprp.sql
The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in thedatabase. They are typically run after major database changes such as upgrades or patches. They
are located in the $ORACLE_HOME/rdbms/admin directory and provide a wrapper on the
UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql script with a command line
parameter of “0”. The utlprp.sql accepts a single integer parameter that indicates the level of
parallelism as follows.
0 – The level of parallelism is derived based on the CPU_COUNT parameter.
1 – The recompilation is run serially, one object at a time.
N – The recompilation is run in parallel with “N” number of threads.
Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly.
Reference: Recompiling Invalid Schema Objects
http://docs.oracle.com/database/121/LADBI/post_inst_task.htm#LADBI7750
“This script recompiles all PL/SQL modules that are in an invalid state, including packages, procedures, and types.”
Look at utlrp.sql script it only call
@@utlprp.sql 0
from utlprp.sql header:
Rem The degree of parallelism for recompilation can be controlled by
Rem providing a parameter to this script. If this parameter is 0 or
Rem NULL, UTL_RECOMP will automatically determine the appropriate
Rem level of parallelism based on Oracle parameters cpu_count and
Rem parallel_threads_per_cpu. If the parameter is 1, sequential
Rem recompilation is used.
Ans C,D
C,E
https://docs.oracle.com/cloud/latest/db121/UPGRD/upgrade.htm#UPGRD60130
utlrp.sql to recompile any remaining stored PL/SQL and Java code
Just beneath, are numerous absolutely not connected web pages to ours, on the other hand, they may be certainly really worth going over.
Here are a few of the web sites we advocate for our visitors
that will be the end of this article. Here youll uncover some web sites that we consider youll appreciate, just click the hyperlinks over
the time to read or visit the content material or web-sites we’ve linked to below the
we like to honor a lot of other web web pages on the internet, even if they arent linked to us, by linking to them. Below are some webpages worth checking out
please pay a visit to the websites we adhere to, which includes this one particular, because it represents our picks in the web
we like to honor numerous other internet web pages around the internet, even when they arent linked to us, by linking to them. Beneath are some webpages really worth checking out
we came across a cool website which you could appreciate. Take a look for those who want
please check out the web sites we stick to, including this 1, because it represents our picks through the web
here are some links to internet sites that we link to mainly because we feel they may be really worth visiting
very few web sites that take place to become detailed below, from our point of view are undoubtedly nicely really worth checking out
just beneath, are numerous absolutely not related websites to ours, having said that, they are surely really worth going over
check below, are some entirely unrelated internet websites to ours, nevertheless, they may be most trustworthy sources that we use
here are some links to web pages that we link to because we consider they are worth visiting
Here is a great Weblog You might Come across Interesting that we Encourage You
always a major fan of linking to bloggers that I really like but really don’t get lots of link appreciate from
we prefer to honor a lot of other online internet sites around the net, even if they arent linked to us, by linking to them. Underneath are some webpages worth checking out
one of our guests not long ago suggested the following website
Here are some of the web pages we advocate for our visitors
Wonderful story, reckoned we could combine some unrelated data, nonetheless seriously really worth taking a look, whoa did a single learn about Mid East has got more problerms as well
always a big fan of linking to bloggers that I love but really don’t get a great deal of link enjoy from
Sites of interest we’ve a link to
CE