mekshi_2kk

 Profile Answers by mekshi_2kk Questions by mekshi_2kk

• Mar 6th, 2006

Snapshots are the portion of database. Similar to views

swadhin kuamr sahoo

• Feb 12th, 2006

Snapshots are local copies of remote data.It is same as materialized views

Answer Question  Select Best Answer

pankaj singh

• Apr 13th, 2006

when u create pfile from spfile then u can give ur perticular location according to u like create pfile = 'ur specified location' from spfile ;

Aruna

• Mar 6th, 2006

This command does not change the location and path of the pfile. It changes only contents of pfile. Contents of Pfile are replaced by the contents of Spfile(in readable format).

Answer Question  Select Best Answer

Ajeet Singh

• May 23rd, 2006

 The ROLLUP is an extension to the GROUP BY caluse. the rollup operator can be used by report writes to extract statistics and summary information from results sets. the rollup operator creates g...

Ajeet Singh

• May 23rd, 2006

If this term is ROLAP-Relational Online Analytial Processing. ROLAP is a flexible architecture that scales to meet the widest variety of DSS and OLAP needs. ROLAP architecture access da...

Answer Question  Select Best Answer

roniprasan

 Profile Answers by roniprasan Questions by roniprasan

• Sep 4th, 2007

Char(size) max size upto 2000 min  1varchar2(size) max upto 4000 min 1

Answer Question  Select Best Answer

kumaresan.m

 Profile Answers by kumaresan.m Questions by kumaresan.m

• Sep 12th, 2006

before creating tablespace of non- standard blocksizeensure that buffer cache is configured for that balocksize by using this parameter db_nk_cache_size (where n is non standard blocksize)

sumitwatal

 Profile Answers by sumitwatal Questions by sumitwatal

• Aug 22nd, 2006

Answer is BLOCKSIZE....For more details Ch-11-->Managing tablespaces(Topic-Creating Non-Standard Block Sizes for Tablespaces) of the Oracle press book for OCA

Answer Question  Select Best Answer

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