vigneshkumar

 Profile Answers by vigneshkumar Questions by vigneshkumar

• Feb 16th, 2007

The large pool is created to avoid contention in the shared pool in the case of shared server environment..The UGA process takes place in the shared pool in the case of shared server environment..so to avoid contentions all the user processes are shifted to the large pool..

Answer Question  Select Best Answer

Asad

• Jul 30th, 2007

Index are reference to data in tables's columns on what they are based. Index work exactly in way? like we have book's index describing its chapters and what page # chapter can be found.They only con...

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

When you execute query oracle checks for various things syntax, access and then generate optimize plan and in this stage parsing happens. when the query plan is already there in sga you get hit and that is soft parsing..else hard1. Soft parsing2. Hard parsing

Answer Question  Select Best Answer

The ORACLE db is running with session audit and the audit table is full. What happens to new sessions? Nothing, They are not audited New Connections are Not Allowed Session allowed, with audit to alert.log None of the above recordWhich of the following statements is valid? ALTER SESSION SET CONSTRAINTS=TRUE ALTER SESSION SET CONSTRAINTS = DEFERRED ALTER SESSION SET CONSTRAINTS = FORWARD None of the...

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

What is this ? Please post individually

Answer Question  Select Best Answer

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Aug 11th, 2009

There are three types of conversions 1-  TO_DATE2-  TO_CHAR3-  TO_NUMBERTO_DATE:use to convert charector into data by giving format mask.TO_CHAR:use to convert number into cha...

Answer Question  Select Best Answer

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

You can useselect * from all_tables where owner like 'GL'

Answer Question  Select Best Answer

Mudit Sharma

• Oct 27th, 2007

-?? A cluster is a set of 2 or more machines (nodes) that share or coordinate resources to perform the same task. ??????? - A RAC database is 2 or more instances running on a set of clustered...

Answer Question  Select Best Answer

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

Steps to Apply Patches1. Download & Unzip the patch (based on OS and If translation required download) 2. Read the README.txt and carefully observe the pre-requesite for applying patches, carry ou...

Answer Question  Select Best Answer

Catalina

• Sep 25th, 2007

It seems that, if the main query selects from a great number of rows, than Oracle will have a better execution plan if you use EXISTS. If the main query selects from a small number of rows, while...

Answer Question  Select Best Answer

My database size is 80GB

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

Setting of SGASGA 55% of Physical RAMShared_Pool_size 45% of SGADb_buffer_cahe 45% of SGALog_buffer  10% of SGA

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

New Feature of Oracle 10g1.Introduction of sysaux tablespace.2.Temporary tablespace grouping.3.Retention guarantee in undo tablespace.4.Introduction of transportable tablespace.5.Introduction of datap...

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

Yes, It can.create database link connect to XX identified by XX ;Database link created.

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

Database Block Gets: Finding matching data block in database buffer cache. Consistent Gets: When data need to fetch are valid or available in buffer. It means data are not being modified when again...

Answer Question  Select Best Answer

arnab

• Nov 20th, 2007

Some objects are stored in the database and can be created and manipulated with SQL but are not contained in a schema. Its called non schema object. Non schema objects are given below:- Contexts D...

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 17th, 2009

Nope I think , and you dont require also. If MAXINSTANCES is greater than the number of free list groups in the table or cluster, then an instance number maps to the free list group associated with. I...

Answer Question  Select Best Answer

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