HDTenEightyP/NetNews huggingface dataset:
From: gene@aee.aee.com (Gene Kochanowsky)
Subject: Re: Does anyone know the status of SQL*FORMS 5.0
Reply-To: gene@aee.aee.com
Organization: Associated Electronic Engineers
Date: Fri, 1 Jan 1993 19:06:50 GMT

fgreene@hayes.com writes:

>In article <1992Dec31.041221.6372@aee.aee.com>, gene@aee.aee.com (Gene Kochanowsky) writes:
>> To all Oracle Oracles,
>> 
>> 	If any of you know what the status of SQL*FORMS 5.0 is please let me
>> know.
>> 

>No such beastie as forms 5.0.  You must mean forms 4.0.  It is my
>understanding that this version is either in or about to go into beta test.

Certainly could be wrong, but I was under the impression, that deep in the
bowels of Oracle there was an object oriented, GUI independent version of
SQL*Forms brewing that was going to be 5.0. Has anyone heard anything to this
effect, and if they have, what is the status?

Gene Kochanowsky
-- 
Gene Kochanowsky                           | "And remember ....
Associated Electronic Engineers, Inc.      |       The better you look ... 
(904)893-6741 Voice, (904)893-2758 Fax     |       the more you will see."
gene@aee.com                               |               Miss Lidia
From: joe.bartling@sqlware.uunet.UU.NET (Joe Bartling) 
Newsgroups: comp.databases.oracle
Subject: VALIDATING DATA IMPORTED
Date: 1 Jan 93 23:25:00 GMT
Distribution: world
Organization: SQLWare Inc., Leesburg, VA - (703) 771-3979
Reply-To: joe.bartling@sqlware.uunet.UU.NET (Joe Bartling) 

Bill Thompson replied to an earlier message about validating ORACLE
imports from flat files:

-> That's an astonishing statement to me!  Our current plan calls for
-> *ALL* data imported into the database to come from flat ASCII files
-> generated by other programs.  Populating the database is supposed to
-> be an automatic process that works unattended.  Problems are supposed
-> to be signalled when they occur.

SQL*Loader puts bad records into a bad file, which is in the same format
as the original data file.  The erroneous records can be corrected, then
reimported.  The accompanying errors are detailed in an error file.

Joe Bartling
                                                                                                                           
----
+--------------------------------------------------------------------------+
| SQLWare BBS  703-771-4158 (HST V.32BIS-Specializing in ORACLE and other  |
| RDBMS topics.  Sponsored by SQLWare Inc., Leesburg,VA-300 conferences.   |
+--------------------------------------------------------------------------+
From: news@hrd769.brooks.af.mil (InterNet News)
Newsgroups: comp.databases.oracle
Subject: Oracle V6 and Solaris 2.2?
Date: 22 Dec 1992 09:47:10 -0600
Organization: Armstrong Lab MIS, Brooks AFB TX
Distribution: world
NNTP-Posting-Host: hrd769.brooks.af.mil

  Based on information received from our local Sun rep, we need to find
out about the availability of Oracle v6 on a Sun Server 630mp Model 54
(4 Super SPARC cpus).  The rep told us that this configuration will 
require Solaris 2.2.  Any information confirming or denying this would
be helpful, as well as an expected availability of Oracle Version 6 for
this platform and O/S.

  Please post or E-Mail, we read both :-)

TSgt Dave Burgess
NCOIC AL/MIS
Brooks AFB, TX
Newsgroups: comp.databases.oracle
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Managing array/matrix data?
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Tue, 22 Dec 1992 10:19:24 GMT

I'd be interested in hearing from anyone who has used Oracle to
manage array- or matrix-structured data.  I am researching DBMSes
to manage a large collection of time-series data, which can be
thought of as one-dimensional arrays, and other multi-dimenstional
data structures.

Thanks,

			Seth Grimes, grimes@oecd.fr 

Newsgroups: comp.databases.oracle
From: tostan@dumbo.lerc.nasa.gov (Stan Mohler)
Subject: What is Oracle?
Organization: NASA Lewis Research Center
Date: Wed, 23 Dec 1992 16:19:43 GMT

