What is Active Dataguard in Oracle Operations which are Allowed On a Read-Only Database(Active Dataguard in Oracle) (1)Issue SELECT statements, including queries that require multiple sorts that leverage TEMP segments(2) Use ALTER SESSION and ALTER SYSTEM statements, Use SET ROLE(3)Call stored procedures(4) Use database links (dblinks) to write to remote databases(5) Use stored procedures to …
Active Dataguard in Oracle Read More »
What is Foreign key Foreign key in Oracle is a way to relate multiple Tables. It is a cross-linking between the tables. A foreign key is a column or set of column which refers to the primary key or Unique key in the same table or another table Foreign key values are based on data …
Object dependency is important to understand in Oracle. It basically tells the parent-child relationship between the objects. Let’s understand with an example. We create one table CREATE TABLE DEPT_MASTER ( dept_nr NUMBER UNIQUE, dept_name varchar2(100) NOT NULL, dept_status NUMBER(1,0) NOT NULL, created_at date ); Right now this table is alone and it is not dependent …
Many times, we may need to check the data stored in the blob field in the table. If you just do select, it will not give you proper output. Here are some of the ways on How to select blob from table Using sqlplus select BLOB_FIELD from <table name> where ID = ‘<row id>’; SELECT …
AUD$ table is used in oracle to store the auditing information. Auditing can be enabled for CREATE SESSION, LOGON, LOGOFF, SELECT, INSERT, DELETE statement You can enable auditing only when the AUDIT_TRAIL parameter is set to either DB or DB_EXTENDED value. You can check the parameter value as sqlplus / as sysdbashow parameter AUDIT_TRAIL 11g …
Oracle Apps DBA has too often troubleshoot various issues. I am giving here the Top 30 Useful oracle apps queries for DBA how to find form session id in oracle The below query will provide the session details for all the forms opened in the applications set linesize 1000 column username format a8 heading “User|Name” …
Oracle apps queries for APPS DBA Read More »
