HDTenEightyP/NetNews huggingface dataset:
From: colten@cbnewsb.cb.att.com (marc.colten)
Subject: Re: Problems in olsqlforms30 and OCI (in C)
Summary: believe I've already tried that
Organization: AT&T
Date: Tue, 8 Sep 1992 12:25:38 GMT

In article <1992Sep7.115156.1307@hermes.dlogics.com>, dlm@hermes.dlogics.com writes:
> In article <1992Sep3.163521.26698@cbfsb.cb.att.com>, 
> colten@cbnewsb.cb.att.com (marc.colten) writes:
> > [...]
> > 
> > 3)  Can you do a query on a detail block and have the relevant
> >     information come up in the master block?  It works fine
> >     the other way.  I do a query in a master block and it brings
> >     up two records in the detail (which it should).  I've tried
> >     doing the reverse and it won't work.
> > 
> >     Is this possible?
> > 
> It is possible, but in very limited conditions. The limitation is that you must
> have only one master corresponding to the set of retrieved detail rows. If you
> query the detail on some non-key attribute, you will retrieve rows which may
> correspond to several different masters. In this case, which master shall you
> display? You might say, "all of them", but there is no key-enforcement
> mechanism in sqlforms that can do that; to query the master as if it were a
> detail, you will need just ONE key to enforce.
> 
> If this limitation is okay with you, then just write triggers that treat
> KEY-ENTQRY and KEY-EXEQRY in the detail exactly as if they are in the master,
> but with the block associations reversed. Sqlforms will not generate this
> relationship in the default-block display.

I believe I've already tried this.  The problem is, the trigger calls
functions that are geared to the master-detail relationship going one
way.  I haven't been able to find equivalences to "clear-<master>-details"
or "query-<master>-details".

If I do a "go_block(master)" and then a query, it wipes out the
values of the master block and waits for input.  I can't find a
function that takes the current values and runs with them.

marc colten
From: gamet@erg.sri.com (Thomas Gamet)
Subject: Server performance information sought
Summary: Server performance information sought
Keywords: performance information
Organization: SRI International, Menlo Park, CA
Distribution: usa
Date: Tue, 8 Sep 92 22:31:01 GMT
Expires: 1992Sep12

Dear netters:

My exposure to Oracle is little and infrequent, however, I have been
asked to identify relative Oracle server performance differences on the
following platforms:  386/33MHz64k, 486/25Mhz128k, SPARC 2, 
HP 9000/380 and HP 9000/750.  My search is strictly through literature
and a crude but reliable estimate would suffice.  

Can anyone suggest an article which benchmarks Oracle on these or
similar platforms?

Thank you in advance.

Thomas Gamet
SRI International (gamet@erg.sri.com)
Disclaimer:  Any opinions expressed herein are those of the author, and
             in no way imply those of SRI International.
From: cintra4@milton.u.washington.edu (Dave Lange)
Newsgroups: comp.databases.oracle
Subject: more info about: Re: Which DEC/Ultrix box to pick?
Date: 13 Sep 92 16:54:29 GMT
Organization: University of Washington, Seattle

In article <1992Sep13.044653.2579@u.washington.edu> cintra4@milton.u.washington.edu (Dave Lange) writes:
This paragraph was left out of my message, sorry.
I have chosen Oracle for a database to hold 500M to 1.5G of data for querying,
not transactions or dataentry. It will be used by a maximum of 5 users at a 
time. I originally intended to use oracl.nlm on a dedicated netware server.
The hardware was to be an EISA based 486DX2-66 with 17M, an Adaptec 1740 SCSI
contro and a 32 bit ethernet board.

