HDTenEightyP/NetNews huggingface dataset:
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases.oracle
Subject: Re: Problem with date fields
Date: 29 Sep 92 23:32:09 GMT
Article-I.D.: kip-sn-4.carl.pedersen-290992192618
Followup-To: comp.databases.oracle
Organization: Dartmouth College

In article <shamel.717774532@tdsb-s>, shamel@mais.hydro.qc.ca (Stephane
Hamel) wrote:
> 
> 
> According to the Oracle documentation, you can use quoted dates to qualify
> records in a WHERE clause where the column data type is DATE. We have found
> that this behavior is not always correct, so we changed our programs
> to use TO_CHAR(field,'DD-MON-YY'), which make no use of the index (of course
> assuming the index contain the date field).
> 
> Our Oracle versions are:
> 	SQL*Plus: Version 3.0.9.1.2
> 	ORACLE RDBMS V6.0.33.1.1
> 	PL/SQL V1.0.32.3.1
> 
> Can somebody explain why DATE fields have such a behavior:
> 
> 1) Table description:
> 
> 	SQL> desc sample_table;
>  	Name                            Null?    Type
>  	------------------------------- -------- ----
>  	CODE_OUVRAGE                    NOT NULL CHAR(10)
>  	DATE_MESURE                     NOT NULL DATE
>  	TYPE_LECTURE                             CHAR(1)
>  	INSPECTEUR                               CHAR(9)
> 
> 2) Sample query #1:
> 
> 	SQL> r
>   	1  SELECT code_ouvrage, date_mesure
>   	2  FROM   sample_table
>   	3  WHERE  code_ouvrage = 'CD-00'
>   	4* AND    date_mesure = '22-SEP-92'   /* Should work, according to doc.
> 
> 	no rows selected
> 
> 3) Sample query #2:
> 
> 	SQL> r
>   	1  SELECT code_ouvrage, date_mesure
>   	2  FROM   sample_table
>   	3  WHERE  code_ouvrage = 'CD-00'
>   	4  AND    date_mesure =               /* Should work, but useless
>         5*        TO_DATE('22-SEP-92','DD-MON-YY')
> 	
> 	no rows selected
> 
> 4) Sample query #3:
> 
> 	SQL> r
>   	1  SELECT code_ouvrage, date_mesure
>   	2  FROM   sample_table
>   	3  WHERE  code_ouvrage = 'CD-00'
>   	4* AND    TO_CHAR(date_mesure,'DD-MON-YY') = '22-SEP-92'
>                   /* Work, but make no use of the index and make an unnecessary
>                   /* data type conversion
> 	
> 	CODE_OUVRA DATE_MESU
> 	---------- ---------
> 	CD-00      22-SEP-92
> 	CD-00      22-SEP-92
> 	CD-00      22-SEP-92
> --
>  Stephane Hamel (SHamel@Mais.Hydro.Qc.Ca) | AutoControl Inc.
>  Senior Programmer-Analyst                | Montreal, Quebec, Canada

Your DATE fields must include the time.  If you want to store just the date
(with a time set to midnight, 00:00:00), store TRUNC(SYSDATE) instead of
SYSDATE.  You can also compare to trunc(date_mesure), but as you point out
this will defeat the use of any index.

[Anybody know what the standard procedure is for setting up a FAQ list?  I
might be willing to maintain such a thing.  I assume mine will be one of
numerous replies.]
From: tdonnell@ncrsoph.Sophia.NCR.COM (Tom Donnelly)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle file managerCLOSE
Date: 5 Oct 92 09:00:56 GMT
Reply-To: tdonnell@ncrsoph.Sophia.NCR.COM (Tom Donnelly)
Organization: NCR European Development Center

In article <FDaZRB1w165w@netlink.cts.com> tumidity@netlink.cts.com (Joel Garry) writes:
>sstephen@us.oracle.com writes:
>> 
>
>I seem to recall reading that you can mount the oracle database "raw"
>on a unix system, and it would run faster.  Anybody have any actual
>experience with this?  And is it in ORACLE7?
>

  Yes, you do get a boost in performance by using raw devices for your database
  files.  The amount of a boost you get is always been up for debate.  Some 
  people say you can get 25% performance increases after moving from file system
  data files to raw devices.  This number should be disputed though, as moving
  from file system database files to raw devices requires doing a full export,
  creating a new database on raw devices, and a full import.  This puts all of
  your table in contiguous blocks.  I think 10% to 15% is more likely, depending
  on your disks, file system, and probably the version of the os. Sorry I can't
  help you with Oracle V7, but I probably won't see a copy of that unitl the
  middle of next year.  

  To set up a 'raw' device as an Oracle data file, you must change the
  permissions and ownersip of the raw device to be used.

  For example, to set up a raw device for /dev/rdsk/c0t3d0s2

	as root:	chown oracle /dev/rdsk/c0t3d0s2
 			chgrp dba /dev/rdsk/c0t3d0s2
			chmod 660 /dev/rdsk/c0t3d0s2

  Then, to utilize the partition, just put the raw device file name in place of
  the datafile name in the CREATE TABLESPACE or ALTER TABLESPACE command.

  If you are converting an existing database, you must perform a full database
  export, create a new database utilizing raw devices, and then perform a full
  database import.

  Bon Chance!
--------------------------------------------------------------------------------
Tom Donnelly               | WIN: Tom.Donnelly@Sophia        | Its ok - my boss
NCR Europe Group ISS       | UUCP: ..ncrcom!ncrsoph!tdonnell | doesn't believe 
Sophia Antipolis, Valbonne |                                 | me either.
France, 		   | TEL: 33-92 94 45 40             |
			   | FAX: 33-92 94 45 45             |
From: rthorstr@doc.bmd.trw.com
Newsgroups: comp.databases.oracle
Subject: Re: TRIFOX and SQL*Forms compiler
Date: 29 Sep 92 07:38:24 MST

To all those who ask that I post any info I receive about TRIFOX and their 
SQL*FORMS 3.0 compiler:

   Address:   TRIFOX INC.
              2600 Campus Drive
              San Mateo, CA 94403

   Sales Rep:  Don Strong
               415-513-5924

   FAX:  415-513-5999

Apparently TRIFOX has several tools that allow you to develop products that
allow independence from any one particular RDBMS.  The applications can
access Oracle, Rdb, Sybase, Informix, Ingres, and Allbase.  

The product I heard about from InfoWorld which caught my interest was the
SQL*Forms 3.0 compiler.  The compiler will compile a form created with
SQL*Forms which then makes it possible for the form to access any of the 
databases mentioned above.

I talked to Don Strong on the phone.  He was very helpful and sent me a
packet full of information.  If you have any questions give him a call.

Thanks to Robert Cringely of InfoWorld for his help in putting me in touch
with TRIFOX.

                                     Rod Thorstrom
From: joe.bartling@sqlware.uunet.UU.NET (Joe Bartling) 
Newsgroups: comp.databases.oracle
Subject: TEST MESSAGE
Date: 24 Sep 92 01:44:00 GMT
Distribution: world
Organization: SQLWare Inc., Leesburg, VA - (703) 771-3979
Reply-To: joe.bartling@sqlware.uunet.UU.NET (Joe Bartling) 

This is a test message.  Sorry.
From: johnh@nnshh127.uucp (John Hawkins)
Newsgroups: comp.databases.oracle
Subject: Packet Switching
Date: 3 Oct 92 00:37:48 GMT
Organization: Northern Telecom Inc., Nashville, TN


        My manager came to me with an interesting item, he stated when our 
users telnet in to our oracle application the packet switching contained
only one character per packet.  Hmmm this gets expensive when we are charged
by the packet over our net.  So of course before I knew what hit me I am
to find out the reason's behind this.  Now I know the basics of tcp/ip
but haven't really done any serious network programming.  So would somebody
point me in the right direction?  We are on hp800 series boxes with mac241
used to telnet into the host.  The real concern is uping the packet content
to the max number of bytes per packet.  

thanks again to everyone,

John Hawkins

Please reply to: nvjhh01@NT.COM

disclaimer: I Heard it through the Grapevine.
From: Neil Greene <deepthought!neil@ms.uky.edu>
Subject: Re: SQL*ReportWriter order by clause
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.
Date: Sat, 26 Sep 1992 23:50:36 GMT

In article <1992Sep25.235459.1@us.oracle.com> sstephen@us.oracle.com  
writes:
> In article <1992Sep25.170736.2535@deepthought.uucp>, Neil Greene  
<deepthought!neil@ms.uky.edu> writes:
> > I have an oracle database with approximatley 500,000+ records  
consisting  
> > of lname, fname, mname, ss, birthdate.
> > 
> > I would like to sort these records in lname, fname order.  However,  
> > sorting this many records in this fashion seems to take forever.   
Closer  
> > magnitude of non-existant.  
> > 
> > Is there some way I may better optimise the use of indexes?  
> > 
> > I have the following index, but things are still S_L_O_W:
> > 
> >> create index I_MASTER$FLNAME on
> >> 	MASTER(LNAME, FNAME)
> >> TABLESPACE NASRIS_INDEX
> >> PCTFREE 10
> >> storage (initial 10M next 1M
> >> 	maxextents 99
> >> 	pctincrease 0);
> 
> I don't think storage is going to effect performance until after you  
start
> updating the LNAME and FNAME columns of your table.
> 
> The trick is not to sort the records at all!  If you have an index AND a
> sort clause it has to sort the records all over again when the index had  
been
> keeping everything in sorted order all this time for you anyway.  So,
> 
> Select LNAME,FNAME,MNAME,SS,BIRTHDAYE
> from MASTER
> order by LNAME,FNAME;
> 
> -- is going to be slow.
> 
> Select LNAME,FNAME,MNAME,SS,BIRTHDAY
> from MASTER
> WHERE LNAME >= CHR(1);
> 
> -- should be about as fast as you can go, (as long as it does a long  
index
> scan).  As an example, here is a quick check against a sample database  
chosen
> at random :
> 
> Select count(*) from SYS.COL$ order by OBJ#;
> 
> real: 0.6100
> 
> Select count(*) from SYS.COL$ where OBJ# >= 0;
> 
> real: 0.2300
> 
> Almost 3 times as fast.  Of course, this is taking advantage of some  
internal
> knowledge, but it should be good enough for faster reports.  And a  
disclaimer
> ... individual results may vary!

Adding a WHERE clause improved performace considerably.  Now, records are  
found instantly, sorted too.
From: grant@reg.triumf.ca (Peter A. Grant)
Newsgroups: comp.databases.oracle
Subject: SQL*Forms 4.0 etc.
Date: 28 Sep 92 19:40:00 GMT
Organization: TRIUMF: Tri-University Meson Facility
News-Software: VAX/VMS VNEWS 1.41

People at IOUW two weeks ago were mentioning first quarter of next year for
Forms 4.0 and SRW 2.0, etc.  I didn't think that Forms looked THAT close.  
There were still parts that hadn't been implemented (sound for example) that
they seemed to imply would be there before release.  

They'd been running the products in the "campgrounds" for hours when I spoke
to some of the people, and they felt that that was a good sign.  If I were 
to put money on it, I'd guess beta early next year, and production in about
a year.

Did anyone get a different impression at IOUW? 

Peter Grant           ////////  ///////  ////////  //    //  //    //  ////////
grant@reg.triumf.ca     //     //    //     //    //    //  ///  ///  //
                       //     ///////      //    //    //  ////////  ///////
                      //     //  //       //    //    //  // // //  //
                     //     //    //  ////////  //////   //    //  //
                                               Canada's National Meson Facility
__________________________________________ _        Vancouver, British Columbia
Newsgroups: comp.databases.oracle
From: sstephen@us.oracle.com
Subject: Re: Oracle file managerCLOSE
Organization: Oracle Corporation, USA
Distribution: usa
Date: Sat, 26 Sep 1992 08:24:08 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <1992Sep25.214444.8180@tamsun.tamu.edu>, pnarayan@cs.tamu.edu (P S Narayan) writes:
> Hello,
> This one is on Oracle File Manager. 
> This is relevant to version 6.0.
> Suppose that I have a partition /dev/sd3g. I have a directory /oracle on which
> is /dev/sd3g mounted. If I use the Create database statement to create one
> data file "mydb" and two redo log files "redo1" and "redo2", from the
> Unix shell prompt when I do "ls", I can see the three files 
> "mydb", "redo1" and "redo2" under oracle directory. 
> Does this mean that Oracle Filemanager is interacting with the UNIX file
> manager and actual inodes are being created for these files ?
> If inodes are being created, then does oracle access these files using
> inode pointers or is it merely for listing the files for user's convenience ?
> I don't see any reason why oracle should traverse the files using filesystem
> inode pointers. Most files may be contiguously allocated and Oracle should 
> internally keep a directory of all files for a table to read the table.
> Am I right or wrong. Please correct me.
> I am sorry if I have confused you.
> 
> Thanks for any reply
> Narayan
> pnarayan@cs.tamu.edu

Oracle -- a file manager!!!  How dare you!  At least a few people still believe
it is a relational database.

The database is stored in a set of UNIX files.  When you issue "create
database", it does a "creat" system call to create unix files in the
$ORACLE_HOME/dbs directory.  If ORACLE created it's own file structure, you
wouldn't be able to back them up using normal UNIX commands.  So, yes, inodes
and dnodes are created for these files, they are stored and accessed the same
as any other filesystem.  If Oracle kept a directory of contiguosly allocated
disk pointers, you would never be able to recover from disk crashes or restore
from backups.  The drawbacks of using unix files for data storage are
relatively small since both Oracle and UNIX depend on memory caching frequently
accessed data.  I don't know if the files are contiguous anymore.  In Oracle V5
you used to have to manually create your data files with a utility called
"ccf", (create contiguous file).  I know that those datafile contain some
internal indexes into the rest of the file but I don't know what the structure
of these indexes are.

Scott Stephens -- representing my own rantings.
From: claborne@npg-sd.SanDiegoCA.NCR.COM (Chris Claborne)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle file managerCLOSE
Date: 3 Oct 92 05:03:09 GMT
Organization: NCR Corp., Network Products - San Diego



>I seem to recall reading that you can mount the oracle database "raw"
>on a unix system, and it would run faster.  Anybody have any actual
>experience with this?  And is it in ORACLE7?

You can do it in 6.xx.  It might run a little faster but I heard that it is
more difficult to manage once you set it up.  If you use a "raw" setup, 
could you use the standard UNIX backup procedures or would you be forced to
export the database to another device.  I have a data sheet somewhere that
explains the ups and downs of doing this.  I will see if I can find.


                                    ...  __o
                                   ..   -\<,
chris.claborne@sandiegoca.ncr.com  ...(_)/(_).                 CI$: 76340.2422
From: Mike.Doyle@vuw.ac.nz (Mike Doyle)
Newsgroups: comp.databases.oracle
Subject: Re: dropping a PUBLIC rollback seg
Date: 29 Sep 92 02:20:44 GMT
Organization: Comp Sci Dept. VUW
X-Useragent: Nuntius v1.1.1d7
X-Xxdate: Tue, 29 Sep 92 14:19:21 GMT

In article <1992Sep24.231540.1@us.oracle.com> , sstephen@us.oracle.com
writes:
>INIT.ORA:
>
>transactions_per_rollback_segment = 100
>transactions = 100
>
>>> shutdown and startup
>
>DROP PUBLIC ROLLBACK SEGMENT
>
>>> remove those two parameters
>>> shutdown and startup

This will work, but the "correct way" according to the Oracle DBA course 
is
find the value of "transactions_per_rollback_segment" and  "transactions" 

SQLDBA> show parameters transactions

ensure that there are at least
transactions/transactions_per_rollback_segment
rollback segments (other than the one you wish to drop) available for use

List these rollback segments in your INIT.ORA file then shutdown and
restart the database

SQLDBA> SHUTDOWN
SQLDBA> STARTUP OPEN db_name

You should now find that the rollback segments listed in the INIT.ORA file
are in use and the others are "available" (and can be dropped)

(if there are not enough rollback segments listed in the INIT.ORA file
you may still find that the rollback segment you wish to drop is in use. 
In this case create a new one in a different tablespace).

Mike Doyle
mike@comp.vuw.ac.nz

"As you slide down the banister if life, may all of
 the splinters be pointing in the right direction"
Xref: sparky comp.databases.oracle:1762 comp.databases.sybase:110
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Newsgroups: comp.databases.oracle,comp.databases.sybase
Subject: Advertisement by Oracle about two phase commit attacking SYBASE.
Date: 6 Oct 92 17:43:02 GMT
Distribution: usa
Organization: Intel Corporation, Santa Clara, CA USA


I am talking about recent advt by Oracle whch mentions that it's two phase
commit is automatic (in v7). It shows a page full of sybasesybase  code 
for a typical Debit/Credit operation requiring two phase commit 
(if the data is on multiple machines).

the left window shows a page full of sybase code taken from a book on SYBASE
server (I think book is written by Date), and on the right side it shows just
4 lines of equivalent oracle code.

so where is the catch ?

or is oracle v7  simply too good for sybase for these kind of things ?

I am curious!

Aniruddha Kortikar (kortikar@mipos2.intel.com) 

-------------------------------------------------------------------------------
Disclaimer : standard_disclaimer 
-------------------------------------------------------------------------------
Aniruddha Kortikar			| Main's Law :
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Oracle on a PC?
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Sat, 26 Sep 1992 03:12:17 GMT

brent@spss.com (Brent Lambert) writes:
>Regarding the following scenario:
>    386 PC
>    DOS 5
>    MS Windows
>    No network
>Is there a version of Oracle 6 which will run both a server and
>clients (Windows Pro*C) in that environment?  What is the product

If you mean a DOS product which will act as the server for EXTERNAL
clients, no.

>called?  What is a valid connect string?  How does client programming
>differ from writing a Windows, Pro*C program that will access an
>Oracle Server for OS/2 over Lan Manager?  

The only difference is the "AT :connect_string" clause attached to
the CONNECT clause in the EXEC SQL statement.  There is a way to
specify the local database so that your program doesn't have to
change internally when you are internal/external databases.  According
to the Miaco folks who make AntWorks, they had to do some tweaking
on their client/remote database version because of the way SQL*net
does its parsing and binding etc.

>-- 
>The above statements are not the opinions or policies of SPSS Inc.
>The above statements may not be the opinions of Brent Lambert.
>The first disclaimer is a policy of SPSS Inc.
>Subsequent disclaimers are probably the opinion of Brent Lambert.
-- 
Andrew Finkenstadt       | Vista-Chrome, Inc.   |           andy@GEnie
GEnie Unix Sysop/Manager | The Printing House   |    NIC Handle: AF136
+1 904 222 2639 home     | 1600 Capital Cir SW  |   ...!uunet!rde!andy
+1 904 575 0189 work     | Tallahassee FL 32310 | andy@vistachrome.com

     The game of love is never called off on account of darkness.
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: Modifying SQL*Forms 3.0 select statement
Date: 29 Sep 92 10:54:58 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

deepthought!neil@ms.uky.edu (Neil Greene) writes:

>I am running sql*forms 3.0 and would like to modify the select statement it  
>builds.  (and a like)  How would I go about accomplishing this task?

1)	Edit the database (after writing an forms application to hit trigger
	text)
or

2)	Edit the .inp file and reload it into forms (or database using iac)
	NOTE: Watch out for TRUNCATION of lines (keep < 75 bytes)
	NOTE: Watch out for TABS, iac handles them, iag handles them
		but iad screws up.

P.S. I have hand hacked .inp files since Oracle 4.1.13.beta thru
	SQLFORMS 3

-- 
========================================================================
David T. Bath
email: 	dtb@otto.bf.rmit.oz.au
Work: 	Global Technology Corporation, Carlton, Vic, OZ  (03) 3477511
Newsgroups: comp.databases.oracle
From: wayne@gbrmpa.gov.au (Wayne Amisano)
Subject: problems with SQL*Reportwriter and NFS mounted volumes??
Keywords: report,nfs
Organization: Great Barrier Reef Marine Park Authority
Date: Fri, 2 Oct 1992 02:12:26 GMT


Hi,

We are having problems running the SQL*Reportwriter family of commands
on a machine when the directory we are trying to save the output file
into is on an NFS mounted volume.

Several different errors are given depending on what we are trying
to do!  These are:

runrep:
  an attempt was made to lock a file that was already locked.

sqlrep:
  SRW-01721: unable to create run file.

loadrep:
  SRW-1814: Loadfile <report> is currently locked by another user.

dumprep:
  SRW-1814: Loadfile expdat.rex is currently locked by another user.

Other ORACLE products work fine on NFS mounted volumes, such as
SQL*Plus, SQL*Forms and SQL*Report.

If anyone has experienced these problems, I would be interested in sharing
your experiences..  We are running ORACLE RDBMS v 6.0.33 and SQL*Reportwriter
v 1.1.12.0.2 running on a MIPS RC3330.  The NFS mounted volume runs on a MIPS
as well.

tnx for any help.

cul Wayne.
-- 
Wayne Amisano (VK4KT)     _-_|\\    E-Mail - wayne@gbrmpa.gov.au
Great Barrier Reef       /     \\   Phone  - +61 77 81 8861 (GMT+1000)
Marine Park Authority.   \_.-._/    Fax    - +61 77 72 6093
Our's to use Wisely!          v     Mail   - GPO Box 1379, Townsville QLD 4810
From: ilevi@nocharge.East.Sun.COM (Irina Levi - Sun East Coast IR Development)
Newsgroups: comp.databases.oracle
Subject: ORACLE version 7
Date: 30 Sep 1992 18:37:48 GMT
Organization: Sun Microsystems, Inc.
Distribution: world
Reply-To: ilevi@nocharge.East.Sun.COM
NNTP-Posting-Host: nocharge.east.sun.com
Keywords: ORACLE 7


We are interested in any info on ORACLE DB v7,
particularly :
  1). in data base triggers & stored procedures
      ( or maybe they are the same thing?). Do they exist?
      We were told they do.
  2). how an event (update, delete, etc.) can be recognized
      outside of transaction which invokes it?
  3). Info on ORACLE ALERT  & PRO*C will be highly appreciated.  
 
    Irina Levi (SunMicro - East Coast)