What is Oracle?  I know nothing about database programs.

-- 
-----------------------------------------------------------------------------
Stan Mohler
NASA Lewis Research Center     	|    
Cleveland, Ohio  44135         	|     email: tostan@dumbo.lerc.nasa.gov 
-----------------------------------------------------------------------------
From: epeas@abds7.aberdeen.chevron.com (John Peach)
Newsgroups: comp.databases.oracle
Subject: Re: ORACLE7 Disk Space Calcs
Date: 24 Dec 92 10:14:19 GMT
Reply-To: epeas@aberdeen.chevron.com
Distribution: na
Organization: Chevron (UK) Ltd.
Disclaimer: The opinions expressed are mine; _not_ those of        
            the company I work for.

In article <3609@voodoo.UUCP>, asb@voodoo.boeing.com (Anthony Bastian) writes:
|> Does anyone have a reliable formula for estimating disk space usage for  
|> ORACLE7 tables?  I have seen such a script for Oracle 6.x but not for
|> ORACLE7. It took into account the table's columns, indexs, and number
|> of rows.  We will be using the new BLOB type if that makes any difference.


Try Chapter 7 of the DBA Guide (Vol. 1).



|> Thank you and Merry Christmas!
|> 
|> 
|> 
|> 
|> 
|> 
|> -- 
|> Tony Bastian                                                (206) 865-6560
|> Internet: asb@voodoo.ca.boeing.com           UUCP: uunet!bcstec!voodoo!asb   
|> Boeing Computer Services  M/S 7K-20 P.O. Box 24346, Seattle, WA 98124-0346

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas@aberdeen.chevron.com       Phone: +44 224 242637
Newsgroups: comp.databases.oracle
From: spcsup@solomon.technet.sg (Wong Fay Yu)
Subject: "Mirroring" of Database
X-Newsreader: TIN [version 1.1 PL8]
Date: Wed, 23 Dec 1992 01:35:35 GMT

I have an Oracle v6 database residing on the MicroVAX 3100. Due to
rising demand in the information on this server, I would like to create
another database on the Oracle for Netware v6 server. The content will 
mirror that of the MicroVAX.

How would you suggest I go about creating this "mirror" image of the database
without having to do extensive coding.

Help!
Newsgroups: comp.databases.oracle
From: spcsup@solomon.technet.sg (Wong Fay Yu)
Subject: ODBC for Oracle
X-Newsreader: TIN [version 1.1 PL8]
Date: Wed, 23 Dec 1992 11:41:14 GMT

does anyone have any hints as to when Oracle will release the ODBC drivers?
I'm looking into Visual Basic as a front-end and need to access the Oracle
Server on my Novell Netware Server.

Thanks.   
Newsgroups: comp.databases.oracle
From: kpalm@doc.qualcomm.com (Kent Palm)
Subject: Re: Monday Morning Blues?
Organization: Qualcomm, Inc., San Diego, CA
Date: Mon, 28 Dec 1992 19:34:53 GMT

sjs@netcom.com (Stephen Schow) writes:

>We reboot our UNIX Oracle Server every weekend.  Every monday morning, all
>of our Oracle users complain about unusually slow performance.  Anyone have
>any clues why?  After a few hours it usually speeds up again, but the first 
>few hours of monday are slower than molasses(sp).


>-- 
>------------------------------------------------------------------
>Steve Schow    | But you don't have to use the claw, if you
>sjs@netcom.com | pick the pear with the big paw paw......
>(415) 354-4908 | Have I given you a clue......?
>               |                       - Baloo the Bear
>------------------------------------------------------------------

If you have a large SGA, then you may have all of your data in memory.
When you shut down the database, memory contents are lost.  The next time
the users request database information, a physical read (i.e., from disk)
must occur.  To get around this problem, you could write a routine to
bring in you most popular tables after database startup.  Not only is data
stored in the SGA, but also dictionary header information.
From: asb@voodoo.boeing.com (Anthony Bastian)
Newsgroups: comp.databases.oracle
Subject: ORACLE7 Disk Space Calcs
Date: 23 Dec 92 18:33:28 GMT
Distribution: na
Organization: Boeing Graphics project, Bellevue WA

