mani

• Mar 6th, 2007

Connect as sysdba and typeselect * from v$sgainfo;

rajatm2

 Profile Answers by rajatm2 Questions by rajatm2

• Dec 1st, 2006

connect sqlplus using sys or system or any user .and type show sgaregardsRajat

Answer Question  Select Best Answer

Innila

 Profile Answers by Innila Questions by Innila

• Mar 22nd, 2007

Hi,Lookup tables are like master tables which are static & will be referred by other Base tables for reference.Lookup tables are basically used for referring a predefined data which are stored in these tables.*** Innila ***

Red

• Mar 11th, 2007

A look up table is a table whose values are seldom or never updated. They are basically used for references. A good example of a look-up table is a 'country's' table.

Answer Question  Select Best Answer

sik tauk

 Profile Answers by sik tauk Questions by sik tauk

• Apr 26th, 2007

If you are a DBA, login on the host using sqlplus to the database using sys as sysdba privilege.$ export ORACLE_HOME=<ORACLE_HOME>$ export ORACLE_SID=<ORACLE_SID>$ sqlplus "/ as ...

daniels

• Dec 18th, 2006

You could also do the following.dbms_utility.compile_schema(schema IN VARCHAR2,compile_all BOOLEAN DEFAULT TRUE,reuse_settings BOOLEAN DEFAULT FALSE);exec dbms_utility.compile_schema('SCOTT');

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

When you execute query oracle checks for various things syntax, access and then generate optimize plan and in this stage parsing happens. when the query plan is already there in sga you get hit and that is soft parsing..else hard1. Soft parsing2. Hard parsing

Answer Question  Select Best Answer

Asad

• Jul 30th, 2007

Index are reference to data in tables's columns on what they are based. Index work exactly in way? like we have book's index describing its chapters and what page # chapter can be found.They only con...

Answer Question  Select Best Answer

Magu

• Aug 5th, 2007

Isolated join is a join which is not connected to any of the context.

Answer Question  Select Best Answer

Vrushali

• Aug 9th, 2007

Tablespace : A tablespace is a logical structure on a Oracle database consisting of one or more datafiles. The objects are stored in a tablespace.Clusters: When two or more tables have a requirements ...

Ramco

• Oct 9th, 2006

Table space is the logical data units of a database. every database is divided into Database -> tablespace -> segments - > externsin short (tablespace is a logical group of data files in a da...

Answer Question  Select Best Answer

roniprasan

 Profile Answers by roniprasan Questions by roniprasan

• Sep 2nd, 2007

Raise_application_error(error number,error discription)

aseemnaithani

 Profile Answers by aseemnaithani Questions by aseemnaithani

• May 3rd, 2006

Hi,,it is Raise_Application_error

Answer Question  Select Best Answer

roniprasan

 Profile Answers by roniprasan Questions by roniprasan

• Sep 4th, 2007

Char(size) max size upto 2000 min  1varchar2(size) max upto 4000 min 1

Answer Question  Select Best Answer

Catalina

• Sep 25th, 2007

It seems that, if the main query selects from a great number of rows, than Oracle will have a better execution plan if you use EXISTS. If the main query selects from a small number of rows, while...

Answer Question  Select Best Answer

KAMRANSAJID

 Profile Answers by KAMRANSAJID Questions by KAMRANSAJID

• Sep 21st, 2007

Crystal Report supports to create report from third party database, Oracle Report supports to create report from Oracle Database only.

najeebasghar

 Profile Answers by najeebasghar Questions by najeebasghar

• May 11th, 2007

Crystal Report is third party tool to develop different types of reports, just to connect database which are oracle , ms sql 2000 and ms access etc where as Oracle report is specially used for oracle data base

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 28th, 2007

1. Show SGA.2. It is related to block oracle has to search more.3. Increase the size of Undo segment.

Answer Question  Select Best Answer

pramod

• Oct 22nd, 2007

In the above code '-2' specifies that the only two digits before the decinmal points needs rounding up.and '+2' would mean two digits after the decimal point.

sudheer_ml

 Profile Answers by sudheer_ml Questions by sudheer_ml

• Apr 26th, 2006

as in u'r comment second prameter is negative,so it will count 2 digit from decimal point to left side .i.e 23 this 23 is less than 50 so it will round it zero.if u take above 50 it will round it to 1...

Answer Question  Select Best Answer