What is an Oracle Instance? Where it is present and How does it perform?

prajwal.achar

 Profile Answers by prajwal.achar Questions by prajwal.achar

• Jul 15th, 2009

Oracle Instance is a memory component of Oracle server which is a combination of memory structure and background processes..It is a means to access data in a database i.e., it is a path way to access data.

Answer Question  Select Best Answer

How to detect and prevent row chaining?

Nehasinha

 Profile Answers by Nehasinha Questions by Nehasinha

• Jul 15th, 2009

By increasing the PCT, Row chaining can be avoided.

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

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

Increate the size of database buffer cache.OrSet parameter pre_page_sge=trueThe main adventage is, all pages are touth to physical memory.The main disadvantages is, it create more active pages & more time to make connect.

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

How to estimate the size of a tablespace according to the size of the database size

chandubtech

 Profile Answers by chandubtech Questions by chandubtech

• Jun 30th, 2009

Select sum(bytes/1024/1024) mb from dba_data_files where tablespace_name='XXXXXX'

Answer Question  Select Best Answer

parveshdata

 Profile Answers by parveshdata Questions by parveshdata

• Jun 26th, 2009

Use show sga to know all the important parameters that are there for you by default setting of oracle or may be DBA has set at the time of installing the database in your init.ora or sp file. Many of ...

orafighter

 Profile Answers by orafighter Questions by orafighter

• Sep 6th, 2007

Hello sql>show sga , then it shows these parameters---- Total system global area---- Fixed size----Variable size----Database buffers----Redo buffers or can query from select * from v$sga

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

How many layers are there in the shared pool? What are they?

amahalakshmimca

 Profile Answers by amahalakshmimca Questions by amahalakshmimca

• May 13th, 2009

There are two layers in shared pool 1. Library cache2. Data Dictionary cache

Answer Question  Select Best Answer

sumer77

 Profile Answers by sumer77 Questions by sumer77

• Mar 22nd, 2009

Sum of bytes from dba_extents will provide the database size.      

Sridhar.K

• Oct 15th, 2007

COLUMN "Total Mb" FORMAT 999,999,999.0COLUMN "Redo Mb" FORMAT 999,999,999.0COLUMN "Temp Mb" FORMAT 999,999,999.0COLUMN "Data Mb" FORMAT 999,999,999.0PromptPromp...

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

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

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

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

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

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

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

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

Answer Question  Select Best Answer