RE: problem with trunc()

ssible) or pl/sql block to shortcut this behavior. I hope this helps you.  Guy Harrison's book (ISBN 0136142311) is an excellent starting point for learning about the intricacies of tuning sql. there is a newer version than this one I am referencing though. have a great weekend. Lisa Koivu Or

RE: problem with trunc()

I don't see why you need to trunc the data. Have you tried that?  did you get the same miserable performance, and the same type of plan? Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged,

RE: Auto Extend

riginal Message- From: Lisa Koivu [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 10:08 AM To: Multiple recipients of list ORACLE-L Subject: RE: Auto Extend Hi Ron, do you have large files enabled on your system? What unix are you running?  if large files are not enabled you'

RE: Resizing Log file

t two logs in each group, unless you don't want to keep your redo logs :) Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to thi

digital tru64 unix

;t see what I'm looking for (yet). Thanks in advance Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail me

RE: select question

Title: RE: select question I believe you'll want to rpad your return value. select rpad(26.5,5,0) from dual returns 26.50 or format it in SQL*Plus. HTH Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confide

RE: Auto Extend

I'd never do that, but it's just my personal preference. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electr

RE: what's hash-join

en nested loops join.  It works well with small to medium-sized tables. Just my .02 List, if I'm wrong, please correct me. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is int

RE: problem with trunc()

TRACE TRACEONLY EXPLAIN and execute the query.  It will just give you the plan. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this int