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

In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW .To avoid these execeptions. How do you write SQL statement in alternative way?

Ananda Kumar Behera

• Nov 12th, 2013

To avoid use:

Code
 

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

We can use explicit cursor to avoid Oracle exception - NO_DATA_FOUND and TOO_MANY_ROWS.

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

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

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

If you have an open cursor on a table, modify the same table and commit, what would happen?

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not be selected in that operations.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not...

Answer Question  Select Best Answer