>I would like to consider shifting this to unix, using the DEC platforms.
>I understand unix has a flat loading curve as the number of users
>increases, but this isn't my situation. What I need is the lower part
>of this load curve to match or exceed the performance the NLM would have
>provided on the selected platform.
>
>Without starting wars over whose system is better, I would like to know
>what you have found out, in terms of benchmarks or use, about which
>Ultrix box will give me equivalent performance in my situation.
>
>Also, how close to the top of the list is Ultrix in terms of when new
>releases of Oracle are ported to different platforms? 
>
>Your choice to post or email me. TIA
>
>Dave Lange (cintra4@u.washington.edu)
Newsgroups: comp.databases.oracle
From: sstephen@us.oracle.com
Subject: Re: Problem with EXIT_FORM (Domino-effect)
Organization: Oracle Corporation, USA
Date: Sun, 13 Sep 1992 01:06:29 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 <1992Sep12.170010.1@us.oracle.com>, sstephen@us.oracle.com writes:
> 
> KEY-PRVBLK
> ==========
> NEW_FORM(FORM_ATTRIBUTE('CALLING_FORM'));
> 
> KEY-EXIT
> ========
> EXIT_FORM;
> 
> Probably even more elegant would be to have a table of "what form to call
> next", and query a value rather than using :SYSTEM.CALLING_FORM, but I guess
> that depends on how complex your application is.

Rats! Just remembered that the "calling form", would be wrong after the first
previous-block.  The "calling form", MUST be stored in a table or global
variable.

 Scott Stephens (Just my own observations, not the offical Oracle answer).
From: copler@moose.cs.indiana.edu (judith copler)
Newsgroups: comp.databases.oracle
Subject: WORKSHOP ANNOUNCEMENT--RELATIONAL DATABASE ADMINISTRATION
Date: 14 Sep 92 22:39:13 GMT
Organization: Computer Science, Indiana University
X-Mailer: Mail User's Shell (7.2.3 5/22/91)


ANNOUNCEMENT of WORKSHOP

Relational Database Administration & Management

Friday, Oct 9, 1992
8:30AM - 4:30PM
Market Tower Conference Center, Indianapolis, IN

WORKSHOP OBJECTIVE

All participants should gain and understanding of the tasks
associated with database administration and management, the options
available for database back-up and recovery, the elements of
successful data securty and integrity policies, the measures
required to eliminate downtime and ensure efficient applications, 
and successful strategies for dealing with database vendors.  
Examples will focus on comparing and contrasting database
administration tasks and options associated with commercial
products such as DB2, Ingres, Oracle and Sybase.

Instructor:  Nancy Martin

Sponsored by the Indiana Center for Database Systems (Indiana
University/ Purdue University)

For more information contact:

Hallie Rose, Assistant to the Director
Indiana Center for Database Systems
812-855-2490
From: tegan@broke.enet.dec.com
Newsgroups: comp.databases.oracle
Subject: Oracle User's Group Meeting
Date: 9 Sep 92 18:20:51 GMT
Reply-To: tegan@broke.enet.dec.com ()
Organization: Digital Equipment Corporation


Can someone give me some information about Oracle User's Groups.  How
does one become
a member?  When and where are the meetings held?

Thanks,

Patrice
Newsgroups: comp.databases.oracle
From: troy@cbme.unsw.EDU.AU (Troy Rollo)
Subject: Re: Summary: Controlling "ad hoc" queries
Organization: University of New South Wales
Date: Fri, 11 Sep 1992 01:42:24 GMT

> Are "user query tools" a dead end, due to inadequate protection against
> "incorrect" queries?
 .
 .
> writing tools...)?.  If not, how are they best used (only with heavy
> training for users, small databases only, on extracted "reporting"
> databases...)?

No, they're not really a dead end.

I was hoping to see a little more discussion before I threw my $.02 in.
Before I start, I should mention that anything I say may well be biased
because I head up a team developing a Windows based end user query
and report writing tool, with ad hoc reports.

A number of solutions are being used. The simplest, for dealing with
overgrown queries, is both fascist and liberal limits being imposed
on the tool (We do this by means of a client/server system, and impose
the limits at the server, thus preventing wasted network traffic).
The liberal limit informs the user periodically that the current
query is really not at all simple and asks them if they really
want you to do it. The fascist limit states in not so many words that
the administrator thinks you are being unreasonable and you should
go back and try it again.

These are both configurable limits based on number of bytes and/or rows.
Should the limit be enforced, the server informs the database via a
cancel message, and if the user is really desperate they can still use
whatever they did get back.

Some clients prefer to take summary tables on a daily basis in the
early hours when nobody is accessing the database, and then allow
the users access to only those summary tables, or to those summary
tables together with a subset of source tables.

