An  index  is a database structure used by the server to have direct access of a row in a table. An  index  is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

Indexes are used both to improve performence and to ensure uniquness of a column. Oracle automatically creates an index when a UNIQUE or PRIMARY key constarints clause is specified in a create table command.We can manually create our own indexes via the create index command.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

An index is a database structure used by the server to quickly find a row in a table.In a relational database the physical location of row is irrelevent-unless, of course, the database needs to find i...

Answer Question  Select Best Answer

ganesha23

 Profile Answers by ganesha23 Questions by ganesha23

• Dec 16th, 2009

Parse, fetch and execue.

Vishal

• Sep 18th, 2007

1. Parse:  a. Search for identical statementb. Check syntax, object names, and privilegesc.  Lock objects  used during parsed. Create and store execution plan2. Execute: Process the Statement3. Fetch: Return rows to User Process

Answer Question  Select Best Answer

You can do it at the OS level by deleting all the files of the database. The files to be deleted can be found using: 1) select * from dba_data_files; 2) select * from v$logfile; 3) select * from v$controlfile; 4) archive log list 5) initSID.ora 6) In addition you can clean the UDUMP, BDUMP, scripts etc Clean up the listener.ora and the tnsnames.ora. make sure that the oratab entry is also removed. 

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

Start the database with startup mount restrictthen drop the database using drop database command.

mahender.komat

 Profile Answers by mahender.komat Questions by mahender.komat

• Aug 5th, 2009

SHUTDOWN IMMEDIATE;
STARTUP RESTRICT MOUNT;DROP DATABASE;

Answer Question  Select Best Answer

You can query dba_data_files and dba_temp_files

prasant singh

• Oct 3rd, 2017

Can you explain why using bytes/1024/1024/1024

gvishalsoft

 Profile Answers by gvishalsoft Questions by gvishalsoft

• Apr 28th, 2009

Select substr(to_char(sum(bytes)/1024/1024, '999,999,999.99'), 1, 15) "TOTALMB", substr(to_char(sum(bytes)/1024/1024/1024, '999,999.99'), 1, 11) "TOTALGB" from dba_data_files;

Answer Question  Select Best Answer

ayub

• Sep 19th, 2017

System tablespace is memory allocated by oracle and will be created at the time of database creation, stores information of data dictionary tables in database, with out system tablespace you can not open the database.

imran44

 Profile Answers by imran44 Questions by imran44

• Jan 9th, 2009

IN 10g, there are two system table spaces called system and sysaux(auxillary) tablespace. These system tablespaces are backbone of database, and data base will not function at all without these tables...

Answer Question  Select Best Answer

GOURAV MITTAL

• Aug 23rd, 2011

A oracle view is only view the table columns which is defined before one or more join tables.A oracle view only read only we can't change in the oracle view.when we apply any query on the actual table...

Nagavaram Chalapati

• Aug 14th, 2011

View----> View is logical Representation of the physical object
View---> view is physical object acting like logical object
View----> view is one type of security layer architecture
View----> View is protected original of the table

Answer Question  Select Best Answer

skranof

 Profile Answers by skranof Questions by skranof

• Jul 2nd, 2009

I assume you already figured this out, but if notsimplyuse dbNamegodrop table table1, table2, table3

abdulraheem_ar

 Profile Answers by abdulraheem_ar Questions by abdulraheem_ar

• Aug 5th, 2008

Try using substitution variable likeDROP TABLE &table_name

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

1. Check the oratab file to get the list of databases on a server.Caveat: If the database is created manually, then the oratab won't updated automatically which should be done manually as oratab i...

Krishna Miryala

• Apr 15th, 2007

$ ps -eaf|grep pmon

Answer Question  Select Best Answer

pabroy

 Profile Answers by pabroy Questions by pabroy

• May 5th, 2008

