In this post,I would be talking about Oracle views which is used quite heavily in various application for security and complexity reason.I would be listing complete life cycle of Oracle view i.e How to create view in oracle,Oracle create view example,how to alter view in oracle,How to compile view in oracle,How to drop view in […]
How to create view in oracle Read More »
Suppose you want to remove the optimizer preference you set on the schema, table, or database, then the below procedure can be used to do that How to delete table level Optimizer preference The DBMS_STATS.DELETE_TABLE_PREFS procedure is used to delete the statistics preferences of the specified table in the specified schema. Example exec DBMS_STATS.DELETE_TABLE_PREFS (
How to delete Optimizer preference Read More »
Here is the list of Oracle Apps DBA interview questions, I expect Apps DBA to know Question 1. I am applying a patch using adpatch, can I open another session and run adadmin? Answer Yes, We can run unless you are running a process where workers are involved Question 2. I am applying a patch,
Oracle apps dba interview questions Read More »
Sometimes, we may need to set the optimizer statistics preferences at the table level. We will check in detail about it How to set table level preference setting The DBMS_STATS.SET_TABLE_PREFS procedure is used to set the statistics preferences of the specified table in the specified schema. Syntax DBMS_STATS.SET_TABLE_PREFS ( ownname IN VARCHAR2, tabname IN VARCHAR2,
How to set table level preference setting Read More »
Suppose you want to set up method_opt preference for the schema, then the below procedure can be done to set it up The DBMS_STATS.SET_SCHEMA_PREFS procedure is used to set the statistics preferences of all the tables owned by the specified owner name. DBMS_STATS.SET_SCHEMA_PREFS (ownname IN VARCHAR2,pname IN VARCHAR2,pvalue IN VARCHAR2) Example exec DBMS_STATS.SET_SCHEMA_PREFS(‘SCOTT’, ‘method_opt’,’for all
How to set Schema level preference setting Read More »
Java is a high-level, class-based, object-oriented programming language that is designed to have as few implementation dependencies as possible. It was developed by Sun Microsystems (now owned by Oracle Corporation) and released in 1995. Java applications are typically compiled to bytecode that can run on any Java Virtual Machine (JVM), regardless of the underlying computer
How to check the java version in Unix & Windows Read More »