The second issue I think you were asking about is the issue of
users not knowing the structure of the database and doing something
which returned meaningless results (by, for example, misspecifying
the joins). Without trying to get into an advertising blurb, our
approach is, said briefly, to have the tool do the joins itself,
thus eliminating the need for the user to do them. There are a
lot of subtleties in doing that, which I won't go into here.
--
__________________________________________________________________________
troy@cbme.unsw.EDU.AU	Overworked, overcommited and always multitasking.
        Fine, so I'm an FOFH. Now shut up and don't complain.
From: pihlab@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Re: Summary: Controlling "ad hoc" queries
Date: 15 Sep 92 09:35:08 +1000
Organization: Aust. Dept. Health, Housing and Community Services

In article <lapscgINN8jg@news.bbn.com> Nat Brooks, NBROOKS@BBN.COM writes:
>Has anyone out there successfully installed and supported an end user
>query tool that was actually used by end users?

Something I didn't include in the original reply is that we try to run end-user
adhoc querries on multiple CPU machines (the more CPUs the better).

The reason for this is that an "evil" query will normally only thrash one CPU
at a time so other "good" querries will still get a bite of the cherry from
the other CPUs.

Of course, you still have disk I/O contention and such but our experience has
been that "evil" querries are doing lots of full table scans and Oracle6
doesn't flush these through the SGA buffers as much as Oracle5 so "good"
querries are still getting reasonable hits in the buffers.

The more CPUs you have, the more "evil" querries that can be tolerated.

-- 

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: cintra4@milton.u.washington.edu (Dave Lange)
Subject: Which DEC/Ultrix box to pick?
Organization: University of Washington, Seattle
Date: Sun, 13 Sep 1992 04:46:53 GMT

I would like to consider shifting this to unix, using the DEC platforms.
I understand unix has a flat loading curve as the number of users
increases, but this isn't my situation. What I need is the lower part
of this load curve to match or exceed the performance the NLM would have
provided on the selected platform.

Without starting wars over whose system is better, I would like to know
what you have found out, in terms of benchmarks or use, about which
Ultrix box will give me equivalent performance in my situation.

Also, how close to the top of the list is Ultrix in terms of when new
releases of Oracle are ported to different platforms? 

Your choice to post or email me. TIA

Dave Lange (cintra4@u.washington.edu)
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Problem with EXIT_FORM (Domino-effect)
Date: 9 Sep 92 07:14:49 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna


Hi,

My english is not very good, but I hope you will understand me. I have a form 
which calls another form. And this form calls another form and another form 
and so on. Now if I press the <PAGE UP> key, I want to exit the current 
form. But if I press the <EXIT> key, I want to exit all forms, so I get 
back to the operating system or SQL*Menu.

-------- OS -----------
  |                 ^
Form A              |
  |                 |
  v                 |
Form B              |
  |                 |<EXIT>
  v                 |
Form C<--+          |
  |      |<PG UP>   |
  v      |          |
Form D--------------+


The only way I know, is to work with a global flag, I call it GLOBAL.EXIT. 
If I press the <EXIT> key, a global flag is set to TRUE and an exit occurs.
The previous form now looks if global.exit was set to true. If it was set, 
the previous form also releases an exit. This is like the Domino-effect.

Triggers:

KEY-EXIT
========

:GLOBAL.EXIT := 'TRUE';
EXIT_FORM;

KEY-PRVBLK
==========

:GLOBAL.EXIT := 'FALSE';
EXIT_FORM;

Previous form (eg. Form C):

Procedure "CALL_FORM_D"

CALL('FORM_D');

DEFAULT_VALUE('FALSE','GLOBAL.EXIT');

IF :GLOBAL.EXIT = 'TRUE' THEN 
   EXIT_FORM;
END IF;


This is my solution, but is there any way to do this more easily ?

Any ideas ?

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
 Bankgasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================
Newsgroups: comp.databases.oracle
From: dweissman@amarna.gsfc.nasa.gov (WiseGuy)
Subject: Oracle NLM
News-Software: VAX/VMS VNEWS 1.4-b1  
Reply-To: sysajm@bfec2.gsfc.nasa.gov
Organization: NASA Goddard Space Flight Center, Greenbelt, Md. USA
Date: Wed, 9 Sep 1992 15:52:00 GMT

We are getting ready to install the Oracle server NLM on our LAN and
we were wondering if anyone else that has already installed this product
has encountered any problems or has any pointers for us.