You can search Top ten sql.Top 10 Sql. SELECT *FROM   (SELECT rownum,Substr(a.sql_text,1,200) sql_text,        Trunc(a.disk_reads/Decode(a.executions,...

senthilora

• Sep 24th, 2007

You can use STATSPACK to take SNAPs while running those queries and get the report with details of SQLs taking more time to respond.

Answer Question  Select Best Answer

Fabio

• Jun 9th, 2015

You do not use it anymore, you would have to use it in old Oracle versions when you did not have RMAN!

Sriniv@s..

• May 23rd, 2012

In case of hot backup,table space is put into backup mode.At the time ts related datafile header is frozen
because for taking backup with out any data loss.And after that any data is coming,that one going to redolog file for recovery.

Answer Question  Select Best Answer

When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check?

vijender reddy

 Profile Answers by vijender reddy Questions by vijender reddy

• Aug 13th, 2010

First we must check for any locks on the objects, if we get any locks then just release that lock.Here is how you can know if there is a lock on an object1. Find sidSQL>select distinct sid from v$...

sonaligujral1

 Profile Answers by sonaligujral1 Questions by sonaligujral1

• Aug 7th, 2010

Block corruption error may happen

Answer Question  Select Best Answer

What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them?

shaanahmed007

 Profile Answers by shaanahmed007 Questions by shaanahmed007

• Aug 3rd, 2010

If we are getting any issue regarding database while performing any activity we should check alert log file in dump destination.1) Snapshot too old error (O1555)2) Deadlock error3) Any issue regarding backup & recovery

brandedfundoo

 Profile Answers by brandedfundoo Questions by brandedfundoo

• Jun 2nd, 2010

I agree..Deadlock error: Oracle takes care by itself. No damageSnapshot error: Rerun query. No damageOra-00600 : Internal.. very critical. Though directly Oracle has to be involved in resolution, stil...

Answer Question  Select Best Answer

What are four performance bottlenecks that can occur in a database server and How are they detected?

kumardba

 Profile Answers by kumardba Questions by kumardba

• Oct 7th, 2010

1) IO Contention because of  improper placement of datafiles,redo log files,archived log file.  Solution:Use ASM which handles automatic IO Performance Tuning with mirroring features2)Short ...

charandba

 Profile Answers by charandba Questions by charandba

• Oct 4th, 2010

Bottlenecks in DB Server are1)  I/O Overload  ::                              ...

Answer Question  Select Best Answer

Please Give any scenario (Or) example of its very help full?

Somesh Menaria

 Profile Answers by Somesh Menaria Questions by Somesh Menaria

• Feb 22nd, 2016

It is used to improve quering performance

Arjun

• May 29th, 2015

Materialized view is an option when we have data coming on a regular fashion in slots like last weeks data that will be used this week and data is too huge to generate at any point of time this is jus...

Answer Question  Select Best Answer

Temp table running out of space, What will you do?

Suresh Borse

• Apr 8th, 2016

Add the tempfile to temp tablespace.

amjath

• Mar 11th, 2016

Check the temp tablespace usage and kill inactive sessions or contact high space usage users to kill their sessions.

Answer Question  Select Best Answer

g.mrunalini

 Profile Answers by g.mrunalini Questions by g.mrunalini

• Feb 12th, 2008

SCN changes for every 3 minutes in 10g and for each and every action in 9i. It resides in control files and data files. CKPT (checkpoint) background process updates the SCN numbers from control files ...

senthilora

• Sep 24th, 2007

SCN - System Change Number - is always getting incremented by Oracle server and will be used to make sure the consistency across the database.SCN number will be updated in almost all places of th...

Answer Question  Select Best Answer

nunesrinivas

• Mar 25th, 2015

Select sum

Nadeem

• Feb 12th, 2015

Select sum(bytes)/1024/1024/1024 AS sizeGB from dba_data_files;

Answer Question  Select Best Answer

syed fahad

• Sep 13th, 2014

Kill -9 (process id)
we can check the process is with the help of (ps -ef |grep pmon)

hemu

• Mar 15th, 2014

Kill -9 (process id)
pkill (process name)

Answer Question  Select Best Answer

Nony

• Oct 7th, 2012

Alter table move tablespace USERS

chandrasekar.s

• Jun 1st, 2012

Using alter table command we can move one table from one schema to other

Code
 

Answer Question  Select Best Answer

srilatha

• Mar 16th, 2012

Table is used to store the data in the form of rows and columns

nandu

• Sep 21st, 2011

A table is used to store the information in form of rows &columns in the database

Answer Question  Select Best Answer