Solved

Oracle 8.1.7 End of Support

Posted on 2001-09-13
3
678 Views
Last Modified: 2012-08-13
Hi,
    I am currently working with 8.1.7, and I am wondering if anybody knows when will Oracle stop support of this release???

Does anybody know???
0
Comment
Question by:spikejp
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
schwertner earned 50 total points
ID: 6482105
The following notice will help you to get oriented in the state of the art.

Be aware that Oracle issued a desupport notice on Oracle 8.0.5 last year.
Product:  Oracle8, version 8.0.5
Error Correction Support ends on:     June 30, 2000
Extended Assistance Support ends on:      June 30, 2003
This means any errors found in 8.0.5 since June last year are not going to be fixed. All support stops in June 2003.

Error correction support for Oracle8, Release 8.0.6 is also scheduled to cease on 30 September 2001.

It appears Oracle are pushing people to use 8.1.7 at the moment, though the users are sure 8.1.6 still has life in it!

My prediction is that 8.1.7 will be supported for years.

0
 

Author Comment

by:spikejp
ID: 6482589
Schwertner,
           thank you for your concise and prompt answer.
It is greatly appreciated.

Spikejp
0
 
LVL 47

Expert Comment

by:schwertner
ID: 6489802
Hi Spikejp,
thanks for the points!

I just found this info:

Why Move to Oracle9i Database:
Oracle9i Database will support the second wave of the internet revolution into the wireless world. It is a leap past the technology of Oracle8i, not only in Java support but also in both scalability and recoverability.

Clustering technology is finally here, allowing you to scale dynamically and instantly (Compaq's True 64-bit).
You can change table storage, index operations, analyze tables and indexes, change partitions, and add partitions while the database is in use, minimizing downtime.
Oracle9i Database provides the options for trial recovery as well as resumable recovery, minimizing recovery time.
Oracle9i also lets you perform block-level recovery, maximizing availability.
You can change data cache and shared pool without database restarts, increasing performance. For example:
To read Rich Niemiec's Oracle OpenWorld presentation "Performance Tuning for the Expert," go to http://www.tusc.com/oracle/
download/author.html#niemiecr.  
db_block_buffers becomes db_cache_size
buffer_pool_keep (recycle) becomes db_keep_cache_size
(recycle)


You can use multiple block sizes?for example, small block sizes for systems with heavy transaction processing and large block sizes for data warehouses:
db_block_size (main cache uses this block size)
db_2k_cache_size, db_4k_cache_size... db_32k_cache_size
(specify these)


You can perform system-managed undo instead of using rollback segments, saving maintenance time:
undo_management, undo_tablespace, and undo_retention
(be careful setting these).

Why Move to Oracle9i Application Server:
Oracle9i Application Server is a completely different product from Oracle Application Server, and it's a full two orders of magnitude faster. Oracle9iAS uses the Apache listener, whereas OAS used the SpyGlass listener. The new listener is more than 100 times faster than OAS. For example, during my testing, Oracle9iAS processed 2,300 pages per second, compared to OAS at 50 pages per second and Oracle Application Server at 200 pages per second. And Oracle9iAS with HTTP 1.1 (Internet Explorer 5.0 and higher, or Netscape 4.7 and higher) processed 5,200 pages per second. Your times may vary, but you can expect substantial improvements.
In addition, Oracle9iAS has the latest version of Oracle Portal, providing browser-based access to everything and giving you the ability to consolidate your Web sites.

And finally, Oracle9iAS has Web-page and table caching.

0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
scheduler for Procedure in DB with 3 arguments in 10g 7 33
Oracle sql query 7 60
exp/imp 25 73
Function to return one result based on data in first query 11 44
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

774 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question