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

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

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

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

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

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

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

In which format redo log files stores the changes ?

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 17th, 2009

Good Question. They are not stored in binary format , but in sql.

dheerajdba

 Profile Answers by dheerajdba Questions by dheerajdba

• Aug 7th, 2008

Binary-format

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

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

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

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

1. Checking from O/S levelps -ef | grep pmon2. Checking through connectivitysqlplus apps/apps3. Checking the listener. (Listener can run even without DB startup) but without listener we cant connect to DB from outside of server.

shubhendu_gupta

 Profile Answers by shubhendu_gupta Questions by shubhendu_gupta

• Sep 24th, 2007

ReshmaAt OS level you can check for Oracle background process (SMON, PMON) are running or not using the Unix command (ps -ef)Eg:1) ps -ef |grep smon2) ps -ef |grep pmonYou can check for your listener also like this ps -ef |grep -i listener

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

Can we create tablespace without segments if yes then how?

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

For what reason you want to create tablespace without segments. Answer is no

Answer Question  Select Best Answer

Explain what are system tablespace and default tablespace? How do they differ from one another?

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

System for oracle oracle metadata and default for when you create any user without providing any default tablespace clause will use this tablespace for objects

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

System Tablespace is the default tablespace for Oracle Database where it will store all the database dictionaries and DB related TablesWhereas Default tablespace is the tablespace created for each user.

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

How to convert dictionary managed tablespace to locally managed tablespace?

mohibalvi

 Profile Answers by mohibalvi Questions by mohibalvi

• Mar 14th, 2009

You can use DBMS_SPACE_ADMIN package to convert DMT to LMT. exec dbms_space_admin.Tablespace_Migrate_TO_Local('ts_dm');where ts_dm is the name of tablespace that need to be converted to locally managed tablespace.

Answer Question  Select Best Answer

When we trace the control file how many datafiles are created?

mbreddy5

 Profile Answers by mbreddy5 Questions by mbreddy5

• Mar 16th, 2009

No data files are created when we trace a control file. Tracing will create a word format of control file with all the information of data base (datafiles, log switching etc).

Answer Question  Select Best Answer