Rahul Gupta

• Aug 8th, 2016

OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT TABLE_OWNER BASE_OBJECT_TYPE TABLE_NAME COLUMN_NAME REFERENCING_NAMES WHEN_CLAUSE STATUS DESCRIPTION ACTION_TYPE TRIGGER_BODY CROSSEDITIO...

ANIL

• Dec 13th, 2011

ABOUT TRIGGERNAME,
OWNER,
TRIGGERTYPE,
TRIGGEREVENT,
TABLEOWNER EXC
information is stored in DBA_TRIGGERS.

Answer Question  Select Best Answer

midhunam

 Profile Answers by midhunam Questions by midhunam

• Mar 7th, 2010

When the startup command enters the mount stage, it opens and reads the control file. The control file is a binary file that tracks important database information, such as the location of the databa...

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jan 4th, 2006

During database mount process, Oracle would check for the existence of controlfiles mentioned in init.ora file but it wont check the contents of the controlfile which is done during the opening of database.

Answer Question  Select Best Answer

sviru

 Profile Answers by sviru Questions by sviru

• Jul 11th, 2011

DBA_ROLE_PRIVS data dictionary view

satishbabu56

 Profile Answers by satishbabu56 Questions by satishbabu56

• Jun 30th, 2011

We can check it from user_role-privs

Answer Question  Select Best Answer

paparao

• Oct 23rd, 2006

Exatly upto 512 peta bytes ( refer to Oracle Database Concenpts manual).

frmchandan

 Profile Answers by frmchandan Questions by frmchandan

• Aug 9th, 2006

This answer is Perfect you have repliedThe holding capacity of 9i is 500PB

Answer Question  Select Best Answer

raghukiranreddy

 Profile Answers by raghukiranreddy Questions by raghukiranreddy

• Dec 16th, 2008

Initialization Parameter file....

raghukiranreddy

 Profile Answers by raghukiranreddy Questions by raghukiranreddy

• Aug 19th, 2008

you want to starting up a database by using STARTUP command....SQL>STARTUPto start instance, database must read the intialization parameter from either a server parameter file(SPFILE)or a trad...

Answer Question  Select Best Answer

This is an Interview Question By BMC Software.. " while installing the Oracle 9i ( 9.2) version, automatically system takes the space of approximately 4 GB.. thats fine.... Now, if my database is growing up and it is reaching the 4GB of my database space...Now, i would like to extend my Database space to 20 GB or 25 GB... what are the things i have to do " Pls give me the accurate Solutions or alternates...

sonaligujral1

 Profile Answers by sonaligujral1 Questions by sonaligujral1

• Aug 9th, 2010

Here comes the concept of database capacity planning

alex.v

 Profile Answers by alex.v Questions by alex.v

• Jul 11th, 2008

Better make the autoextend off and add more datafiles to the tablespace. Making a single datafile to a bigger size is risky...By making autoextend off you can monitor the growth of the tablespace....schedule a growth monitoring script with a threshhold of 85 % full

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

Select file_name, tablespace_namefromdba_data_files;

ravichandiran

• Nov 16th, 2007

run this query in the sql promptsql> select tablespace_name,file_name from dba_data_files;

Answer Question  Select Best Answer

If Several databases are up and running, which command will help to monitoring in os ?

saneshkale

 Profile Answers by saneshkale Questions by saneshkale

• Apr 5th, 2010

Ps -ef|grep pmon

tendulkar

 Profile Answers by tendulkar Questions by tendulkar

• Mar 27th, 2010

Df -h

Answer Question  Select Best Answer

As a Oracle DBA what are all the UNIX file you should be familar with?

pandish

 Profile Answers by pandish Questions by pandish

• Dec 31st, 2010

/etc/hosts/etc/passwd/var/opt/oratab/var/adm/messages (Solaris) var/log/messages(Linux)df -k (df -h on Solaris 5.10+)

fnlin

 Profile Answers by fnlin Questions by fnlin

• Oct 31st, 2010

The question refers to a "file", not a process. As far as file, DBA should check the file system capacity and usage via "df -hk ." command (or "df -hk /db?", if the datab...

Answer Question  Select Best Answer

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

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 6th, 2009

Synonym is a alias name for an Oracle object. It can be simplified names to access the objects. Example of Synonym and how it is useful Employee is a table is HR Schema A user wants to access the...

waseemvnb

 Profile Answers by waseemvnb Questions by waseemvnb

• Nov 12th, 2007

It is just like Aliasing .. ie giving some name in order to specicifically distinguish it....In other words to simplify the names of tables , column names etc it is used.. Suppose i have a column name...

Answer Question  Select Best Answer

hmounir

 Profile Answers by hmounir Questions by hmounir

• Dec 27th, 2009

1- a private synonym is defined in the schema of a user and is available only to the user.2- a public synonym is usually created by dba and is available for use by any database user.

praveena

• Sep 12th, 2005

Two types of synonims.1.public synonim,2.private synoniim.private synonym is confined to a particular user.public can be used by all the user's.

Answer Question  Select Best Answer

Taj_N

• Jul 16th, 2007

An Index is based on tree structre that allow direct access to a row in a table, oracle uses different type of index 1) B-Tree Index2) Bitmap Index

srujana

• Aug 23rd, 2005

It is created in existing table to locate rows more quickly&efficiently. the users cannot see the indexes,they are just used to speed up the queries

Answer Question  Select Best Answer

dhussainpathan

• Apr 9th, 2007

The Redo log files records the changes made  to the database in the form of REDOLOG entries, which are helpful at the time of Database Recovery Process.

rajesh chadalawada

• Dec 2nd, 2006

     Redo Log is ment to trce or note  the modifications that are applied to data buffer cache it will note on folloing situations1)for every 3 seconds2)when redo log buffer reaches to 1MB3)before db_cache writes data to datafiles4)when ever commited

Answer Question  Select Best Answer

A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in the deadlock, thus releasing one set of data locked by that statement. Statement rolled back is usually the one which detects the deadlock. Deadlocks are mostly caused by explicit locking because oracle...

Karthikeyan Balakrishnan

 Profile Answers by Karthikeyan Balakrishnan Questions by Karthikeyan Balakrishnan

• May 23rd, 2011

One process waiting for another process which never ends is known as deadlock.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 17th, 2007

 Deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically ...

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

Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns NULL in the value column if you are using pfile and not spfile3) SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL; // if the count is non-zero then the instance is using a spfile, and if the count...

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

Select * from v$parameter where name='spfile';

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

show parameter spfile; if the output will be similar to the following, then it means that the instance is using SPFILENAME TYPE VALUE-----------------------...

Answer Question  Select Best Answer

Tony

• Oct 25th, 2006

Thanks for the information!

Chinny

• Sep 28th, 2006

Sharedpool contains 3 memory layers.1.Library cache: 2.Data dictionary cache3.UGA

Answer Question  Select Best Answer