Solved

Oracle 8.1.7 End of Support

Posted on 2001-09-13
3
685 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 48

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 48

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

763 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