Sriniv@s..

• Jun 8th, 2012

SQLNET.ORA :: It is the optional network configuration file.it contain network configuration details.
LISTINER.ORA : It is the listener file for creating at server side
TNSNAMES.ORA:client side configuration file.it was matched with listener file.it for remote access.

Patrick McShea

• Nov 15th, 2006

SQLNET.ora tells you what path to take in resolving the name of an instance (among other things). In the context of this question, the NAMES.DIRECTORY_PATH parameter specifys the order of the naming methods used for client name resolution lookups. (TNSNAMES, ONAMES...)

Answer Question  Select Best Answer

Sriniv@s..

• Jun 5th, 2012

Schema is a set of objects own by particular user.
Tables,indexes,Triggers,constraints etc..are schema objects..

Jacob

• Jul 9th, 2005

A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users. Objects may define areas ...

Answer Question  Select Best Answer

Sriniv@s..

• Jun 5th, 2012

Rollback segment is a database object,containing before image of data written to the database.It is used to..
:Undo changes when the transaction is rolled back.
:Recover the database in case of failures.
:Uncommitted changes made to the database,this will protected by it.

Ram

• Jul 9th, 2005

ROLLBACK INFORMATION NOTES:   Segment Name - Name of the rollback segment.  Owner - Owner of the rollback segment.  Tablespace - Name of the tablespace containing the rollback...

Answer Question  Select Best Answer

Sriniv@s..

• Jun 2nd, 2012

SGA(system global area) & PGA(program global area) are two memory structures in oracle. SGA::is used to store shared information.It having Buffercache,Redolog buffer,Shared pool,java pool,Larg pool an...

AJU JOHNSON

• Apr 29th, 2005

PGA Program global area Contains  Session variables ,Stack space,Cursor status ,Sort Areas

Answer Question  Select Best Answer

kirankumar c.s

• May 26th, 2012

Server process

baala

 Profile Answers by baala Questions by baala

• Aug 11th, 2008

DBWR only writes to the data files. So the answer is Server Process.

Answer Question  Select Best Answer

Explain what are Oracle Catalog and Oracle Archive log?

Sriniv@s..

• May 23rd, 2012

Oracle catalog contain the metadata of objects.
RMAN catalog maintain the backup information.
Redo data persistently stored in archive logs,for recovery..

pandish

 Profile Answers by pandish Questions by pandish

• Dec 31st, 2010

Catalog term is used in 2 ways.Catalog - All tables/views stores information about database and all objects in it.RMAN Catalog - Schema where RMAN executable stores/reads/writes the information about ...

Answer Question  Select Best Answer

What are the common problems while taking backups? What are the necessary steps to take backup on to tapes and disks in real time?

sundarasaravanan

• May 4th, 2012

For a cold backup :shutdown oracle first and then proceed the cold(offline) back up. once you shutdown the oracle database insert the external tape/disk.pls ensure the tape/disk is in good condition. ...

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Some Common issues with Backup. If you are taking backup from no-archive log: then your database doesn't bring down due to some processes are running. If you are taking hot backup then may be newly ...

Answer Question  Select Best Answer

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Dear friend, it is not RAP but it is WRAP. Using this utility of Oracle, we can hide our PL/SQL code from user.

Answer Question  Select Best Answer

If Materialized view contains the actual data and has to be re-created every time the original table data is changed and we intent to refresh the data in the view.then what is the actual use of materialized view, why can't we create another table by itself by running the same query ?

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Materialized view is useful in replication and data warehousing environment where every time data extracting and data loading from another sites,databases. Materialized view also useful for maintaining complex queries because it uses query rewrite feature.

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

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 22nd, 2012

Logical Structure of Oracle is following.

Tablespace =>Schema => Segments => Extent => Oracle Block. (Remember Oracle block is smallest logical unit).

csanthoshreddy

 Profile Answers by csanthoshreddy Questions by csanthoshreddy

• Mar 6th, 2012

The logical components of database are tablespaces, segments, extents, datablocks. datablock is the smallest unit of oracle I/0.

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

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

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

csanthoshreddy

 Profile Answers by csanthoshreddy Questions by csanthoshreddy

• Mar 6th, 2012

Datafile is the physical storage location of the database.tablespace is logical.for creation of tablespace one or more datafiles needed.we can define the datafile location with the following parameter

db_create_file_dest

Dharma Kotha

 Profile Answers by Dharma Kotha Questions by Dharma Kotha

• Oct 10th, 2011

Datafiles are physical data location of oracle architecture. Table space contains no.of datafiles.

Answer Question  Select Best Answer

Neeraj Kumar Singh

• Feb 17th, 2012

Code
 

Arunkumar

• Dec 28th, 2011

Code
 

Answer Question  Select Best Answer

What should you do when you find a stacktrace in the server errorlog?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

When the server crashes, it generates core dump. If value of orclsdumpflag is set to 0, then the server will also attempt to leave a stack trace. The location for the stack trace is: ORACLE_INSTANC...

Answer Question  Select Best Answer

If dead lock happened for 2 applications at a time in a banking sector..how to resolve this issues without forcing any one of the application ..we should not have to stop the transaction...

Dharma Kotha

 Profile Answers by Dharma Kotha Questions by Dharma Kotha

• Oct 10th, 2011

A deadlock occurs when data was locked simultaneously by two sessions(users) and waiting for data, this can be resolved by rollback statement.

dharma

• Aug 23rd, 2011

Dead Locks can be resolved by rollback statement.

Answer Question  Select Best Answer

Sharfuddin

• Sep 29th, 2011

Select username,default tablespace,temporary tablespace from dba_users;

This query executes only if following queries is run in mount stage
1. @ $ORACLE_HOME/rdbms/admin/catalog.sql
2. @ $ORACLE_HOME/rdbms/admin/catproc.sql
3 connect system/manager
@ $ORACLE_HOME/sqlplus/admin/pupbld.sql

Rajashekar

• Sep 5th, 2011

Suppose if we are in need of the users connected to a tablespace called abcdata 6the how to findut?

SELECT USERNAME, TABLESPACE_NAME FROM DBA_USERS WHERE TABLESPACE_NAME='ABCDATA';

this will display the users connected to the tablespace abcdata.

Answer Question  Select Best Answer

Query v$log

chandrasekhar

• Sep 18th, 2011

I suppose the question is on designing and not just finding the size of present logfile.

Shrikant Pande

• Aug 24th, 2005

Select sum(bytes)/1024/1024 size_in_mb from v$log;

Answer Question  Select Best Answer