replies to sysajm@bfec2.gsfc.nasa.gov
================================================================================
Dave Weissman - WAN/LAN Networking

   Allied-Signal Aerospace        Internet#1 - dweissman@amarna.gsfc.nasa.gov
   BFEC - Dept. 976               Internet#2 - sysdhw@bfec2.gsfc.nasa.gov
   One Bendix Road                SPRINTnet's X.400 -
   Columbia, Maryland 21045-1897  (C:USA,A:TELEMAIL,P:GSFC,FN:DAVID,SN:WEISSMAN)
Newsgroups: comp.databases.oracle
From: mharper@well.sf.ca.us (Michael J. Harper)
Subject: Changing Column Name
Organization: Whole Earth 'Lectronic Link
Distribution: usa
Date: Wed, 9 Sep 1992 19:11:22 GMT

This should be an easy one :-)

How do I change the name of a column in a table?

Michael J. Harper
mharper@well.sf.ca.us
From: kmallory@oracle.com (Kevin Mallory)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*Net performance - why this way?
Date: 9 Sep 92 19:42: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.

What "EXACT" Version of forms were you using for your tests?
There are performance enhancements in forms 3.0.16.10 (or greater)
that will improve the performance of client server forms applications.
--
---------------
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**!
From: jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
Subject: Re: SQL*Net performance - why this way?
Date: 10 Sep 92 07:02:30 GMT
Organization: University of Helsinki

In article <KMALLORY.92Sep9114249@hqsun4.oracle.com>, kmallory@oracle.com (Kevin Mallory) writes:
> What "EXACT" Version of forms were you using for your tests?
We used SQL*Forms 3.0.16.5.1 on the PCs. SQL*Net/APPC was 1.1.0.3

> There are performance enhancements in forms 3.0.16.10 (or greater)
> that will improve the performance of client server forms applications.

What enhancements are those? UPIALL or something extra? Does it require
a particular version of the RDBMS?

Anyway, what is that famous UPIALL? I know that it decreases amount of
messages by combining many small messages into bigger ones, but could
you specify it more specifically?

The original question was, WHY NetBIOS & SPX/IPX are faster than TCP/IP
and why TCP/IP is faster than APPC when using PC clients? And are there
any tunable, significant parameters I should tinker with in order to
obtain better performance? If SQL*Forms gets better and SQL*Net remains
unchanged, I guess the relative order of the various protocols remains
the same.

--
Juhani Jaakola
jaakola@cc.helsinki.fi
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases.oracle
Subject: Re: Trouble with name_in function (re-post)
Date: 14 Sep 92 15:46:22 GMT
Followup-To: comp.databases.oracle
Organization: Dartmouth College

In article <dewey-110992125749@sebastian.centerline.com>,
dewey@centerline.com (Devan F. Dewey) wrote [in part]:
>         blk := :system.cursor_block;
>         fld :=  blk || '.explination';
> 
>  >>>    explination := name_in(name_in('fld'));
> 
> 
> I'm trying to put the value stored in the field :hotel.explination into the
> local variable explination.
> 
> What am I doing wrong???

Try:  explination := name_in(:system.cursor_block||'.explination');

The description of name_in() in the manual is confusing (to me at least). 
If you don't need any indirection, you can go:

     explination := :hotel.explination;

> BTW: I've been trying to e-mail this to ORACLE support. Does anyone have an
> e-mail address for them???

Wouldn't it be nice if they had an email address?

I hope you had a good reason for the spelling of that variable because it's
exacerbating my neurosis.
From: dlm@hermes.dlogics.com
Newsgroups: comp.databases.oracle
Subject: Re: Oracle7 userids
Date: 3 Sep 92 11:14:24 CST
Organization: Datalogics, Inc., Chicago, IL

In article <1992Sep1.161828.337@hhcs.gov.au>, pihlab@hhcs.gov.au writes:
> 
> Under Oracle6 when you revoke all access for a user there is no easy
> way of actually removing them completely from the database ie they still
> appear in the DBA_USERS table as a valid but inactive user.
> 
> Has this changed under Oracle7 ?
> 
Yes, in V7 you have the syntax DROP USER name CASCADE; which kills off
the user's objects and all records of the userid.
--
Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450
dlm@dlogics.com                                 Motto: Just show me the code
Newsgroups: comp.databases.oracle
From: XB.K14@forsythe.stanford.edu (Pechler)
Subject: Report writers for ORACLE?
Organization: Stanford University, California, USA
Date: Sun, 13 Sep 1992 21:54:33 GMT


