1) How to install patches? And what are pre-requsites?
2) How to upgrade 10.2.0.1 to 10.2.0.4 AND 11.2.0.1 to 11.2.0.3 and 10.2.0.4 to 11.2.0.1?
3) How to take the backup of oracle_home and oracle_inventory?
4) What is OCR & voting disk?
5) How to take backup of OCR and voting?
6) Which one take backup if OCR and voting disk?
7) Suppose lose OCR what happen...

Sanjay Srivastava

• Feb 9th, 2017

We can take backup of OCR file.
ocrconfig -manual backup;

alekhya kumari

• Sep 22nd, 2016

# cat /etc/issue -os name & version of os. when we start a database its version is shown

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

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

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

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

tej

• Aug 24th, 2011

No

Shrikant

• Jul 25th, 2011

No.Because It is Logical subset

Answer Question  Select Best Answer

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 22nd, 2012

Exactly View is logical identity.Oracle only stores definition of View in metadata. Using view, we can hide some columns of tables from users, we can hide original table name from user. Using view we can perform complex query in single statement.

ROHAN MAKODE

• Feb 25th, 2012

Assume that the dba is modifying a tables and the same time developer want to use that database a then dba can provide him the view for that tables.

Code
 

Answer Question  Select Best Answer

Carlos Andr?s Morales Machuca

• Sep 24th, 2014

Is a connection with another database, usually other database Oracle, but is possible with other brand using Heterogeneous Services.

Abhinav

• Nov 5th, 2012

A database link is a path to another database with the help of which a user can access the schema objects of later database.

Answer Question  Select Best Answer