Oracle Magazine

Oracle Magazine–March 1995

Posted on

In 1995 we have a change to the frequency of publication of Oracle Magazine. It is not published every 2 two months with 6 editions each year, as it is still the case.

The headline articles in the March/April 1994 edition of Oracle Magazine included Integrating Unstructured Information, Minimizing Client/Server Network Traffic with Oracle Forms 4.0, Relational Objects and how the Canadian Postal Service was using Oracle Technology to deliver mail on time.

image

Other articles include:

Dynamic SQL Comes to PL/SQL: Introduces us to the DBMS_SQL package. A useful quick reference one pager is given giving the details of each of the 15 procedures and functions, including, BIND_VARIABLE, CLOSE_CURSOR, COLUMN_VALUE, DEFINE_COLUMN, EXECUTE, EXECUTE_AND_FETCH, FETCH_ROWS, IS_OPEN, LAST_ERROR_POSITION, LAST_ROW_COUNT, LAST_ROW_ID, LAST_SQL_FUNCTION_CODE, OPEN_CURSOR, PARSE, VARIABLE_VALUE.

Personal Oracle 7 for Windows gets released and it now has a graphical administration tool to allow us to manage the database, including users, backup and recovery managers along with export/import and SQL*Loader and Oracle Objects for OLE. The hardware requirements included 8Mb of RAM and less than 30Mb of hard-disk space. How things have changed!!!. It was capable of running on Window 3.1 and was Windows 95 ready.

Rollback segments in in Oracle 7 allows use to now effectively manage our transactions. It gave the following recommendations:

  • Create a separate tablespace for rollback segments for administrative and monitoring purposes
  • Se the size of the tablespace according to the number and storage parameters of the rollback segments
  • Place your rollback segment tablespace on a separate disk device, if possible. Consider total I/O activities and spread I/O over available disk devices
  • Create one rollback segment for every four concurrent transactions
  • Don’t create more than 50 rollback segments
  • Create smaller rollback segments for OLTP applications. This increases the likelihood that rollback segments will be cached in SGA according to the least recently used algorithm, resulting in performance gain
  • Create larger rollback segments for decision support or back processing applications
  • Set initial to you average transaction size, set OPTIMAL to four to eight times larger than INITIAL

Oracle Magazine goes digital and interactive with a CD-ROM containing every issue of published in the previous two years and also contained a map of Oracle offices worldwide.

To view the cover page and the table of contents click on the above image or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions.

Advertisements

Tom Kyte is in Belfast 16th April

Posted on

The Oracle User Group has organised for Tom Kyte the famous Oracle evangelist to come Belfast to give a one day seminar.

The seminar will be in the Hilton in Belfast.

Some of the topics to be covered on the day include:

  • 5 things you probably didn’t know about SQL
  • 5 thing you probably didn’t know about PL/SQL
  • All about metadata: why telling the database about your schema matters
  • What is New and Improved and Coming in Oracle Application Development
  • All about Oracle Database Security.

All of this will followed by a 1 hour Ask Tom session, where you will have your chance to ask the man himself anything about the Oracle database.

This is a FREE event. What more could you ask for!

Check out the OUG website for more details and how to register for this event.

http://www.ukoug.org/events/tom-kyte-seminar-and-asktom-live/

Don’t forget to use the OUG Ireland twitter tag  #oug_ire

Oracle Magazine–Summer 1994

Posted on

The headline articles in the Summer 1994 edition of Oracle Magazine included Objects in Motion on how to reap the benefits of OO technology, building a business case for Objects, working with Objects and some basics of OO programming.

image

As part of the articles on Objects, there was an interview with Steve Jobs who was an Object Evangelist at NeXT.

Apart from the articles on Objects we also had articles on:

  • System Level Roles in Oracle 7: Going beyond Connect, Resource and DBA. In Oracle 7 the DBA can not create role groups.
  • Customising Oracle Reports with PL/SQL: This article explores the different triggers that now exist in Oracle Report, where we can now use PL/SQL to perform pre-processing of data before it is displayed in the report output. The triggers included Before Runtime Parameter Form, Parameter Validation, After Runtime Parameter Form, Before Report (executes), Object level triggers, Between Each Page and After Report
  • How Nintendo is using Oracle 7 client/server to stay ahead with providing faster and easier access to sales and marketing information.

