Home » RDBMS Server » Server Administration » will solaris 10 ZFS supports oracle 9i ora ...???
will solaris 10 ZFS supports oracle 9i ora ...??? [message #193564] Mon, 18 September 2006 05:19 Go to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member
hi friends

currently we r using solaris 8 with oracle 9i... now we want to upgrate it to solaris 10 ZFS(zetabyte file system) and oracle 9i. so will this combition work..?


Thanks & Regards

Report message to a moderator

Re: will solaris 10 ZFS supports oracle 9i ora ...??? [message #193580 is a reply to message #193564] Mon, 18 September 2006 06:03 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Yes, it should work just fine.

PS: I've heard roomers that ZFS might not be the best fileystem type for Oracle datafiles. However, I don't quite understand why this would be the case. Anyone with more info on this?

Report message to a moderator

Re: will solaris 10 ZFS supports oracle 9i ora ...??? [message #198284 is a reply to message #193580] Mon, 16 October 2006 06:47 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
More info on ZFS:

Apparently ZFS is based on a log-structure file system, in which all writes append into free space (copy-on-write). The filesystem is thus optimized for fast writes.

When ZFS runs out of free space, it will do garbage collection which may lead to fragmentation. This fragmentation may lead to poor database performance over time.

So, if you choose ZFS, be prepared to reorganize your databases frequently.

Report message to a moderator

Previous Topic: Data load from Informix to Oracle
Next Topic: unable to extend index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:45:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.