Does anyone have a reliable formula for estimating disk space usage for  
ORACLE7 tables?  I have seen such a script for Oracle 6.x but not for
ORACLE7. It took into account the table's columns, indexs, and number
of rows.  We will be using the new BLOB type if that makes any difference.
Thank you and Merry Christmas!






-- 
Tony Bastian                                                (206) 865-6560
Internet: asb@voodoo.ca.boeing.com           UUCP: uunet!bcstec!voodoo!asb   
Boeing Computer Services  M/S 7K-20 P.O. Box 24346, Seattle, WA 98124-0346
Newsgroups: comp.databases.oracle
From: rheiger@renext.eiger.olivetti.ch (Richard H. E. Eiger)
Subject: Re: SQL*Net Named Pipes Problem
Reply-To: rheiger@renext.eiger.olivetti.ch
Organization: Olivetti (Schweiz) AG, Branch Office Berne
Date: Sat, 19 Dec 1992 09:15:42 GMT

In article <1992Dec12.011829.2022@osnbe.Olivetti.ch> I wrote:
> The PCs in our environment are connected to the LAN through LanManager over  
the  
> OSI TopNetBIOS protocol and a UNIX V.4 (Olivetti release 2.1.1) server. On  
the  
> server we have ORACLE 6.0.31 and nmpsrv Version 1.0.0.1.2 - Production  
running.  
> On the clients we have sqlnmp Version 1.0.0.0, DOS 5 and Win3.1. Our  
> applications use the Gupta SQLWindows product.
> 
> We observe the following problem. Occasionally we get the error "Invalid  
> Hoststring" when trying to connect to the database 
[deleted]
>when we launch sqlplus for the fifth time we get  
> the error number 658 (I think) which does not exist in the Oracle error  
> manuals.
> 

I have now learned that in a newer release of the sqlnmp (1.1.1.1) this should  
no longer occur. Unfortunately we have not yet been able to test this because  
we get the error "No named pipe available". Does anyone know whether we have to  
upgrade the nmpsrv on the server as well?
--
                         
    ___           _____2
   /   )  /  /   /        Richard H. E. Eiger
  /_ _/  /__/   /__       Ing. Informatik HTL
 /\     /  /   /          Unregistered NeXT fan
/  \   /  /   /_____      rheiger@renext.eiger.olivetti.ch (NeXT mail welcome)
Newsgroups: comp.databases.oracle
From: cdm@pmafire.inel.gov (Dale Cook)
Date: Wed, 23 Dec 92 21:43:51 GMT
Organization: WINCO
Subject: Re: What is Oracle?
Summary: 
Followup-To: 
Organization: WINCO
Keywords: 

In article <1992Dec23.161943.7494@eagle.lerc.nasa.gov> tostan@dumbo.lerc.nasa.gov (Stan Mohler) writes:
>What is Oracle?  I know nothing about database programs.

It's a database program :-)

Short answer:  Oracle is a corporation which develops and markets software
to manage data.  The central product is the database management software
which allows multiple users to access/update data.  Surrounding this
database software are other products which provide input/output interfaces
to the database other than Structured Query Language (SQL).

---Dale Cook
Newsgroups: comp.databases.oracle
From: deal@tempus.Kodak.Com (Stephen M. Deal)
Subject: Why doesn't Pro*C support structures?
Reply-To: deal@Kodak.COM
Organization: Eastman Kodak Company
Distribution: na
Date: Thu, 31 Dec 92 01:16:34 GMT