To view the cover page and the table of contents click on the above image or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions.

Oracle Magazine–Winter 1994

Posted on

The headline articles of the Winter 1994 edition of Oracle Magazine included topics on how an energy company migrated to client/server, towards the paperless office (it never really happened!!), Business Processing Reengineering and document management.

image

There was a noticeable number of articles and advertisements on reporting tools. The tools mentioned included Oracle Browser version 2.0, Oracle Data Query, Impromptu, Intelligent Query (IQ), Visual CyberQuery, R&R Report Writer, ReportSmith and SQL Assist

There was also an article called ‘An Elegant Approach to Report Generation’ and looked at how you could take the ASCII file produced by a SQL report and load it into a WordPerfect template.

We have the first mention of on Oracle Certification. ‘Database administrators and application developers can now become Oracle Certified to demonstrate their skill and competence in using Oracle systems. ……. Upon successfully completing the exam – which covers such areas as using SQL and Oracle Forms, tuning applications, and administrating and Oracle database – students will be awarded with the title of Oracle Certified Administrator and/or Oracle Certified Application Developer’.

Oracle announces the launch of their Real-Time Support System. Unlike My Oracle Support we have today, back in 1994 you needed a modem and remote communications package that could emulate a SQL*Forms support terminal type.

There was an article, by Kevin Loney, on how you could add Help documentation to your Oracle Forms applications using Oracle*Text Retrieval 2.0.

Finally there was an article by the IOUG about their International Oracle User Week in 1993. This event was held in the Orange County Convention Center in Orlando FL, where there was an attendance of 3,300 participants. This conference has since been expanded and is now call COLLABORATE and will be in Las Vegas in 2012 on 22-26 April (I wish I could be there).

To view the cover page and the table of contents click on the above image or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions.

Oracle Magazine–Fall 1993

Posted on

The headline articles of the Fall 1993 edition of Oracle Magazine included topics on Multimedia Servers, Free Space Defragmentation and Geographic Information Systems.

image

Apart from the head line articles most of the other articles were about product announcements/updates and about how certain types of companies were using IT.

The main technical article was by Kevin Loney on freeing up free space in an Oracle 6 database using defragmentation. This was a popular topic for Oracle version 6 and 7, when disk space was expensive. It is less of an issue today.

There was an article on the Digital Highway and in Multimedia Servers. These were early indicators of Larry’s investing in the Video On-Demand servers.

The first maintenance release of Oracle 7 database was announced (Oracle 7.1), with enhancements centred around:

  • Parallel Operations : performance increases, splitting of query execution, data loading and index creation tasks and execute them concurrently on multiple CPS. Permits multiple sessions running SQL*Loader using the fast bulk load i.e.direct path
  • Application Development : Users can now embed PL/SQL functions in SQL statements and reference those functions in SQL expressions as if they are build-in.
  • Administration : Tablespaces can be placed in read-only mode. Provides a parallel recovery mechanism.
  • Standards Compliance : Oracle 7.1 is compliance with the SQL92 Entry Level standard. The ORDER BY clause can not reference SELECT list items names with a column alias.

Some of the products discussed in articles included Pro*C version 2.0, SQL*Module version 1.0, OracleWare, Oracle Graphics version 2.0, SQL*Net version 2 on MVS, SQL*Connect to SQL/400 and Oracle Card 2.0.

Apart from these product related articles, some others of interest included an advertisement for ERwin which was a product owned at that time by Logic Works.

There was a short article on the IOUG 12th Annual User Group Conference in September.

To view the cover page and the table of contents click on the above image or click here.

My Oracle Magazine Collection can be found here.

My previous posts on Oracle Magazine
  – Winter 1993
  – Fall 1992

