azam.irshad

 Profile Answers by azam.irshad Questions by azam.irshad

• Jan 2nd, 2008

A process that runs on each of the nodes. It functions as the executor of jobs and events sent by the console by way of the mangement server. High availability is ensured since the agent can function regardless of the status of the cosole or network connections

Answer Question  Select Best Answer

azam.irshad

 Profile Answers by azam.irshad Questions by azam.irshad

• Jan 2nd, 2008

Sets of free lists available for use by one or more instances.When data is frequently inserted into a table from multiple nodes and the table is not partitioned, use free list groups to avoid performa...

Answer Question  Select Best Answer

what are the necessary steps to be take when server gets down? How can we increase size of a database?

subha gunasekaran

 Profile Answers by subha gunasekaran Questions by subha gunasekaran

• Jun 5th, 2008

1.Bring up the server. 2.Run the profile of the database 3.Bring up the database. 4.In server prompt, check ps- ef | grep pmon - This is used to check whether the database is up or not. 5.Bring u...

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

You can make use of VSIZE function to get the number of bytes in the internal representation of individual field. However this cannot be applied on fields that has BLOB data type and in such case you have to use dbms_lob.getlength function on BLOB data type field.

Answer Question  Select Best Answer

How will you check the database status from os level in a unix env ?consider that some of the instances are in mount state; hence checking the pmon os process will be vain..? Need a unix os command to check if the databases are up and running

mangeshchede

 Profile Answers by mangeshchede Questions by mangeshchede

• Mar 21st, 2010

Use the command $ps -ef | grep ora_

Answer Question  Select Best Answer

.

raja_wipro

 Profile Answers by raja_wipro Questions by raja_wipro

• Dec 2nd, 2008

In Oracle 10G we do not have Bitmap Index . Bitmap index  is available only in Oracle9i Enterprise Edition

Answer Question  Select Best Answer

What is High Water Mark in Oracle?

DPsireesha

 Profile Answers by DPsireesha Questions by DPsireesha

• Feb 24th, 2009

The High Watermark is the maximum fill-grade a table has ever reached. The blocks above high water mark are empty blocks.Initially when you create a table the high water mark is the first block. When ...

Answer Question  Select Best Answer

What will happen in database if your like hard disk crashes & what will be your next step to recover that database?

mangeshchede

 Profile Answers by mangeshchede Questions by mangeshchede

• Mar 21st, 2010

If your Harddisk gets crashed then If your Database is in Archive Log Mode, you should recover your database by applying all Archives or by restoring the latest backup.

Answer Question  Select Best Answer

How will you find out if your database is using recovery catalog or not?

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

Using catalog database we can find if the database registered or not in recovery catalog database? SELECT * FROM rc_databaseWhere we can find all the registred databases;

Answer Question  Select Best Answer

What are contents that are not saved in alert log file? What happen when alert log file is full?

dbashashi

 Profile Answers by dbashashi Questions by dbashashi

• Oct 8th, 2010

Almost all the event against the database which may hinder its smooth operation is captured in Alert Log file as error messages.Oracle creates a new alert log files if you delete the current one after taking backup for future reference.Shashi b Singh

Answer Question  Select Best Answer

how to see some selected lines in alert log file in unix environment.

like tail -100f alert_SID.log we can see only 100 lines but i need to see the lines between 300 to 500 from down .

muthu5047

 Profile Answers by muthu5047 Questions by muthu5047

• Sep 3rd, 2011

Assuming you need lines 20 to 40,

sed -n '20,40p' file_name

or

awk 'FNR>=20 && FNR

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

Online backup also known as hot backup / open backup can be performed even the database is open and while users are working and is available for read and write activity. To perform Online backup, the ...

Answer Question  Select Best Answer

Why we use Sort_area_size parameter in init.ora file?Kindly let me know?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

SORT_AREA_SIZE is one of the deferred Oracle Server Parameters which is set in init.ora. Its value as bytes (integer) sets the size of in-memory sort work area. The default is 64K and the maximum valu...

Answer Question  Select Best Answer

If have 50 inactive session and i want to to kill all session at once tell me the procedure to kill all 50 session at once

muthu5047

 Profile Answers by muthu5047 Questions by muthu5047

• Sep 3rd, 2011

in our project to kill all the inactive session we use the following script.. run the sql script given below it will give u all inactive sessions sid and serial no and redirect output to (inactive_kil...

Answer Question  Select Best Answer

Harieshsivam

 Profile Answers by Harieshsivam Questions by Harieshsivam

• Oct 13th, 2011

Show sga;

we can see the memory of SGA space

Answer Question  Select Best Answer

mary

• Jun 7th, 2012

Backup can be taken in 3 ways 1)Cold backup 2)Hot Backup 3)RMAN Backup 1)For taking cold backup we need to shutdown database.So it is not advisable 2)Hotbackup can be taken while the DB upon running...

Answer Question  Select Best Answer

I am new here and i am not sure if I am posting this in the correct place. But I have recently started studying to be a programmer but because there is so much out there between these two I am getting more and more confused about how to answer this. Could someone please answer these so I can at least get my head around it all? Thank you!! This is what the questions are:

After initial...

Tom Haughey

 Profile Answers by Tom Haughey Questions by Tom Haughey

• Apr 30th, 2012

I will refer predominantly to Relational DBMS. In a file system, data is contained in a flattened structure that is often a variable length structure. For example, a shipment received could contain th...

Answer Question  Select Best Answer

NEERAJ KHANNA

• Oct 2nd, 2013

Checkpointing is nothing but give the signal / instruction to DBWN process to write the date from the database buffer cache to the datafile and after this ckpt process also update the SCN number in the header of data file and control file also.

FYIP

Answer Question  Select Best Answer

In a given relation R, If an attribute A uniquely define all other attributes, then the attribute A is the key attribute which is also known as

1. Functional key
2. Foreign key
3. Candidate key
4. All of the above

Nandini

• Mar 9th, 2015

Candidate key

Answer Question  Select Best Answer

Akbar Yuldoshev

• Jun 18th, 2016

By allocate_extent_clause

Answer Question  Select Best Answer