In article <1992Dec30.183813.29783@tigger.jvnc.net>,
fogelinc@nmr1.Cyanamid.COM (Carl Fogelin) writes:
|> I hate to tell you this Steve, but PRO*C does not support the use of
|> structures.
|> It states on page 1-6 of the PRO*C Supplement (V1.3)
|> 
|>    You cannot declare a host variable of type struct.  Nor can you
|> refer
|>    to any of the following:
|> 
|>        - names declared in typedef statements
|>        - symbolic constants named by the #define directive
|>        - previously declared structs
|> 
|> I know it stinks, especially since VARCHARs are structs, but that's
|> the way
|> it is.   :-(
|> 
|> Carl

Thanks Carl, and to others who Emailed a similar response.

Boy that really does stink! Acckkk  Pbbttt!

Competitive products (e.g. INGRES) don't have any such constraints. Fetching
into a structure seems to be the most natural approach for mapping relational
sets of data into a 3GL. What I was really looking to do is to
dynamically allocate an array of struct but I guess that's beyond hope.

Does anyone know if this constraint self-imposed or does Oracle hide
behind the ANSI-SQL definition as the rational for this limitation?

Steve
-- 
    Disclaimer:	"Everyone is entitled to an opinion, 
		 the above is mine and not that of my employer."
From: meb1@ecsa01.encon.pge.com (Mark E. Bole)
Newsgroups: comp.databases.oracle
Subject: Re: OPS$LOGIN login for oraperl
Date: 29 Dec 92 15:24:52 GMT
Organization: Pacific Gas & Electric, SF, CA
X-Newsreader: Tin 1.1 PL4

peter@ml.csiro.au (Peter Campbell) writes:
: Is it possible to get oraperl to login to a database just using a / the way
: sqlplus etc. can on my Sun?
: 
: Peter Campbell       peter@ml.csiro.au
: CSIRO Marine Labs, Hobart, Australia


I use this syntax, it seems to work:

    $lda = &ora_login($SID, '/', '') || die $ora_errstr;

-- 
|   meb1@encon.pge.com                                                |
|   Mark Bole, Pacific Gas & Electric Co., San Francisco, California  |
|   415/973-5721                                                      |
Newsgroups: comp.databases.oracle
From: casivils@lescsse.jsc.nasa.gov (craig sivils)
Subject: Re: Explain THIS, please!
Organization: Lockheed Engineering and Sciences
Date: 28 Dec 92 23:34:25 GMT

Given the following table

SQL> desc test
 Name                            Null?    Type
 ------------------------------- -------- ----
 PART                                     CHAR(10)
 COUNT

The following select statement returns the top X groups

SELECT   PART
FROM     TEST TOPTEN
GROUP BY PART
HAVING &1>(SELECT COUNT(DISTINCT PART) FROM TEST
           WHERE  PART IN ( SELECT UNIQUE(PART)
                            FROM   TEST
                            GROUP BY PART
                            HAVING ((SUM(COUNT)>(SELECT SUM(COUNT) FROM TEST
                                                 WHERE PART = TOPTEN.PART
                                                 GROUP BY PART ) )OR
                                    (SUM(COUNT)=(SELECT SUM(COUNT) FROM TEST
                                                 WHERE PART = TOPTEN.PART
                                                 GROUP BY PART ) AND
                                                 PART > TOPTEN.PART ) ) ) )
ORDER BY SUM(COUNT),PART


                                Craig

I realize that this could be optimized quite a bit, most noteably, the inner
most subquerys for the sum of the count is redundant, but hey, redundant is
a step up from impossible.
Newsgroups: comp.databases
From: bernie@metapro.DIALix.oz.au (Bernd Felsche)
Subject: Re: Progress DBMS?? Info..
Organization: MetaPro Systems, Perth, Western Australia
Date: Thu, 24 Dec 92 01:42:54 GMT

In <1992Dec21.201336.29965@bts.com> paulr@bts.com (Paul Raulerson) writes:

>In article <1h3ug9INNco1@lester.appstate.edu>
>jvs@lester.appstate.edu (John V. Scalco) writes:
>>
>>	Does anyone know what Progress DBMS is...what platform it
>>	runs under, what it is like  etc.

>>	appreciate any info you could provide.

>>	please mail directly to me.......ahhhh you can post it if you
>>	want to  ifyou want, I read this newsgroup all the time..

>Progress runs under just about any UNIX, DOS, BTOS, and bunches of 
>other systems (including A/UX on Macintoshes). It is a very nice database,
>with a beautiful 4GL and full SQL dialects. 

Beauty is in the eye of the beholder :-) The 4GL is very
practical and is procedural, reminiscent of AlphaBasic
(don't let that put you off!).

The SQL facility is useful, though not as complete as Sybase's.

>It has wonderful transaction capabilities, and a very good crash recovery
>system. In most respects, it is quite comparable to Oracle.

Join the Progress mailing list;
	progress-list@math.niu.edu
by sending a message to join to
	progress-list-request@math.niu.edu
-- 
+-----+ Bernd Felsche                     _--_|\  #include <std/disclaimer.h>
| | | | MetaPro Systems Pty Ltd          /      \ bernie@metapro.DIALix.oz.au
| | | | 328 Albany Highway,              X_.--._/         Fax: +61 9 472 3337
|m|p|s| Victoria Park, Western Australia 6100  v        Phone: +61 9 362 9355
Newsgroups: comp.databases
From: jeb@fig.citib.com (James E. Bergman)
Subject: Paradox Engine 3.0 and Visual Basic
Originator: jeb@vulture
Reply-To: ibism!jeb
Organization: Citibank IBISM
Date: Mon, 21 Dec 1992 20:24:49 GMT



Does anybody have experience using the Paradox Engine V3.0 and Visual Basic. Especially with the calls to RawPut/RawGet?

Newsgroups: comp.databases
From: 0031@pnet16.cts.com (Capt G. Carradini)
Subject: CASE > PARADOX CODE
Organization: People-Net [pnet16], NCTAMS EASTPAC
Date: Tue, 29 Dec 1992 05:16:03 GMT

A friend of mine is working on his Info Systems thesis and is investigating
buying a CASE tool for his personal use.  He wants to code his project in
PARADOX 4.0 PAL.  Does anyone know if there is a CASE TOOL that will generate
PAL?  OR, is there a utility that will port dBASE or other CASE output to PAL?
Any suggestions would be appreciated (posting here or e-mail is fine).
George

UUCP: humu!nctams1!pnet16!0031
ARPA: humu!nctams1!pnet16!0031@nosc.mil
INET: 0031@pnet16.cts.com
From: bhushan_a1@verifone.com
Newsgroups: comp.databases
Subject: <None>
Date: 30 Dec 92 20:30:30 -1000
Organization: VeriFone Inc., Honolulu HI






w

 ww
i
wr




















  
		
Newsgroups: comp.databases
From: mark@uvmark.uucp (Mark Baldridge)
Subject: Re: 500'000 records - who does best?
Date: Tue, 29 Dec 92 17:31:06 GMT
Organization: VMARK Software, Inc.

In article <18971@mindlink.bc.ca> Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
>> Michael Perry writes:
>> >500,000 records, averaging 30K *each*. Forget Sybase and Oracle on Suns;
>> >go for a Teradata.
>> Hmmm... given the price/performance of a Teradata I can only say:  HUH?
>>
>> Makes _no_ sense [to me, anyways] to spend millions of dollars for Teradata
>> stuff when a smaller SMP box would be a LOT more practical.
>:-) Yes, it WOULD be a lot more practical, if it did the job. IF.
>>
>> >and what you are suggesting is probably outside the envelope already.
>>
>> Hmmm... outside the envelope.  Kinda hard to imagine a 30-40 user system
>> being outside the envelope, at least without a LOT more data to gnaw on.
>
>It isn't the number of users, it's the basic size of the tables.
>One of our clients has pushed a table to 900k rows, 250Mb on an RS/6000
>with 50Mb memory dedicated to the Sybase server. Working with it
>feels like retiling the bathroom while an elephant uses the john.
>

