Using Oracle 8i or 9i and planning to use the new features?

But of course curious if it will work and what the performance aspects are…
I am planning to write a document with some of the Oracle 8i or 9i new features like:

Tablespaces
- Locally managed tablespaces (vs dictionary managed tablespaces)
- Read only tablespaces
- Resizing tablespaces (automatically, conditional, fixed)
- Temporary tablespaces
- Transportable tablespaces

Oracle File Management

Multiple Block Size

Automated PGA Memory Management

Tables
- Segment Space Management
- Partitioning

Indexes
- Normal
- Reverse key
- Partinioned vs non-partioned
- Bitmap join index
- Clustered
- Rebuilding and Coalescing

Undo data files

Shared server concepts

High Availability concepts

As maybe you already have some experience with any of these I like to hear your comments (private or via this medium). What did you use, why how and what are you’re your experiences.

At the moment I have finished my document I will let you know the results.

Thanks in advance,
Dick

I will surely follow and read. But you will also make these extra features available via a new database driver in the portingset? Which and when?

The Baan Oracle driver can handle most of the issues without any problem. The ones that are are not supported (yet) we have to find out if it is worth to change the driver. So if you can let me know with options you think are worh to implement I can forward it to the developers (who are also looking on this forum anyway ;)).

Kind regards,
Dick

What I am missing in the Oracle driver are certain debugging features.

Mostly, I would like to know how custom code will translate (and break up), so I can do an explain plan and load calculations before introducing the code to the system.

The bshell options just don't cut it there.

Can you eleberate a bit more what and how you what to have debugging on the driver? Do you want to start Oracle tracing at a certain point? And then turn off tracing? And what kind of tracing do you want to have: Baan tracing or real Oracle stuff with explain plan etc.?

Maybe we can learn from it.

Kind regards,
Dick

Back to the original post...

My collegue Oracle DBA told me that some of the features you mention have been in Oracle long before 8i and 9i ... you are making a document just now because these features have not been supported by Baan before?

As people don't know all possibilities I also will address some old topics. But I will mainly focus on the new issues.

The driver is nearly changed for Oracle 9 but supports a lot of new features as it is transparent from front to end. E.g locally-managed and undo tablespaces can be used without changing anything in the driver.