HDTenEightyP/NetNews huggingface dataset:
From: michelle@Thalatta.COM (Michelle Wannamaker)
Newsgroups: comp.databases.oracle,pnw.general
Subject: Puget Sound Oracle Users Group
Keywords: PSOUG, meeting
Date: 2 Oct 92 22:52:52 GMT
Distribution: pnw
Organization: Thalatta Corporation, Bellevue WA


                Puget Sound Oracle Users Group

The next meeting of the Puget Sound Oracle Users Group (PSOUG) will be
on October 8th at 4PM at UNISYS.  The address is 3650 131st Avenue SE.
Several members will be presenting short overviews of topics covered
at the recent International Oracle Users Week in San Francisco.  If you
have any questions about this meeting or PSOUG, please call Ted Greeniaus
at 233-3419.

-- 
-----------------------------------------------------------------------
In-Real-Life: Michelle Wannamaker                  Thalatta Corporation
              michelle@Thalatta.com                Bellevue, WA
Newsgroups: comp.databases.oracle
From: clayton@cc.gatech.edu (R. Clayton)
Subject: Oracle information wanted.
Reply-To: clayton@cc.gatech.edu (R. Clayton)
Organization: College of Computing, Georgia Institute of Technology
Date: Sat, 3 Oct 1992 23:10:33 GMT

I am interested in gathering information on:

  Characterizing and comparing report generators (SQL*Plus, SQL*ReportWriter,
  or whatever else is out there).

  Installing and using CASE tools (CASE dictionary and generators).

If you have experience with either of these Oracle facilities and wouldn't mind
taking the time to relate your opinions, please mail me a note.  Thanks.

R. Clayton
clayton@cc.gatech.edu
Newsgroups: comp.databases.oracle
Subject: SUMMARY: Oracle 7 Info Request
From: brent@spss.com (Brent Lambert)
Date: Fri, 2 Oct 1992 15:15:51 GMT
Organization: SPSS, Inc. - portable code group
Keywords: version 7 upgrade migrat

Here's what I learned, both from the net and from Oracle.  Note that I
only received half a dozen responses, so this information should not be
taken as a reasonable sample (or maybe it should ...).

Oracle 7 is not available in a production version yet, but is expected
to be by the end of 1992.

The migrations I heard about were fairly trivial, consisting of a
single application, a small database, or test data.  They took from
one hour to one day.

The estimates for "real" migration were one man-week to one man-month.

Based on these replies and the Oracle 7 Migration Guide, it seems that
you can 'migrate', or you can '*migrate*'.  The first form of
migration does not include taking advantage of any version 7 features,
such as triggers, stored procedures, etc.  The second form does.

My impression is that the first form of migration is pretty simple,
probably taking a few days for huge systems.  The second form, done
thoroughly, could require redesigning large segments of the databases
and applications, thus it could become a long-term project.

Obviously, there is a lot of room in between the two extremes.  I
suspect that most sites will want to start with the simple migration,
and upgrade the databases and applications to take advantage of
version 7 as schedules permit or requirements demand.

One other comment I received is that Oracle support for version 6 will
end at the end of 1993.  I have not confirmed the statement, but I
find it easy to believe.

-- 
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.
Newsgroups: comp.databases.oracle
From: cbergren@shcamux1.NoSubdomain.NoDomain (Craig Bergren)
Subject: Re: Oracle Connect Performance
Organization: Motorola Land Mobile Products Sector
Date: Mon, 5 Oct 1992 23:06:52 GMT

In article <1992Sep28.193935.27363@eng.umd.edu>, hyu@eng.umd.edu (Henry K. Yu) writes:
|> 
|> If you are using Oracle Connect, would you like to share your experience
|> regarding its performance?  I am specifically interested in using it
|> to tie together Oralce running on a Sparc 2 and Ingres running on a Sparc 2.
|> 
|> Thanks,
|> hyu

We have had a problem with repeated connects using SQLNet on an HP-UX and
Motorola 88k and 68k Unix boxes. Same error on different systems. Oracle 
error 6136. It seems that Oracle does not disconnect the old connections.
The only way to solve the problem is to put in waits, which blow performance
all to hell.

