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

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

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

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

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

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

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

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

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

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

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

What is the purpose of redo log files?

harit79

 Profile Answers by harit79 Questions by harit79

• Aug 2nd, 2009

The purpose of redo log file is to record all changes made to the data during the recovery of database.It always advisable to have two or more redo log files and keep them in a  seperate disk, So you can recover the data during the system crash.

Answer Question  Select Best Answer

What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact?

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Aug 11th, 2009

There are 25 Levels of Message in an Oracle Forms.How much cretical error or message is0 -- all errors or message12...25 -- don't shows anyIf we don't wannat show any error  or message to...

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

Which one gives better performance,
co-related subquery or inline views? Why?

Lakshmi84

 Profile Answers by Lakshmi84 Questions by Lakshmi84

• Aug 12th, 2009

Inline views works better than correlated subqueries in 8i. But things have changed in 9i.  This is because Oracle has changed their logic while processing a correlated  subquery.

Answer Question  Select Best Answer

Query 1.
SELECT sal FROM emp e WHERE sal < any (SELECT sal FROM empWHERE empno=e.mgr)
(o/p:11 row)
Query 2.
SELECT SAL FROM emp e WHERE sal < any (SELECT sal FROM empWHERE mgr=e.empno)
(o/p:1 row)
What is the difference between the above 2 queries.

sen_sam86

 Profile Answers by sen_sam86 Questions by sen_sam86

• Aug 27th, 2009

How this query is possible i dont know, how the emp number and manager number will be same, i think the query in meaning less r am not understanding properly i dont know,,,, Let some one explain this...!

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Sep 30th, 2008

These both are correlated subqueries.In the first one, we are knowing the salaries of employees who are earning less than there manager.In the second one we are knowing about the salaries of?managers who are earning less than their employees whom they manage.

Answer Question  Select Best Answer

jpundalik

 Profile Answers by jpundalik Questions by jpundalik

• Dec 26th, 2009

Components of SGA- Shared Pool (Library Cache and Data Dictionary Cache)- Data Base Buffer- Redo Log Buffer

pchandna

 Profile Answers by pchandna Questions by pchandna

• Jul 22nd, 2009

DB buffer cache, Redo Log cache and Shared PoolShared Pool --> data dictionary cache, Library cache and User Global area

Answer Question  Select Best Answer

venkatagsubbaiah

 Profile Answers by venkatagsubbaiah Questions by venkatagsubbaiah

• Feb 4th, 2010

Create Table Tab1 as select  * from Tab2 where 1=2;

rajiv.sriraj

 Profile Answers by rajiv.sriraj Questions by rajiv.sriraj

• May 9th, 2008

HI if u want to get the same table structure which is already existing in ur database then SQL QUERY IS create table <table name> as select * from <table name which is already in DB> where...

Answer Question  Select Best Answer

aStewart

 Profile Answers by aStewart Questions by aStewart

• Feb 23rd, 2010

The index status can be found in the dba_indexes, dba_objects, or the equivalent  user_ view. The possibilities are VALID, INVALID, UNUSABLE, or N/A.  Invalid or unusable indexes will not be...

Asim Jamal

• Apr 13th, 2006

The current status and details of an index could be accessed by system table sys.dba_indexes. The status could be VALID,INVALID,N/A.The invalid indexes unnecessarily occupies the space in a Tablespace.

Answer Question  Select Best Answer