janardhan akki

• Sep 26th, 2012

In Case of normal views when ever u call the view it will get data from base table......

in case of pipeline view: if u call the view it vil get data from another view .....means it also logically getting data from base tables only.......the inner view may be materialized view....

Answer Question  Select Best Answer

RAM

• Aug 8th, 2012

TOAD,PUTTY WITH LIINUX/UNIX ,ORACLE FORMS,ORACLE REPORTS.

srikanth

• Jul 22nd, 2012

Toad, Putty,Bmc remedy

Answer Question  Select Best Answer

DURGAPRASAD

• Jul 24th, 2012

Code
 

Diptiman Badajena

• Mar 29th, 2012

Try this one:

Code
 

Answer Question  Select Best Answer

You have a batch job which has hundreds of SQL queries in it. Earlier is was finishing in expected time. However, now it is taking twice the time. There is no CPU utilization issue due to other jobs. How would you know that which of the queries are taking more time now and why?

Nagaraj Teli

• Jul 22nd, 2012

Please find the below methods for finding one of the query which is taking longer time in the batch script. Methods :- 1) Put the dbms_output after each of the SQL query. 2) Create a logfile using th...

koushikinath

 Profile Answers by koushikinath Questions by koushikinath

• May 24th, 2012

1. At first enable the trace, at the beginning of the sqls.
2. Then check the trace file.
3. Using tkprof create the output file.
4. According to explain plan check the elapsed time for each query.
5. Then tune them

Answer Question  Select Best Answer

Snehal

• Jul 10th, 2012

View : View exists logically.Its a virtual table.Whenever we are firing a query on a view we are getting a data from a table. But for a snapshot it is not a case... snapshot itself store a data.. refr...

ravinder lathwal

• May 15th, 2012

Snapshot is just like print screen. or materialized view is actual table.
snapshot is read only.you will find it same stage every time.
but materialized view is update mode.always you will find it a new stage.

Answer Question  Select Best Answer

santosh

• May 21st, 2012

UNDO tablespace contain the old information. it is circular process. it will overwrite the first extents. so if you need the overwritten statement that time it will show as snap_shot is to old.

oradebug

 Profile Answers by oradebug Questions by oradebug

• Jul 25th, 2009

First you have to understand that Oracle is a MVCC (multiversion concurrency control) or "repeatable read" database system.? Queries are returned with all rown consistent with respect to the point in...

Answer Question  Select Best Answer

You have a very large query say of 2000 lines. How would you check if the indexes are being used or not. Would you read all the lines of explain plan in plan table to get it? If yes, will it be feasible? Do you have any other method of checking this?

raghuvir Khanna

• May 10th, 2012

We can moniter the use of indexed with the help of view V$object_usage simple we need to use
Alter index monitoring usage;
select tablename,indexname ,used from V$object_usage ;

Sam

• May 7th, 2012

Check and resolve join with the largest cost

Answer Question  Select Best Answer

If in PL/SQL Autonomous transaction, you get error then how will you role back the main transaction?

Mohammad Jarwan

• Apr 9th, 2012

Used in table trigger to execute update statement for same table.

dhiren21

 Profile Answers by dhiren21 Questions by dhiren21

• Sep 20th, 2009

Before this Ask a Question to your Self... What are you Updating?When You Updated this?How you are updating?Then? Check the Commit?Point if commited not possible to rollback normally.Steps :::? Restor...

Answer Question  Select Best Answer

How to create LOV dynamically at runtime & attach to text field?

SHAHNAWAZ MUZAFFAR

• Mar 10th, 2012

We can use Dynamic LOV through assigning into a global variable and using this global variable into our sql statement.

Answer Question  Select Best Answer

How to find the startup time of instance?

kishore

• Nov 15th, 2011

How to get instance startup time


>select to_char(startup_time,'dd-mon-yyyy HH12:MI:SS ')"db startup time"
2 from sys.v$instance;

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 22nd, 2010

Use this simple command in SQLPlus or an a query retreival tool of your choice. select To_char(startup_time, 'Mon-dd-yyyy hh24:mi AM') as STARTUP_TIME from v$instance;

Answer Question  Select Best Answer

How will you find the total number of databases present in our system via LINUX OS?

Richard Naveen

• Oct 31st, 2011

Etc/oratab

subrahmanyam pattapu

• Jul 20th, 2011

We can find which databases are running in server. by using the following command.

ps-ef|grep smon

It will show the databases is up and running.

Answer Question  Select Best Answer

Explain what are Oracle Catlog & Oracle Archive Log ?

jazz

• Sep 20th, 2011

When the log writer writes into the redo logs i.e online redo logs in circular motion.when one redo log is full it switches to another redo log , at this point of transfer it is called log switch.

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

oracle catalog used for recovery purpose in RMAN our target database registered in catalog and storing metadata for the target database. Archivelog is also used for recovery purpose but its store red...

Answer Question  Select Best Answer

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

We can not delete responsibillity but we can disable the responsibility from user so that user can not use this resp he is not authorised to use particular responsibility.

psicre

 Profile Answers by psicre Questions by psicre

• Jul 22nd, 2010

You cannot delete reps in EBS....

Answer Question  Select Best Answer

What is meant by Remote Backup?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Suppose as a client u connected to server with the help of some third party tool and you are going to take backup from your server then that is called remote backup.

Answer Question  Select Best Answer

Explain in detail what are bdump, cdump & udump?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

background dump (bdump) :--. > bdump is used for all the issues raised related to background process in our database. its also contain alert .log which contain all activities and issues related to da...

Answer Question  Select Best Answer

What is the use of catalog and no catalog in RMAN?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Rman with catalog means our target database registered in catalog and its used for recovery purpose. its containing metadata about to database.

rman with no catalog means metadata stored in controlefile through the controlfile we can do the recovery.

Answer Question  Select Best Answer

How to repair the tnsnames.ora file.
File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine.

dbxplorer

 Profile Answers by dbxplorer Questions by dbxplorer

• Jul 21st, 2011

Delete or rename the older file and try to recreate it using "netmgr" using proper information of your database.

Answer Question  Select Best Answer

How to give private and public database links ?What is syntax for that ?What means mutation in oracle??

dbxplorer

 Profile Answers by dbxplorer Questions by dbxplorer

• Jul 21st, 2011

Database link is the pointer that allow users to access other user's object in remote database. This is one way communication path using database links. Private db links: CREATE DATABASE LINK link_na...

Answer Question  Select Best Answer

vinoth

• Jul 15th, 2011

Giving privilege to the user

sreekanth.g

 Profile Answers by sreekanth.g Questions by sreekanth.g

• Jun 22nd, 2011

Assume that table 'emp' is created by user scott.by using grant command he can grant privileges to other users.If he want to provide a privileges to grant the privileges to other usershe has to grant a privileges with grant option.

Answer Question  Select Best Answer

How to take backup using RMAN backup, without catalogdb?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 6th, 2011

First you connect to oracle usersu - oracle2then goto cd $ORACLE_HOME/bintype rmanRMAN> connect target;          >  backup database plus archivelog;

smmdba

 Profile Answers by smmdba Questions by smmdba

• Jul 7th, 2008

 How to connect to RMAN without catalog

Answer Question  Select Best Answer