Rule based optimization in Oracle Apps
Explain rule based optimization in Oracle AppsMore than a decade ago, all Oracle databases used what is now called rule-based optimization, which uses a fixed strategy to optimize a query's results. For example, if a table had a unique index and the columns were fully qualified, the table would become the driving table for the rest of the query--regardless of the number of rows in each table.
|
Profile option “Node Trust LevelIf this profile option is set to some external value against a server, then it
signifies that the specific middle tier is External......
Role of Document ManagerTo receive pipeline signal from the application on made request. Document
Manager Functionality comes within Oracle Universal Content Management (UCM).......