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

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

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

bhanuchander333

 Profile Answers by bhanuchander333 Questions by bhanuchander333

• Jan 5th, 2008

RAISE statement is used to raise exception explicitly with in the EXECUTABLE sectionwhere: Exception is previously declared in declaration section as 'exception'.

ramaswamy80in

 Profile Answers by ramaswamy80in Questions by ramaswamy80in

• Sep 26th, 2007

No   you  use 'raise' to raise  exceptions   and  we  raise exceprions in Executable sectionso we are most likely to see the ' raise ' in   Eecutable sectoin

Answer Question  Select Best Answer

What is the difference between Varray And Nested Table?

Vishnu Bharath

• Jan 8th, 2014

Varrays are generally dense , that mean you cannot delete elements of the varray.But the elements of the Nested Table are generally sparse in nature and hence the elements can be deleted in between us...

Sheraz Baig

• Dec 3rd, 2013

Both are type of collections in Oracle. In Varray because its not stored in database columns so no DML operation can be implemented but on other hand as Nested tables we can perform DML operations

Answer Question  Select Best Answer

How do you verify the number of Databases running on a Host?

bhanu prakash

• May 6th, 2017

We can verify number of databases running by using pf -ef|grep pmon or smon.

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 22nd, 2010

Renjith, Waseem has explained for UNIX. Let me tell you how you can find the same on Windows. Go to Start Menu, Then RUN. Type “Regedit” and Get inside the registry. Go to this path &ldquo...

Answer Question  Select Best Answer

vinoth

• Jul 15th, 2011

Giving privilege to the user

sreekanth.g

 Profile Answers by sreekanth.g Questions by sreekanth.g

• Jun 22nd, 2011

Assume that table 'emp' is created by user scott.by using grant command he can grant privileges to other users.If he want to provide a privileges to grant the privileges to other usershe has to grant a privileges with grant option.

Answer Question  Select Best Answer

What are archive files? What are the uses with archive files?

pardhudb

 Profile Answers by pardhudb Questions by pardhudb

• Mar 23rd, 2011

Before discussing ?about archive files we will be discuss about redolog files ,these redologfiles records every operation done on the database, ?so when the datafiles are damaged, we can get complet...

GAUTAMJANGRA

 Profile Answers by GAUTAMJANGRA Questions by GAUTAMJANGRA

• Mar 16th, 2011

Archives files are files which are placed together in a bunch for any particular work. Benefit of this is there is no chance of missing of files while transfer from one place to another, also you...

Answer Question  Select Best Answer

A employee getting variable salary like Jan 3000,Feb 5000,Mar 1000 ,Apr 7000,May 500 write query to display his next salary "increse" or "decrese" as compare to previous month ,three column in the employee table empname ,salarydate,salary ?

bharahi

• Aug 5th, 2014

It can be done by analytical function using the lead function.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

This can be done by analytical function using the LEAD function.

Answer Question  Select Best Answer

mrrichardson

 Profile Answers by mrrichardson Questions by mrrichardson

• Jul 12th, 2010

Structured Query LanguageSQL- Is a languagekeywords cannot be abbreviatedSQL *PLUS - More complex than SQLIs a command line tool propietary to Oracle where you can run both SQL and PL/SQL stateme...

Jeremy

• Aug 24th, 2007

SQL*Plus is a client program and interactive interpreter designed for interacting with Oracle databases. SQL is a standard data access language used to describe data access to a variety of databases. ...

Answer Question  Select Best Answer

What is the actual processing being done at backend or server side to retrive the data or complete the DML operation.

KSPradeep Rayavarapu

• Jan 28th, 2013

The order of Query Execution is following
1)From Clause
2)Where Clause
3)Group By Clause
4)Having Clause
5)Select
6)Order By Clause

Sachin Garg

• May 22nd, 2012

Hi Friends, When we pass a SELECT query it executes under some phases. That includes 1) Checking by Server Process - Which type of Query is this - Sql or Pl/sql. 2) If sql - server process puts the ...

Answer Question  Select Best Answer

JP

• May 25th, 2014

When create primary constraints oracle automatically creates Unique Index .
Using "Create index" by default oracle will create B tree index .
To create other indexes like Bit map,IOT index you need mention the Index name while creating index
ex "create Bitmap index "

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Jan 31st, 2008

Index will only help you in searching the data but unique index will provide uniqueness to the indexed column. But in both the cases NULL values are allowed to insert.

Answer Question  Select Best Answer

If it reduce the traffic then please give an example for that one

Oracle Training in Chennai

• Mar 3rd, 2015

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table. Using materialize...

Ashish

• Feb 10th, 2015

Materialized views stores data init at the client side only so they do not need to fetch the records each time by hitting the database. They get the refresh only when executed manually or when set to get the refresh based on the settings. Therefore they are always faster than the normal views.

Answer Question  Select Best Answer

If there no table but we can create a synonym. If it raises error or not. If raises error what error it raises.

Akshay Sharma

• Nov 8th, 2017

A synonym will be created without giving any error, but before using the synonym the user must first create the table other wise it will raise an error "Synonym translation is no longer valid".

Bansilal

• Feb 19th, 2017

Yes. We can create in Oracle.

Answer Question  Select Best Answer

mala321

 Profile Answers by mala321 Questions by mala321

• Dec 24th, 2007

Hello,SQL * LOADER is a utility tool which comes inbulit with any versions of Oracle. it is used to load data (.txt,.xls, tables, Doc ...) any flat files of this type can be loaded into  Oracle d...

SrikanthPeru

 Profile Answers by SrikanthPeru Questions by SrikanthPeru

• Aug 18th, 2007

SQL*Loader is a tool used to load flat files quickly into Oracle Tables. Using this, a single flat file can be loaded into multiple tables during the same load.

Answer Question  Select Best Answer

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

New Features in 9i are 1.Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4....

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

New Features in 9i are1. Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4....

Answer Question  Select Best Answer

santosh

• May 21st, 2012

UNDO tablespace contain the old information. it is circular process. it will overwrite the first extents. so if you need the overwritten statement that time it will show as snap_shot is to old.

oradebug

 Profile Answers by oradebug Questions by oradebug

• Jul 25th, 2009

First you have to understand that Oracle is a MVCC (multiversion concurrency control) or "repeatable read" database system.? Queries are returned with all rown consistent with respect to the point in...

Answer Question  Select Best Answer

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Feb 1st, 2008

Select * from user_indexes where status ='Invalid'you can specify index_name in the same query to look for a particular INDEX.

deepsk singh

• Jul 16th, 2007

If you want to know which one?is invalid/valid; you find out from the data dictonary table user_objects and execute query select * from user_objectswhere object_type = 'INDEX'and status ='INVALID' ---and status ='VALID'

Answer Question  Select Best Answer

DURGAPRASAD

• Jul 24th, 2012

Code
 

Diptiman Badajena

• Mar 29th, 2012

Try this one:

Code
 

Answer Question  Select Best Answer

sravee123

 Profile Answers by sravee123 Questions by sravee123

• Jun 4th, 2008

Select e.ename,sal from emp e where e.sal>(select avg(sal) from emp where e.deptno=deptno)

askvenki

 Profile Answers by askvenki Questions by askvenki

• Jun 3rd, 2008

SELECT * FROM EMP E WHERE E.SAL>(SELECT AVG(sAL) FROM EMP E1 WHERE E1.DEPTNO=E.DEPTNO); Above is the co-related subquery, I am explaining its executionStep1: The main query executes first and we get ...

Answer Question  Select Best Answer