What is dump destination? What are bdump, cdump and udump? Explain in detail.

anurag2202

 Profile Answers by anurag2202 Questions by anurag2202

• Oct 30th, 2009

The dump destination is: Oracle_home/admin/<SID>The UDUMP specifies user dump directory where all the user related information is stored in the form of trace file.The BDUMP specifies background ...

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Jul 6th, 2009

UDUMP is specifying the user dump directory where all user error logs (trace files) will be placed.BDUMP is specifying the background dump directory where all database error logs (trace files) will be...

Answer Question  Select Best Answer

What is PCT Free and PCT Used?What is PCT increase parameter in segment?What is growth factor?

mkguduru

 Profile Answers by mkguduru Questions by mkguduru

• Jan 21st, 2010

PCTFREE: Percentage of blocks to be reserved for future updates.After this parameter is met the block is considered to be full and it is not available to insert new rows. PCTUSED: It allows the block to reconsidered for the insertion of new rows.

refakat

 Profile Answers by refakat Questions by refakat

• Aug 12th, 2009

This is the parameter which specify in percent? that a block can only used for insert or come in the freelist(list of blocks in segment ready for insert operation) when used space in a block is less ...

Answer Question  Select Best Answer

A user issues the below query,
1. Select * from table1 lock table

At the same time DBA is trying to modify this table table1 using alter command, will he able to do that or not?

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 22nd, 2012

DDL lock are exclusive locks. It shared the data. Means anyone can select data from same table.

anil

• Mar 13th, 2012

There dba can break the lock given to table.
but in real time, no dba has the right to break the lock given by the user

Answer Question  Select Best Answer

Neeraj Kumar Singh

• Feb 17th, 2012

Code
 

Arunkumar

• Dec 28th, 2011

Code
 

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

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