The Summary Management feature in Discoverer uses native features in the Oracle DBMS, and is therefore only available when running against the Oracle database. This feature uses the same highly scalable and reliable processing procedures within the kernel as the workbook scheduling capability and the setup for both features is similar. These procedures use standard packages in the DBMS called "DBMS_JOB".
The user ID that you intend to use to create the Summary Folders must have the following database privileges:
SELECT ON V_$PARAMETER
ANALYZE ANY (ASM)
CREATE/DROP/ALTER ANY MATERIALIZED VIEW (8.1.6+)
GLOBAL QUERY REWRITE
We will be looking on the following
* Defining Privileges Required
* Open a Business Area and Access Summary Wizard
* Running the Wizard to have Discoverer recommendation and best summaries.
* Running the Wizard to have Discoverer Administration to it him/her self.
Defining Privileges Required
Open a Business Area and Access Summary Wizard
Running the Wizard to have Discoverer recommendation and Best Summaries
Running the Wizard to have Discoverer Administration to it him/her self
Summary : Ran Summary Wizard with two options. One with Oracle Discoverer Recommendation and Implementing the Best Practise. Other option with Self Management which an Administrator can perform on his/her own.
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
Options ABANDON and RESTART adop phase=apply patches=10721639 abandon=yes Used to specify whether to restart the previous run of a...
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
Scenario You have noticed that the on the patch edition there are lot of patches applied. You did the cutover and now customer wants t...
Scenario You have been asked to apply a patch and you completed the prepare phase and apply phase. Now customer has given a downtime f...
Scenario You have been asked to apply a patch and you start with the first phase “PREPARE”. Background Customer has recently...
Cleanup Phase Drops now-redundant columns and other objects which are not required after the cutover phase. It is important that we do n...
R12.2 Highlights This release is largely focused on providing new technology stack components, new configuration options, and new syst...
FMW 11g Upgrade Master Index After upgrading Discoverer and Portal to 11g logging on the portal or discoverer results in ORA-7445 in the ...
Ready the instance for cutover Perform the final operations like Compile Invalids , Generate Derived Objects and Pre-compute DDL to be run...