-- 

The views I hold are not mine, nor those of my employer.
Newsgroups: comp.databases.oracle
From: rdawson@us.oracle.com (Dick Dawson)
Subject: Terminal Emulator use of ReportWriter
Reply-To: rdawson@us.oracle.com (Dick Dawson)
Organization: Oracle Corporation, New York, New York 
Date: Wed, 30 Sep 1992 19:18:45 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.

I am posting this for a client who would like to know:

He is using the Kermit terminal emulator program on an IBM PS/2
connecting to an RS/6000 running AIX. 

He is using SQL*Forms, and ReportWriter, but is having great
difficulty with the keyboard mapping when running ReportWriter.
He is looking for advice on how to make this work, or suggestions
for making it work.

Any advice that you can offer me to offer him would be greatly
appreciated.

Thanks,

Dick Dawson
Oracle, NYC

Newsgroups: list.epixinfo,comp.databases.oracle
From: peter.steele@acadiau.ca (Peter Steele)
Subject: orasrv: server already running: Address already in use
Organization: Acadia University
Date: Wed, 30 Sep 1992 15:56:32 GMT
Apparently-To: epixinfo@julian.uwo.ca

This error occurs when orasrv, the oracle kernel daemon, is
shutdown and the restart command is issued to soon after the
shutdown. Waiting a couple of minutes usually solves the problem.
However, we occasional get a situation where orasrv gets confused
and will issue this error indefinitely. The only way we've discovered
to clear this error is by rebooting, which isn't desirable on
a production machine.

Has anyone seen this error, where Oracle gets confused and won't
let you restart orasrv?
--
Peter Steele        Unix Services Manager            peter.steele@acadiau.ca 
Acadia Univ., Wolfville, NS, Canada B0P 1X0  902-542-2201  Fax: 902-542-4364
From: claborne@npg-sd.SanDiegoCA.NCR.COM (Chris Claborne)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle technical services?
Date: 28 Sep 92 04:46:59 GMT
Organization: NCR Corp., Network Products - San Diego

In <1992Sep27.212741.28298@ncsu.edu> sparker@unity.ncsu.edu (Shachindra Parker) writes:

>I am a graduate student at the North Carolina State University, Raleigh.  I am
>starting work on a materials property database using ORACLE V6.0.

>My quetions being very basic I don't want to address them into this group.  I was wondering if I could find some help from ORACLE CORP. itself by e-mail, rather than calling them up.  Does anybody know of any such thing?  I would appreciate any replies and suggestions.  Thanks in advance.

>________________________________________________________________________________
Oracle has a system called RTSS (rappid tech support...).  If you have support,
you can call and get a password to use it.  I am pretty sure that it is a 
window into their TAR (technical assistance request) database.  You could
place questions there and look at the answers later.

I use it all the time and reccomend it.


                                    ...  __o
                                   ..   -\<,
chris.claborne@sandiegoca.ncr.com  ...(_)/(_).                 CI$: 76340.2422
From: sstephen@us.oracle.com
Newsgroups: comp.databases.oracle
Subject: Re: SQL*ReportWriter order by clause
Date: 26 Sep 92 07:54:59 GMT
Organization: Oracle Corporation, USA
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.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!
From: pihlab@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Re: Forms 4.0
Date: 28 Sep 92 10:20:59 +1000
Organization: Aust. Dept. Health, Housing and Community Services

In article <swhite.717433105@fncduc>, swhite@fncduc (Stephen White) writes:
> Has anyone heard any details on Sql*Forms V4.0?  Such as when it will be 
> released, what it will do and the platforms it will be on (Sun, Vax, Mac)?
> 
> It would be real nice if one of you Oracle people would respond. 
> 
> --------------------------------------------------------------------------------
> 
> Stephen P. White
> Computing Division            [Space Reserved for Future Disclaimers]
> FermiLab
> Batavia,IL
> 
> --------------------------------------------------------------------------------

Only major things I've heard about Forms4 is that it replaces both Forms3 and
Menu5 AND works with Oracle7 stored procedures.

-- 