Oracle Magazine–Winter 1993

Posted on

The lead articles in the first Oracle Magazine of 1993 (winter) were about how the Oracle database was being used in the Toronto Stock Exchange and in the Municipio de Panama of Panama City.

image

Other articles of interest included

  • Cary Millsap on the Optimal Flexible Architecture. Was this Cary’s first article in Oracle Magazine ? OFA provided a set of guidelines on how to install Oracle so that performance is not affected as your database environment grows. Cary gives 3 basic rules for creating and ODA compliant Oracle database (the full set is in the article).
    1. Establish and orderly operating system directory structure in which any database file can be stored on any disk resources (applicable to operating systems with hierarchical directory structures only).
    2. Separate groups of segments with different behavior into different tablespaces.
    3. Maximize database reliability and performance by separating database components across disk resources
  • There was 2 articles that looked at OODBMS. Oracle made their first purchase of an OODBMS company in 1994 and were trying to release their first OODBMS product in 1995. This never happened and their reverted to integrating some OODBMS features into the database instead.
  • Oracle Glue is released. This product has gone through a number of name changes since. What is it called now ?
  • There was a couple of articles discussing using UNIX or ALPHA server machines, when VLDBs were considered extremely large at 32GB. I remember there was one Bank who had the largest database in Ireland in 1993 and it was 4GB. I wonder what it is now.
  • Business Object announces the release of their DOS and Windows end user data access tool for relational database tool.
  • There was a number of adverts from companies providing tools and support for converting your Oracle Forms Version 2 to Forms 3

 

Click on the image above to view the PDF of the table of contents page.

My Oracle Magazine Collection can be found here.

Oracle Magazine-Fall 1992

Posted on

I’ve been collecting Oracle Magazine for almost 20 years now. I have almost the entire collection, but I’m still missing some of the editions. Some people have donated some of the editions I was missing. But I still missing some.  Can you help me ? Check out my Oracle Magazine Collection.

Every 2 to 3 weeks I intend to write a blog post on each of the Oracle Magazines that I have, starting with the earliest edition that is from Fall 1992.

image

The main theme of the Fall 1992 edition was about the new Oracle 7 Database. I didn’t get using an Oracle 7 Database until mid-1994.There are a few customer case studies of Oracle 7 implementations. In the article Migrating to Oracle 7, they list some of the new feature. The following is an extract from the new features section.

Standard Oracle 7 provides the functionality and performance to tackle most mission critical applications:

– Multithreaded server
– Shared SQL
– Cost Based optimiser
– Row level locking
– Declarative integrity
– Role based security
– 100% ANSI/ISO standard SQL
– Enhanced national language support

The procedural option for Oracle 7 provides additional capabilities that enhance the database server in the application environment:

– Stored Procedures and Functions
– Procedure packages
– Database Triggers
– Lock manager package
– Database alerts

The distributed option for Oracle 7 makes a physically distributed database appear as a single, logical database. Features of this option include:

– Distributed updates
– TP monitor (XA) interface
– Transparent two-phase commit
– Remote procedure calls
– Table replication (snapshots)
– Oracle Mail Interface

Another article that stands out is by Richard Barker (do you remember his?) who was responsible for the CASE*Method and Oracle’s CASE Tools.

There was several articles on the new Oracle Forms 3 and Oracle Menu 5. Talking about some of the new features like List of Values (LOVs), pop-up Field editor and Pop-up Pages.

There also also the first articles on using Oracle a Microsoft Windows environment. Oh how I remember the frequent blue screens when developing and compiling my forms and in particular my report, with does early releases on Windows.

 

The editorial staff of Oracle Magazine have kindly given me permission to make a PDF of the front cover and the table of contents available for each edition. To get this PDF click on the above image or follow this link to see what Oracle Magazine used to look like 20 years ago.

My next blog post on Oracle Magazine, will look at the Winter 1993 edition.

If you have any of the editions that I’m missing from my collection and you would like to donate then, then drop me an email and we can arrange delivery.  You wont see any of them on eBay, I promise.