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

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

How to configure the LANFree backup using TSM in TBM AIX Platform?

What is cache hit ratio in Oracle 9i?

How to write a trigger in order to invoke a stored procedure in Oracle?

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

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

How to start Oracle services manually for Oracle database?

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

dnkreddy

 Profile Answers by dnkreddy Questions by dnkreddy

• Nov 30th, 2008

8i-materilized views, instead of triggers, support internet, granting of columns
9i-timestamp, rename of column, new datatypes, rank, dense_rank, 9i joins

Rajendra Thanekar

• Apr 29th, 2007

1)? connect internal (SVRMGR) is not supported in 9i now you can manage database with SQL*plus.2) SPfile in 9i which is not available in previous version. Helpful for those init parameter those need ...

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

How to cancel an automatic recovery in standby database?

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

Where can we see the last refreshed details of the Database (from Some other Environment Database) or Restored (from some backup)

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 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

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Sep 18th, 2008

When the session close,it will lose the data.

soumya_2003

 Profile Answers by soumya_2003 Questions by soumya_2003

• Jul 8th, 2008

The temporary tables retains data till the application referencing it, is active and running.

Answer Question  Select Best Answer

A user reports that his database is running slow, after 2 days it runs fast, what is your observation?

The tape device of datafile of 1GB, while you are taking backup to disk, a user enters and access/modifies the database, where will this data be stored?

What are the databases available in Oracle 10g & Which is efficient for application.