Bruce...        pihlab@hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************
From: hyu@eng.umd.edu (Henry K. Yu)
Newsgroups: comp.databases.oracle
Subject: Oracle Connect Performance
Date: 28 Sep 92 19:39:35 GMT
Organization: Project GLUE, University of Maryland, College Park


If you are using Oracle Connect, would you like to share your experience
regarding its performance?  I am specifically interested in using it
to tie together Oralce running on a Sparc 2 and Ingres running on a Sparc 2.

Thanks,
hyu
From: rkannan@rcsuna.gmr.com (Ram Kannan )
Newsgroups: comp.databases.oracle
Subject: Installing Oracle
Date: 28 Sep 92 21:11:39 GMT
Distribution: usa
Organization: GM Research Labs, Warren, MI

I am planning to install Oracle on a HP 750. My Hp workstation has only a DAT drive hooked up.  The tapes received from ORACLE are 1/4" cartridge tapes.  I 
have access to a SUN workstation with a 1/4" cartridge drive on the local network.

Could someone help me with the steps to follow to transfer the files and install oracle on the HP.

thank you

ram
Newsgroups: comp.databases.oracle
From: sstephen@us.oracle.com
Subject: Re: Oracle file managerC
Organization: Oracle Corporation, USA
Date: Wed, 30 Sep 1992 21:38:39 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.

Hi Jared,

Sorry about the followup, instead of an e-mail reply, but the MIS at large
hasn't set up our VMS news reader 100%, yet.  Have to see him about that.

In article <744.1599.uupcb@factory.com>, jared.hecker@factory.com (Jared Hecker)  writes:
> TO: ssteph@oracle.com
> 
> SR> Scott Stephens -- representing my own rantings.
> SR>
> 
> Is that 'cuz KJ won't let you rant on CI$ anymore?

I haven't been on CI$ for a long time because I went to work "in the field" in
Oracle Singapore for 1 1/2 years.  I just got back to HQ Sept 1, and haven't
gotten around to getting another account, (they gave my account to someone
else, BTW, and I ended up having to cancel a credit card to get out of that
mistake).  Apparently, CI$ wizardship has been passed to the IOUG, so it is
more of a user forum anyway.

