There are show many hard disks attached in system, how i know a particular disk information in solaris operating system?

i am in a dilemma in thinking how different types of cursors are useful in applications.

like dynamic scrollable cursors are used where result set changes are reflected like in airline reservation system..
but can you tell me the usage of insensitive scrollable cursor(in which application) in real world..

and when to use unscrollable cursors(even though scrollable are...

Hi there..

I have 2 date fields in my table. I want to subtract these 2 date fields to get the result in hour and minute.

Below is what I have and what I am doing but the result is not as I want..
Date1 Date2 date2-date1*24 (is what I am doing)
21-06-2011 14:00:00 21-06-2011 16:55:00 2.9166667

Rule-based and Cost-based.

The   OPTIMIZER_MODE   initialization  parameter  Statistics  in  the  Data Dictionary  the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.

The  Optimizer  chooses  Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

This  value  causes  the  optimizer to the cost-based approach for  all SQL statements  in  the session regardless of the presence of statistics and to optimize with a goal of best throughput.

Choosing an executing planbased on the access paths available and the ranks of these access paths.

Considering  available  access  paths  and  determining  the most efficient execution  plan  based  on statistics in the data dictionary for the tables accessed by the statement and their associated  clusters and indexes.