Maybe I am missing something, but we routinely have customers with 250 to 800
megabyte tables and 200-300 users on RS6000s.  Earlier this year, we did a
benchmark with 1600 users, all with under one or two (I do not remember now)
second response time.  The benchmark was to ensure that the fully configured
system could handle the expected 2500 users.

We user uniVerse.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Mark A. Baldridge (uvmark%mark@merk.com uunet!merk.com!uvmark!mark)
        Vmark Software, 30 Speen Street, Framinham, MA 01701

-- 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Mark A. Baldridge (uvmark%mark@merk.com uunet!merk.com!uvmark!mark)
        Vmark Software, 30 Speen Street, Framinham, MA 01701

Newsgroups: comp.databases
From: oliver@infix.de (Oliver Okrongli)
Subject: Re: Informix Performance Tips Query
Organization: infix Software-Systeme GmbH
Date: Wed, 23 Dec 1992 21:01:35 GMT

>>>>> On Wed, 23 Dec 1992 08:44:42 GMT, nh@cbnewsg.cb.att.com (nicholas.hounsome) said:

> Has anybody got any tips on how to get the best performance out
> of informix (online) ESQL?
> The database is about 10M with the largest table being about 
> 20K rows.
> Increasing the cache size seems like a good idea. I have tried a lot
> of other stuff that they recommend and it doesn't seem to make much
> difference (eg. extent sizes).

