Re: Buffer use under Oracle

On Wed, 12 May 2004 13:28:00 +0100 M.K.Jha_at_ponl.com wrote:

:>Hi,
:>can u send the output of following query...
:>after that tryt to explain ... your Q?

:>select rpad(a.index_name,30),rpad(a.column_name,30), b.NULLABLE ,
:>rpad(a.column_position,5)
:>from all_ind_columns a, all_tab_columns b
:>where a.table_name like upper('&tab') and
:>a.table_name=b.table_name and
:>a.column_name=b.column_name
:>order by 1,4;

The index columns are non-nullable. One column is a timestamp.

What should this be telling me?

--
Binyamin Dissen <bdissen_at_dissensoftware.com>
http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------