I'd be quite interested in a recent and thorough comparison of
ORACLE query generators and report writers (such as SQL/ASSIST).
Any references would be much appreciated.

Anyone uptodate with IOUG (starts tomorrow in San Francisco)?  In
a preliminary set of abstracts I thought I saw a talk announced
about ORACLE Reportwriter and competing products.  Will the
presentation in fact be given?  Time and location?

Thanks in advance, -Henk.
From: kml@cellar.org (John Galt)
Newsgroups: comp.databases.oracle
Subject: Call for questions for DBA FAQ
Date: 5 Sep 92 23:45:20 GMT
Organization: The Cellar BBS and public access system


I'm puttin together a DBA FAQ for this board that will be posted monthly.
Please let me know what you'd like to see if it's not in the list below:

Tablespace Management
Moving objects in the database
Monitoring performance
Fragmentation
Chaining
Automating DBA futions

Any thoughts, mail me at kml@cellar.org.

Kevin.


       As a matter of fact, no, I don't have a life.
  kml%cellar@tredysvr.tredydev.unisys.com - My other account is a Mercedes.
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases.oracle
Subject: Re: Weird GROUP BY/TO_CHAR(date) Interaction?
Date: 14 Sep 92 15:30:52 GMT
Followup-To: comp.databases.oracle
Organization: Dartmouth College

I have further isolated the problem described in my previous posting on
this subject.  It appears to require a view, hence I suspect a kernel
problem.  I feel hesitant to call it a bug, since I'm not sure what it
should be doing.  There is no need to refer to my previous message.  Here's
what you need to reproduce the problem:

$ sqlplus /

SQL*Plus: Version 3.0.11.5.1 - Production on Mon Sep 14 10:09:11 1992

Copyright (c) Oracle Corporation 1979, 1992.  All rights reserved.


Connected to:
ORACLE RDBMS V6.0.35.1.0 (6.2), transaction processing option - Production
PL/SQL V1.0.34.2.0 - Production

SQL> create table bug1(d char(4));
Table created.
SQL> insert into bug1 values('9203');
1 row created.
SQL> insert into bug1 values('9204');
1 row created.
SQL> insert into bug1 values('9205');
1 row created.
SQL> insert into bug1 values('9205');
1 row created.
SQL> create view bug1v as select to_date(d,'YYMM') d from bug1;
View created.

SQL> select d from bug1v;
D
---------
01-MAR-92
01-APR-92
01-MAY-92
01-MAY-92

4 rows selected.

SQL> select to_char(d) from bug1v;
TO_CHAR(D)
---------------------------------------------------------------------------
01-MAR-92
01-APR-92
01-MAY-92
01-MAY-92

4 rows selected.

SQL> select d from bug1v group by d;
D
---------
01-MAR-92
01-APR-92
01-MAY-92

3 rows selected.

SQL> select to_char(d) from bug1v group by to_char(d);

TO_CHAR(D)
---------------------------------------------------------------------------
01-APR-92
01-MAR-92
01-MAY-92

3 rows selected.

SQL> select to_char(d) from bug1v group by d;
TO_CHAR(D)
---------------------------------------------------------------------------
01-MAY-92
01-MAY-92
01-MAY-92

3 rows selected.

SQL>

The results of the last select are baffling to me.  I realize there is no
reasons to leave out the to_char in the group by, but why does it matter? 
It does what I expect if I replace bug1v with a table containing the date
values.  We're on VMS 5.3.
From: shamel@mais.hydro.qc.ca (Stephane Hamel)
Newsgroups: comp.databases.oracle
Subject: Calling a form from C
Date: 10 Sep 92 20:39:51 GMT
Organization: Hydro-Quebec (DSB)

I would like to know if it's possible to call an SQL*Forms form from wittin
a C program.

Does any one did that before? If so, I would like to get some code example.
--
 Stephane Hamel (SHamel@Mais.Hydro.Qc.Ca)