You could try to figure out the maximum amount of main memory your OS
and applications need (avoid paging).  Then dedicate the remaining
available memory to OnLine as shared memory segment (you may also need
to increase kernel parameters).  This might increase OnLine's cache
hit rate (tbmonitor should show you).  Generic cache problems apply -
at some point further increasing cache size yields neglectable
performance improvements.

Increasing cache does not protect you against CPU bottlenecks.

BTW - 10M does not sound like a typical OnLine environment.  We do
databases >100M with SE with larger tables containing 150k rows.

> How nuch difference does preparing statements make compared to
> statements fully parsed by esql?

Depends on your statements.  Using prepared statements we have noticed
execution times at 75% to 50% the time of non-prepared statements.
This is especially true in case of small operations involving little
I/O.  The disadvantage is that syntax checking is done at run time.

Hope this helps.

-- 
Oliver Okrongli		infix Software-Systeme GmbH	  Phone +49 531 238090
			Rebenring 33			  Fax   +49 531 3801152
oliver@infix.de		D-W-3300 Braunschweig		  F.R. Germany
Newsgroups: comp.databases
From: gdzimmer@phoenix.Princeton.EDU (Gary David Zimmer)
Subject: WANTED:  Font information for Access
Followup-To: gdzimmer@phoenix.Princeton.EDU
Originator: news@nimaster
Keywords: ACCESS, font
Organization: Princeton University Class of 1993
Date: Sat, 26 Dec 1992 19:15:23 GMT

Has anyone had problems with the way ACCESS deals with fonts when you
are typing commands?  For example, when I try to type information into
the two option boxes in the macro definition screen, the characters are
spaced terribly until I tab out of the field.  Furthermore, cursor
movements are terrible.  The font is San Serif 8 point and there is
definitely a TrueType definition for Windows.

Also, is there any way to change the default font that ACCESS uses for
it native commands.  I know how to change to font for forms, datasheets
and all the rest of the options, but how do you change the font for the
base functions?
Xref: sparky comp.databases:8769 comp.theory:2782
From: tmb@arolla.idiap.ch (Thomas M. Breuel)
Newsgroups: comp.databases,comp.theory
Subject: computational complexity and databases
Date: 4 Jan 93 03:03:18 GMT
Article-I.D.: arolla.TMB.93Jan3190318
Reply-To: tmb@idiap.ch
Followup-To: comp.databases
Distribution: world
Organization: IDIAP (Institut Dalle Molle d'Intelligence Artificielle
	Perceptive)
NNTP-Posting-Host: arolla.idiap.ch

I'm interested in the "standard references" describing known results
in computational complexity of database retrieval, space/time
tradeoffs, etc. Textbooks, recent surveys, and pointers to key
articles would be appreciated.

If response warrants it, I'll post a summary/digest of everything I
receive.

				Thanks,
					Thomas.

				tmb@idiap.ch
Newsgroups: comp.databases