Pooja Agrawal

• Nov 22nd, 2006

Additionally,PGA_Aggregate_target set when Work_area_policy is set to auto and FAST_START_MTTR_Target set may also affect d/b performance

Ratna Kumari

• Aug 2nd, 2005

These are the Parameters for init.ora  DB_BLOCK_BUFFERSSHARED_POOL_SIZESORT_AREA_SIZEDBWR_IO_SLAVESROLLBACK_SEGMENTSSORT_AREA_RETAINED_SIZEDB_BLOCK_LRU_EXTENDED_STATISTICSSHARED_POOL_RESERVE_SIZE

Answer Question  Select Best Answer

Pooja Agrawal

• Nov 22nd, 2006

Database link is a schema object in one database to access objects in another database. When you create database link with Public clause, it is available for access to all the users, and if you omit this clause, then database link is privat and available only to you.

Rani Rathna

• Jul 9th, 2005

You can create a public database link for a database. All users and PL/SQL subprograms in the database can use a public database link to access data and database objects in the corresponding remote da...

Answer Question  Select Best Answer

Pooja Agrawal

• Nov 22nd, 2006

The uses of Roll Back Segment are :1. Transaction Rollback2. Transaction Recovery3. Read Consistency

sri

• Aug 4th, 2005

The use of RollBack Segment is Database is - to maintain read consistency between multiple transactions.

Answer Question  Select Best Answer

paparao03

 Profile Answers by paparao03 Questions by paparao03

• Nov 3rd, 2006

.ora files contain Oracle Engine papameters info.net files contain O.S engine parameter info

Answer Question  Select Best Answer

paparao03@gmail.com

• Oct 31st, 2006

Query Rewrite option advantages we can get with the materialize view option also.

paparao03@gmail.com

• Oct 27th, 2006

I am agree with above(sheela) comments.along with It is more usedful OPTIONS LIKE FAST, COMPLETE, FORCE, WITH THE HELP OF MATERIALIZED VIEW LOG IS MORE USEFUL.

Answer Question  Select Best Answer

Tony

• Oct 25th, 2006

Thanks for the information!

Chinny

• Sep 28th, 2006

Sharedpool contains 3 memory layers.1.Library cache: 2.Data dictionary cache3.UGA

Answer Question  Select Best Answer

paparao

• Oct 23rd, 2006

Exatly upto 512 peta bytes ( refer to Oracle Database Concenpts manual).

frmchandan

 Profile Answers by frmchandan Questions by frmchandan

• Aug 9th, 2006

This answer is Perfect you have repliedThe holding capacity of 9i is 500PB

Answer Question  Select Best Answer

wendyliu

• Oct 18th, 2006

Use nid utility.

Amit

• May 7th, 2005

You can change Database my by simple do some steps.  1. Alter Database backup control file to trace; 2. Above step will create a text control file. 3. Change the Database name ther...

Answer Question  Select Best Answer

ajexpert

 Profile Answers by ajexpert Questions by ajexpert

• Jul 29th, 2006

Clusters are optional method of storing table data.  A cluster is group of tables that share same data  blocks because they share common columns and often use together.

sri

• Aug 4th, 2005

Groups of tables physically stored together because they share common columns and are often used together is called clusters

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

PUBLIC DATABASE LINKPRIVATE DATABASE LINK

Rani Rathna

• Jul 9th, 2005

You can create a private database link in a specific schema of a database. Only the owner of a private database link or  PL/SQL subprograms in the schema can use a private database link to access...

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

DBMS_METADATADBMS_STATSDBMS_SUPPORTDBMS_SESSION

akebono

• Aug 26th, 2005

 DBMS_OUTPUT.PUT_LINE('strings'); print out the strings  DBMS_UTILITY.get_time() get the current time  DBMS_ALERT e.g begin dbms_alert.register('myregister'); end  to register interst in a named alert   

Answer Question  Select Best Answer

select segment_name,sum(bytes) from dba_segmentswhere segment_name='TABLE_NAME' AND OWNER='OWNER of the table'group by segment_name

satish penugonda

• Jul 7th, 2006

And adding to the previous...view are not physical entities like tables which occupy space in the database..they are logical and whenever you select, the query underlying the view gets fired and results are returned. Hence, you cannot get the space information for views

Answer Question  Select Best Answer

ritesh raj singh

• Jul 4th, 2006

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM?...

Answer Question  Select Best Answer

These are a few of the advantages of using DBCA:You can use its wizards to guide you through a selection of options providing an easy means of creating and tailoring your database. It allows you to provide varying levels of detail. You can provide a minimum of input and allow Oracle to make decisions for you, eliminating the need to spend time deciding how best to set parameters or structure the database....

oradba

• Apr 6th, 2006

The Database Configuration Assistant guides you through the process of creating a new database, changing the configuration of an existing database, or deleting a database. Many of the database creatio...

Answer Question  Select Best Answer

Radha B S

• Mar 15th, 2006

Srinivas reddy Wrote: 1. Dynamic Memomry Management  2. Default tablespace at the db levele  3. temporary tablespace at the dba level 4. Undo tablespace managemnet (auto/manual)

srinivas reddy

• Mar 25th, 2005

1. Dynamic Memomry Management  2. Default tablespace at the db levele  3. temporary tablespace at the dba level 4. Undo tablespace managemnet (auto/manual)

Answer Question  Select Best Answer

innovative

 Profile Answers by innovative Questions by innovative

• Feb 20th, 2006

tablespaces are the logical constructs which are group of datafiles. a datafile belongs to one database. in laymans language we can say that tablespaces are like folders in windows environment. as we ...

Gurmeet Singh

• Feb 13th, 2006

Use of tableapce in oracle are:1) we can assign different quotas to the user of databasae2)we can take a part of database unavailable from the user3)we can create a object which have block size different from standard block size4) we can take backup of part of the database

Answer Question  Select Best Answer

krisna

• Feb 3rd, 2006

NO we can't create index on long raw column.

Answer Question  Select Best Answer

Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for a very specific purpose.A virtual index is created in a slightly different manner than the normal indexes. A virtual index has no segment pegged to it, i.e., the DBA_SEGMENTS view will not show an entry...

sheela

• Sep 7th, 2005

Function-based indexes can use any Function or Object method that is declared as repeatable. Queries using expressions can use the index. Ex:- CREATE INDEX sales_margin_inx  ON ...

Answer Question  Select Best Answer

Shrikant Pande

• Aug 24th, 2005

Yes : Schema objects can stored in different tablespace and a tablespace can contained one or more schema objects data.

sandeep

• Jul 4th, 2005

Yes , it can .  for example if you specify a different tablepace (B) for indexes, the indexes of the tables that the user create would be residing in B , and the table would reside in the user's default tablespace A. Rgds Sandeep Kurian

Answer Question  Select Best Answer