What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

pandish

 Profile Answers by pandish Questions by pandish

• Dec 31st, 2010

Depending on error1. Try to use your judgement,experience to understand and resolve it. You can even ask to reproduce it.2. Search the metalink. or run oerr utility by passing the ORA message number t...

samsam1414

 Profile Answers by samsam1414 Questions by samsam1414

• Jan 19th, 2010

Search forums for similar error codes or symptoms and make a plan, then submit it to your supervising DBA if you are not authorised to carry it out yourself.

Answer Question  Select Best Answer

What are key tasks for an oracle dba on daily basis?

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 22nd, 2012

Daily Tasks of DBA are following. 1. Disk Space checking for all databases, tablespaces, archive log destinations, dump destinations, and backup destinations. 2. All backup successfully finished or n...

Ankur Kaushik

• Mar 15th, 2012

1.Connectivity: Make sure each database is available and accessible both by logging in via user applications, as well as running test scripts. 2.Backups: Check database and log backups, archiving an...

Answer Question  Select Best Answer

what will happen after checkpoint ?
i means .. dbwr write or redo log entries like that .. i am asking..

Somesh Menaria

 Profile Answers by Somesh Menaria Questions by Somesh Menaria

• Feb 22nd, 2016

When checkpoint occurs the datafiles and control file header are updated and also dbwr writes dirty buffer to datafiles checkpoint give the signal.

ahmed

• Jul 11th, 2015

Whenever switch log occur, checkpoint event will occur, and ckpt event will invoke checkpoint process, then ckpt process will generate SCN No. for specific transaction, and that SCN info will be load into control file and SCN No. writes into data file header, and invoke to dbwr.

Answer Question  Select Best Answer

alvinstars

 Profile Answers by alvinstars Questions by alvinstars

• Sep 7th, 2010

The database automatically maintains and uses indexes after they are created. The database also automatically reflects changes to data, such as adding, updating, and deleting rows, in all relevant indexes with no additional actions required by users.

Prashidha

 Profile Answers by Prashidha Questions by Prashidha

• Apr 8th, 2009

We can update the index by rebuilding it.Alter index indexname rebuilt

Answer Question  Select Best Answer

hmounir

 Profile Answers by hmounir Questions by hmounir

• Jan 30th, 2010

Four types of segments are found in oracle database:1- Data segment2- Index segment3- Temporary segment4- Rollback segment

kpeer40

 Profile Answers by kpeer40 Questions by kpeer40

• Jan 28th, 2010

Table segmentsIndex segmentsUndo segmentsTemp segmentsRollback segments

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

The 2 basic feature of Oracle 10g makes database Maximum protection and Zero downtime (1) Undo Retention Guarantee.(2) Stand by server compatibility.

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

Maximum Protection mode - guarantees Zero data loss.  But it can not guarantee Zero down time.Any transaction happening in Primary Database has to be propagated and commited in Standby Datab...

Answer Question  Select Best Answer

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 29th, 2008

Characteristics of a Data File : - A Data file can be associated with only one tablespace. - Once created, a datafile can be increased or decreased in size with RESIZE command. Example: ALTER da...

alex.v

 Profile Answers by alex.v Questions by alex.v

• Jul 11th, 2008

datafiles can be resized to a lower size also, but till the used space....

Answer Question  Select Best Answer

 The set of objects owned by user account is called the schema.

Sriniv@s..

• Jun 20th, 2012

Schema is a set of objects own by a Particular user..

msabuu

 Profile Answers by msabuu Questions by msabuu

• Nov 6th, 2007

Schema is collection of database object.

Answer Question  Select Best Answer

rohit

• Jul 28th, 2011

We use bitmap indexes on tables with fairly static low cardinality values (a small number of different values which do not change very often).
It is used in long size table containing 'n' no of records with duplicate records.

RASH

• Mar 25th, 2007

The explanations are above, read further in the concepts manual.I would advice caution when using these, as they can cause severe conention when used in Update/Insert Intensive / OLTP environs.This is...

Answer Question  Select Best Answer

jayesh gaikar

• Nov 6th, 2018

LMT(Locally Managed Tablespace) :In LMT Extents are managed at the data file level.
DMT(Dictionary Managed Tabalespace) :Extent management in DMT is maintained and carried out at the data dictionary level.

Surya

• Jun 15th, 2017

When Oracle allocates space to a segment (like a table or index), a group of contiguous free blocks, called an extent, is added to the segment. Metadata regarding extent allocation and unallocated extents are either stored in the data dictionary, or in the tablespace itself

Answer Question  Select Best Answer

mahmed100

 Profile Answers by mahmed100 Questions by mahmed100

• May 16th, 2010

Take a Backup

vishnusivathej

 Profile Answers by vishnusivathej Questions by vishnusivathej

• Jul 21st, 2008

Backup the entire database...

Answer Question  Select Best Answer

A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA - Default Tablespace Quota 500 M - Tablespace 1 Quota 100 M - Tablespace 2 Quota 200 M Now the user tries to make a table which uses 300 M in tablespace 2. Will he be successful?

bassem_farouk

 Profile Answers by bassem_farouk Questions by bassem_farouk

• Sep 17th, 2008

Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored. SQL> create user test identified by test1; User created. SQL> grant connect, reso...

vishnusivathej

 Profile Answers by vishnusivathej Questions by vishnusivathej

• Jul 21st, 2008

There will be no such thing as default size for a tablespace u have to assign it when it is being created.. and more over by default u can have 100 datafiles in a database which is the default value used during the database creation process u can also change this value..

Answer Question  Select Best Answer

Can you perform DML operations when the standby database is in read only in Standby Database?

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

In a nutshell, One can do SELECTS only on a Physical/Logical Standby database. The basic principle behind Oracle Standby database is to provide protection against media failures. So no DMLs are allowe...

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Jul 7th, 2009

I agree with omelkoz, But I need to add a small point here. Specifying STANDBY is to to prevent all users other than SYS from making DML and DDL changes to any table or sequence being maintained through SQL apply operations. Not everybody can execute statements on a standby. :)

Answer Question  Select Best Answer

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