Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
18%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
12%
1500 - 2000 GB
18%
> 2000 GB
24%
Total votes: 17

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 27th December 2002, 11:59
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Question Baan and new Oracle features

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
Reply With Quote
  #2  
Old 27th December 2002, 12:22
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,075
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
Thumbs up

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?
__________________
Also read Luke 24:4-8
Reply With Quote
  #3  
Old 27th December 2002, 15:41
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
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
Reply With Quote
  #4  
Old 27th December 2002, 18:23
Francesco's Avatar
Francesco Francesco is offline
Guru
 
Join Date: Aug 2001
Location: Antwerp, BE
Posts: 727
Francesco is on a distinguished road
Baan: 5b - DB: Oracle - OS: Solaris
debugging

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.
__________________
Cheers,

Francesco
..............................................................

Admiral Business Solutions | My World | Baan Board | IT Happens!

"If everyone is thinking alike, then somebody isn't thinking" -- George Patton
"It's easy to cry 'bug' when the truth is that you've got a complex system and sometimes it takes a while to get all the components to co-exist peacefully." -- Doug Vargas
Reply With Quote
Sponsored Links
  #5  
Old 28th December 2002, 10:13
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
How to debug

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
Reply With Quote
  #6  
Old 30th December 2002, 12:59
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,075
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
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?
__________________
Also read Luke 24:4-8
Reply With Quote
  #7  
Old 30th December 2002, 13:06
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
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.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 22:24.


©2001-2018 - Baanboard.com - Baanforums.com