When a Oracle instance is up, How can we find which parameter file (pfile or spfile) the oracle is using?

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 9th, 2009

The command given below will display 3 colums NAME, TYPE, VALUESQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile ...

Answer Question  Select Best Answer

What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact?

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Aug 11th, 2009

There are 25 Levels of Message in an Oracle Forms.How much cretical error or message is0 -- all errors or message12...25 -- don't shows anyIf we don't wannat show any error  or message to...

Answer Question  Select Best Answer

How to set the oracle from "Dedicated" to "Shared" server? What are all parameters needs to set to change the Oracle from "Dedicated" Server to "Shared" Server?

raj_java_j2ee

 Profile Answers by raj_java_j2ee Questions by raj_java_j2ee

• May 12th, 2009

1.To change from dedicated server to shared server add the following initialization parameters in the parameter file.dispatchers='(protocol=TCP)(disp=5)' max_dispatchers=150 shared_server...

Answer Question  Select Best Answer

What is the difference between Oracle Application DBA and System DBA?

napster.syed

 Profile Answers by napster.syed Questions by napster.syed

• Feb 27th, 2008

Oracle DBA is basically taking care of the database whereby Oracel Apps DBA is taking care of the database housing Oracle Apps and should be able to map the front end of Oracle Apps to the Backend tab...

Answer Question  Select Best Answer

What are Meta Links? Describe in detail

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

Metalinks - Oracle to take care of its customer to solve their technical issues. Once you get the license with oracle they wil provide you the metalink user and password, you can use it to search the ...

Answer Question  Select Best Answer

In DBMS, What is a relation?

tarpeg

 Profile Answers by tarpeg Questions by tarpeg

• Nov 30th, 2010

Relation is defined as a set of tuples that have the same attributes.

Answer Question  Select Best Answer

What is the difference between SGA_target and SGA_maxsize?

shreya_phadnis

 Profile Answers by shreya_phadnis Questions by shreya_phadnis

• Oct 1st, 2008

SGA_target if set to positive value enables automatic shared memory mgmt. with this you do not have to set memory for the 5 auto tuned memory parameters like - shread pool, large pool, Java pool, stre...

Answer Question  Select Best Answer

What type of value does a global variable support ?

Habib.Ur.Rehman

 Profile Answers by Habib.Ur.Rehman Questions by Habib.Ur.Rehman

• Apr 2nd, 2008

Global variable are forms specifice variable. it can store character value upto 255, for all usages. We can initialize it when we declare, otherwise give error if we did not assign it any value.Oracle 10g it can take upto 4000 bytes.

Answer Question  Select Best Answer

What is the function of SMON ?

sameh.ebeid

 Profile Answers by sameh.ebeid Questions by sameh.ebeid

• May 5th, 2008

perfrom instance recovery when the database is responded after instance fail

Answer Question  Select Best Answer

How to create LOV dynamically at runtime & attach to text field?

SHAHNAWAZ MUZAFFAR

• Mar 10th, 2012

We can use Dynamic LOV through assigning into a global variable and using this global variable into our sql statement.

Answer Question  Select Best Answer

How to estimate the size of a tablespace according to the size of the database size

chandubtech

 Profile Answers by chandubtech Questions by chandubtech

• Jun 30th, 2009

Select sum(bytes/1024/1024) mb from dba_data_files where tablespace_name='XXXXXX'

Answer Question  Select Best Answer

How many layers are there in the shared pool? What are they?

amahalakshmimca

 Profile Answers by amahalakshmimca Questions by amahalakshmimca

• May 13th, 2009

There are two layers in shared pool 1. Library cache2. Data Dictionary cache

Answer Question  Select Best Answer

What is the difference between pair wise & non pair wise comparison in a multiple column subquery. In which case are these used?

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Sep 30th, 2008

In pair wise comparison we write like this:"where (MGR_ID, DEPT_ID) IN (SUBQUERY)"IN non pair wise comparison we write like this:"where (MGR_ID) IN (SUBQUERY)and (DEPT_ID) IN (SUBQUERY)...

Answer Question  Select Best Answer

While creating a new user we set his password as identified globally, what does it mean?

Paramjeet Singh

 Profile Answers by Paramjeet Singh Questions by Paramjeet Singh

• Dec 12th, 2008

We dont set user's password as "identified globally". We write "identified globally" to decide user's scope.Details:In Oracle, we can create user in three ways:1. local user2. external user3. Global u...

Answer Question  Select Best Answer

Lets follow the following structure of granting priviledge..A -> B -> C -> D -> EIf we revoke priviledge from C, then what happens with D and E.

rajendra_thanekar

 Profile Answers by rajendra_thanekar Questions by rajendra_thanekar

• Oct 21st, 2008

hi, It depends upon the type of privilege you are revoking. Is it object priviledge or system priviledge. There is one major difference in the revocation of object privileges and system privileges. Wi...

Answer Question  Select Best Answer

What is the main difference between the functions of DB_BUFFER_CACHE and LIBRARY_CACHE?

sumer77

 Profile Answers by sumer77 Questions by sumer77

• Oct 24th, 2008

DB Buffer cache:  when a query is executed then server process looks for block in buffer cache. If the block is not available in buffer cache then server process reads the block from data files.L...

Answer Question  Select Best Answer

Which one gives better performance,
co-related subquery or inline views? Why?

Lakshmi84

 Profile Answers by Lakshmi84 Questions by Lakshmi84

• Aug 12th, 2009

Inline views works better than correlated subqueries in 8i. But things have changed in 9i.  This is because Oracle has changed their logic while processing a correlated  subquery.

Answer Question  Select Best Answer

How can we create control file, when it is lost?

bismita

 Profile Answers by bismita Questions by bismita

• Jan 22nd, 2009

If other files like datafile and log files are intact then take the back up of the control file to trace directory as follows. 1. Open the database in nomount mode i.e. startup nomount; 2. Take t...

Answer Question  Select Best Answer

What are Synonyms and Sequence?

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

Synonym - Giving alias of the existing database object. The need of synonym is to access the other schema objects easily.. (for Eg.. If you want to access gl_list table from GL schema object, you usua...

Answer Question  Select Best Answer

How many redo log group are there in Oracle 10g database? What are they?

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 17th, 2009

At Least 2 groups. To protect against a failure involving the redo log itself, Oracle Database allows a multiplexed redo log, meaning that two or more identical copies of the redo log can be automatic...

Answer Question  Select Best Answer