I met KJ in Australia during the APOUC (Asia-Pacific Oracle User's conference).
He is a real sweet guy in person, with a crowd of disciples following him
wherever he goes, (asking him RDBMS questions). We have always seen eye-to-eye
in most cases and was always willing to consider any new ideas we would give
him.  He taught his 2 favorite subjects, referential integrity and competitive
information, in our internal Oracle 7 class.  He is always interesting to
listen to and a very good speaker.

> 
> BTW, Scott, when the heck are you guys gonna allow >99 extents 
> per table?  It's a real PITN when you have a mix of large and
> small tables.  Fragmentation becomes more than annoying in an
> active database.
> 

The 99 MAXEXTENTS is a default, not a limit.  If you create a tablespace and
ALTER TABLESPACE MAXEXTENTS 999, it makes the extents limit open-ended and is
only dependent on your block size.  2048 byte blocks give 121 extents, 4096
bytes give about 243 extents.  I've always felt that they ought to get
multi-block "extent tables", but apparently this would be a severe performance
problem if you had to scan multiple blocks to find your desired extent.  Since
the virtual limit is a really-large-number-which-might-as-well-be-unlimited for
a single extent, a well organized database should not have problems, or should
be looking at temporary tables that can be dropped.  So...I don't see them
raising this limit in the future, (an this from an "Oracle").

>
> Maybe you guys can kick it around bettween games of 3-on-3 at the 
> health club...
>
>
> jh
> ---
>  . RoseReader 1.70 G002691
>                                                          

Scott Stephens - representing his own rantings on top of rantings.
Newsgroups: comp.databases.oracle
From: Neil Greene <deepthought!neil@ms.uky.edu>
Subject: Re: SQL*FORMS and SQL*REPORTWRITER running natively on next
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.
Date: Mon, 5 Oct 1992 16:46:05 GMT

In article <138121@lll-winken.LLNL.GOV> 946753@arniew.llnl.gov (Arnie  
Weinstein) writes:
> Does anyone have any experience running SQL*FORMS or REPORTWRITER  
natively on the
> NeXT machine.  
> 

I have been running Oracle v6.x.x.x and SQL*Reportwriter since December on  
a NeXTCube to track illegal activities in the Thoroughbred industry and  
race track licensing information.

If anyone else would like to know more about Oracle on the NeXT, feel free  
to drop me an email.  Although I consider myself far from being an  
"expert" I do know quite a bit now about the Oracle product thanks to many  
here on the net.

(Also running, SQL*Menu and SQL*Plus)
From: xdwj@uxa.ecn.bgu.edu (Darrell Johns)
Newsgroups: comp.databases.oracle
Subject: Oracle demos.
Date: 30 Sep 92 19:35:59 GMT
Organization: Educational Computing Network

We have been asked to produce a short Oracle demo that fits on one to three
pages of handouts that a new user could sit down and follow.  Before we go
about developing one I thought i would ask if any one else has developed
one thay would like to share.  The users could follow the demos in the
books but part of this demo process is for people to decide if Oracle is
useful enough for them to spend the money on the manual set.

Thanks for any help or suggestions,
Darrell.
-- 
Darrell W Johns         |Educational Computing Network  |Phone: 708/ 534-0200
Applications Consultant |Route #54 & Stuenkel Road      |FAX:   708/ 534-2042
                        |University Park, IL 60466-0975 |BITNET: XDWJ@ECNUXA
      INTERNET:xdwj@uxa.ecn.bgu.edu  -or-  djohns@heartland.bradley.edu
Xref: sparky comp.databases.oracle:1744 comp.databases.theory:507
From: mao@triplerock.CS.Berkeley.EDU (Mike Olson)
Newsgroups: comp.databases.oracle,comp.databases.theory
Subject: Re: Oracle Optimizer Questions.
Date: 2 Oct 1992 17:04:06 GMT
Organization: University of California at Berkeley
NNTP-Posting-Host: triplerock.cs.berkeley.edu


In <BvGIps.5yC@inews.Intel.COM>, kortikar@mipos2.intel.com (Aniruddha Kortikar)
writes:

> I need some help in understanding oracle optimizer -
> consider following tables  -
> 	...
> these are the explain plan outputs I got from oracle 6.0.33.+ 

the oracle version 6 optimizer doesn't use cost analysis.  oracle does
"semantic" query optimization, which is to say, it executes joins in
the order in which you write them, and will use an index if one happens
to be around.  it doesn't reorder the query in any way.

i believe that version 7 provides cost-based optimization.

					mike olson
Newsgroups: comp.databases.oracle
From: brad@cerberus.bhpese.oz.au (Brad Keifer)
Subject: ORACLE exports
Organization: BHP, Newcastle, Australia
Date: Wed, 7 Oct 1992 00:09:19 GMT
Keywords: oracle, db exports

Is there a limit on the number of tables that can be specified to export
when performing an export from ORACLE areas?
I have discovered a problem with some exports that I was automatically
performing.
The ORACLE version is 6.0.31.0.1, running on an RS/6000 AIX Version 3.2.
I have an sql script that generates a "PARFILE" that contains a file name to
store the export in, followed by a series of table names. I have found
that only the first 98 tables actually get exported. The export routine
does not indicate an error, in fact it says that the export terminated
successfully.
-- 
Brad Keifer, BHP Information Technology, Newcastle Region, Australia
PO Box 216.  Hamilton.  NSW.  2303
internet: brad@cerberus.bhpese.oz.au            Phone: +61 49 402126
                                                Fax:   +61 49 402165
From: kmallory@oracle.com (Kevin Mallory)
Newsgroups: comp.databases.oracle
Subject: Re: Forms 4.0
Date: 29 Sep 92 21:39:49 GMT
Organization: Oracle Corp., Belmont CA
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.


SQL*Forms 4.0 is currently in Alpha Test on VMS. It was demoed
extensively at IOUG this year on VMS, SUN, MAC and Windows, and I'm
sure that there will be some press reviews soon.

Yes, There will be a version of SQL*Forms (full development and
run-time) for both the MAC and Windows on the PC.  Both of these ports
are well underway (read: they're up and running now).


Major Features of SQL*Forms 4.0:

Full backward compatability with SQL*Forms 3.0. To upgrade a Forms 3.0
form to run on Forms 4.0 you simply re-generate the form and it runs.
The same with SQL*Menu 5.0 menus, you simply re-generate.

SQL*Forms and SQL*Menu in a single product. A single Design Interface
for both Form Modules and Menu Modules.

Real Graphical User Interface objects in your forms, e.g. buttons,
check boxes, radio groups, images, sounds, dynamic boilerplate... Of
course this will all still run on character mode and block mode.

New true Bitmap Forms Designer/layout editor

Non Oracle data source support. (The IOUW demo was done with SQL*Forms
read/write/update to a FLAT file!). 

Product Integration with other Oracle Tools (SQL*Reportwriter V2,
Oracle Graphics V2, Oracle Bookviewer V1) e.g. you can put an
Oracle*graphics chart on your form as an object and get Oracle*graphics
to update it with data you send from your form. Oracle Graphics will
NOT have to re-query the database to generate the chart!

Shared Modules.  Modules can be put into a shared memory segment. This
means an overall reduction in the amount of memory required to execute
a form.  Upwards of 80% of most forms are shareable!

Hope this dispels some of the rumors.

Please do not send questions about specific features to me via mail.
Please post your questions here and we will be happy to answer them.



--
---------------
Kevin Mallory	Oracle Corporation - Redwood Shores, California
SQL*Forms Development
I don't speak for Oracle, nor they for me.
Remember: If you can find someplace you laik better 'n' Tuna... **MOVE**!
Newsgroups: comp.databases.oracle
From: jwhit@wbst845e.xerox.com (Jeff Whitmire)
Subject: Re: SQL-Loader
Organization: Xerox Corporation, Webster, NY
Date: Tue, 29 Sep 1992 18:49:41 GMT

In article <Sep29.172621.68343@yuma.ACNS.ColoState.EDU> ciuffoli@CS.ColoState.EDU (carlos edis  ciuffoli) writes:
>
>Have any one loaded negative integers from a file using SQl-loader before ?
>I have looked in the manual (SQL loader) and it does not talk much about
>negative integers.   I have defined this field as :
>
>..
>..
>I can't see  anything wrong with the way I have things defined. However, I never have worked with this type of data. 
>
>I appreciate any help, thanks.

I have recently tried to do the same thing with similar data.  I had no luck and
had to load the data as positive values, then run a SQL*Plus script to multiply
all of the values by -1.  This obviously will not work unless all of the values
will be negative.

I would be interested to hear from anyone who has found a better solution.

-------------------------------------------------------------------------------
| Jeff Whitmire                     | Disclaimer:  My employer is not         |
| mail : jwhit@wbst845e.xerox.com   |              responsible for my         |
| voice: 716-422-5647               |              opinion.                   |
-------------------------------------------------------------------------------
From: xdwj@uxa.ecn.bgu.edu (Darrell Johns)
Newsgroups: comp.databases.oracle
Subject: Access to SQL*ReportWriter tables.
Date: 30 Sep 92 18:49:23 GMT
Organization: Educational Computing Network

My system admin. just installed Oracle 6.0 on our SUN SPARCserver and then
handed the all the manuals to me and told me I amd the DBA.  I have read
the chapters in the Database Administrator's Guide partaining to creating
accounts and sucessfully created accounts.  Now a user is wanting to use
SQL*ReportWriter and oracle tells them:

    Unable to access the SQL*ReportWriter v1.1 tables.  They must
    be installed in your account, or you must be granted access to
    them before using SQLREP.

The SQL*ReportWriter manual says to see your DBA when this happens.
Where should I look for the solution to this problem.

Thank you for any advice or information,
Darrell.
-- 
Darrell W Johns         |Educational Computing Network  |Phone: 708/ 534-0200
Applications Consultant |Route #54 & Stuenkel Road      |FAX:   708/ 534-2042
                        |University Park, IL 60466-0975 |BITNET: XDWJ@ECNUXA
      INTERNET:xdwj@uxa.ecn.bgu.edu  -or-  djohns@heartland.bradley.edu