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

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

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 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

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

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

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

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

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

DURGAPRASAD

• Jul 24th, 2012

Code
 

Diptiman Badajena

• Mar 29th, 2012

Try this one:

Code
 

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

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

What does Error 0600 mean?

ashokgaddipatidba

• Oct 15th, 2012

These are the internal errors. we have to contact Oracle Support

Answer Question  Select Best Answer

What is the actual processing being done at backend or server side to retrive the data or complete the DML operation.

KSPradeep Rayavarapu

• Jan 28th, 2013

The order of Query Execution is following
1)From Clause
2)Where Clause
3)Group By Clause
4)Having Clause
5)Select
6)Order By Clause

Sachin Garg

• May 22nd, 2012

Hi Friends, When we pass a SELECT query it executes under some phases. That includes 1) Checking by Server Process - Which type of Query is this - Sql or Pl/sql. 2) If sql - server process puts the ...

Answer Question  Select Best Answer

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

We need to use triggers whenever we wish to perform an automatic operation on a DML query. In our organization we have Unix and OpenVMS servers. Due to some reason, Unix server is used to send and re...

talktobishu

 Profile Answers by talktobishu Questions by talktobishu

• May 20th, 2013

We use trigger when we want some event should happen automatically on certain desirable scenario. Lets take an example. You have a table which changes frequently,now you want to know how many times a...

Answer Question  Select Best Answer

Can we pass a function name as a parameter value?? will it have any effect in performance degradation when used in a Large online transaction process?

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

About performance, it depends upon the computations you will be performing inside that function. Also, if we are using (user-defined) function in SQL (rather than creating PL/SQL), then it will give better performance.

While using user-defined functions, we need to avoid Mutating functions error.

murugesan

• Jan 19th, 2013

Yes we can pass but the function should return a value of type appropriate for the calling function

Example

round(trunc(100))

Answer Question  Select Best Answer

If you have an open cursor on a table, modify the same table and commit, what would happen?

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not be selected in that operations.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not...

Answer Question  Select Best Answer

In order to 'Compute Sum' clause in the SQL reports which of the following is mandatory1) Break on 2) Order by 3) Set page size 4) Set feedback

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

Break and compute are required, but for spooling output you should be using all the another 3 functions.

Gaurav Saxena

• Apr 24th, 2013

Break on is compulsory for compute function.

Answer Question  Select Best Answer

Rahul

• Jul 11th, 2013

It retrieve or fetch all data from Emp table,and show all data of table like Emp as result.

vaasukk@yahoo.com

• Dec 13th, 2012

First it will check the syntax and semantics in library cache, after that it will create execution plan. Already data in the buffer cache it will directly return to the client. If not it write the fetched to the dB buffer cache after that it will send server. Server sends to the client.

Answer Question  Select Best Answer

1. Queries for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query?

mahesh

• Aug 12th, 2013

Code
 

priyank

• May 10th, 2012

Use Case in update statement

Answer Question  Select Best Answer