We already know about standby databases i.e. dataguard. Here we will learn about snapshot standby database in Oracle What is the snapshot standby database in Oracle? With 11gR, we can convert the physical standby database into a read-write database for some time and later again convert it back into physical standby mode using the snapshot …
Snapshot standby database in Oracle Read More »
We are bringing here a compilation from Must Read Top 100 Hyperion Essbase Interview Questions. 1) What is Essbase? Answer Essbase stands for Extended Spreadsheet Database. Essbase is a multidimensional database Management System(MDBMS) that provides a multidimensional database platform upon which to build Analytical Applications. Essbase products provide companies with the ability to deliver critical business …
Must Read Top 100 Hyperion Essbase Interview Questions Read More »
(1) Adop uses SID_patch service_name to connect to database (2) Adop Connects to other nodes in a multi-node setup via SSH and applies the patch ( similar to RAC patchings). It is executed by the user on the master node.It is important to enable the ssh from master node to other nodes If a node …
We all know Google Translate which can help translate from one language to another. We will explore the option to use Google functionality in Oracle plsql in the Oracle database to get the translation done. BEGINDBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => ‘google_translatorapi.xml’,description => ‘Google Translator Access’,principal => ‘SCOTT’,is_grant => true,privilege => ‘connect’);DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => ‘google_translatorapi.xml’,principal => ‘SCOTT’,is_grant => true,privilege => …
How to get the trace for Self Service Page (1) Set profile FND: Diagnostics = Yes at USER level.(2) log in to the Personal Home Page as that user and select the Diagnostics link at the top of the page.(3) Select Set Trace Level and click Go.(4)Select the desired trace level and click Save. (Trace …
We have already posted on Autotrace in Oracle, tkprof, and sql trace. Here we will be looking for the Oracle Explain Plan utility and how we can effectively use it to tune the Oracle sql statement What is Explain Plan in Oracle Oracle database internally creates a query execution plan in order to fetch the …
Explain plan in oracle Read More »
