What tuning indicators can one use?

prahlad_786

 Profile Answers by prahlad_786 Questions by prahlad_786

• Jun 25th, 2010

The following high-level tuning indicators can be used to establish if a database is performing optimally or not: • Buffer Cache Hit Ratio Formula: Hit Ratio = (Logical Reads - Physical Read...

Answer Question  Select Best Answer

How does one use the import/export utilities?

nafees

 Profile Answers by nafees Questions by nafees

• Jul 22nd, 2008

Logical Backup using export utility works as an alternative backup method.we can export from one user and import into another within the same database.we can export from one database and import into a...

Answer Question  Select Best Answer

How to monitor how fast a table is imported? How to modify data as it loads into the database?

Ramshankardba

 Profile Answers by Ramshankardba Questions by Ramshankardba

• Jan 17th, 2009

Use below script to monitor how speed import is happening.SELECT SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name, rows_processed, ROUND( (sysdate-TO_DATE(first_load_time,'yyyy-mm-dd hh24:mi:s...

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

How to load data into multiple tables at once?

vijaykaushik

 Profile Answers by vijaykaushik Questions by vijaykaushik

• Dec 31st, 2008

You can use SQL loader to do this. Using the When condition in SQL Loader control file this is possible.

Answer Question  Select Best Answer

What do you do when tempdb is full?

hari_97us

 Profile Answers by hari_97us Questions by hari_97us

• Nov 26th, 2009

You need to clean up the space and add more space in order to prevent this error in future.

Answer Question  Select Best Answer

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in No-Archive log mode. How can the database be recovered?

vijaykaushik

 Profile Answers by vijaykaushik Questions by vijaykaushik

• Dec 31st, 2008

This can be easily done but you will loose the data if you don't restore from backup.If you have a backup of datafiles and controlfile then restore them.If you don't have the backup then you n...

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

If one user is already updating the table and it has a lock, the other user cannot access the table to update. then why and how the deadlock situation arises ?please explain with example.

prahlad_786

 Profile Answers by prahlad_786 Questions by prahlad_786

• Jun 25th, 2010

When 2 different  DML executed on the same resource then it leads to dead lock.Example:If a resource locked by user A and it also need resource which is locked by user B. B also need a ...

Answer Question  Select Best Answer

Outline the steps required for physical standby database creation?

nafees

 Profile Answers by nafees Questions by nafees

• Jul 21st, 2008

Hi all,IT IS POSSIBLE WITH THE HELP OF DATA GUARD.To  create a physical standby database ,the standby databse should be in MRM(Managed recovery mode)Let  we proceed with an example, let ...

Answer Question  Select Best Answer

What are the differences between database designing and database modeling?

ramu541

 Profile Answers by ramu541 Questions by ramu541

• Sep 12th, 2008

Effective database design can help the development team reduce overall development time and costs. Undertaking the process of database design and creating a data model helps the team better understand...

Answer Question  Select Best Answer

Three users at a time giving the following command: alter database backup controlfile to trace; How can you differentiate the file using the filename itself?

baala

 Profile Answers by baala Questions by baala

• Aug 11th, 2008

When you issue the command "alter database backup controlfile to trace ; " a trace file will be created in the user_dump destination.The default name of the trace file would look something similar to ...

Answer Question  Select Best Answer

When exporting using filesize parameter, if three files is generated. How the Oracle name this three files?

jp1985verma

 Profile Answers by jp1985verma Questions by jp1985verma

• Oct 22nd, 2009

When Export reaches the value you have specified for the maximum FILESIZE, Export stops writing to the current file, opens another export file with the next name specified by the FILE parameter, and c...

Answer Question  Select Best Answer

What are the different scenarios for rebuilding indexes...

chandubtech

 Profile Answers by chandubtech Questions by chandubtech

• Aug 2nd, 2008

Actually you need to rebuild the indexes for 2 main scenarios.1)deleted entries represents 20% or more of the current entries2)the index depth is more than 4 levelsOracle index nodes are not deleted p...

Answer Question  Select Best Answer

how to change the log_archive_format parameter in pfile if corresponding issys_modifiable parameter is "FALSE"
give me the full step by step procedure.


Thanks
Gyan

Srinivasa Reddy

• Aug 18th, 2011

As per Oracle document if the parameter value in ISSYS_MODIFIABLE column ( in v$parameter view ) is ... *IMMEDIATE - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter fil...

Answer Question  Select Best Answer

How to collects the "current" redolog members(redo group) if these are physically deleted. There is no backup and NARCHIVELOG mode in database

Mohammed irfan Hussain

• Feb 8th, 2016

The moment you start the instance the smon gets started and collects redolog member data to datafiles. i,e crash recovery.

Answer Question  Select Best Answer

Mane

• Jul 8th, 2005

It can be, the only required option is that your tablespace have quota assigned to any user that want to store objects in it.

S.Velusamy Raja

• Jul 6th, 2005

Wish to know It can be or can not be. 

Answer Question  Select Best Answer

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 6th, 2009

Yes a view can be based on another view. For example data dictionary views can be used to create another view in order to improve better access.

soccer_champ

• Jun 18th, 2005

Yes, a view can be based on another view.

Answer Question  Select Best Answer

ashu_641981

 Profile Answers by ashu_641981 Questions by ashu_641981

• May 24th, 2011

Sequences are special database objects that provide numbers in sequence for input to a table.

soccer_champ

• Jun 18th, 2005

A sequence is a database object created by a user that can be used to generate unique integers. A typical usage of sequences is to generate primary key values which are unique for each row.  It i...

Answer Question  Select Best Answer

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 7th, 2009

Public synonym is a synonym which may not resodes in the owner schema.but it works as a same. to create public synonym we need special privileges

soccer_champ

• Jun 18th, 2005

A public synonym is owned by the special user group named PUBLIC and every user in a database can access it.  In case of doubt, contact me : bobby_1020@hotmail.com

Answer Question  Select Best Answer