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
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: 4502
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?
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: 4502
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.
Previous Topic: Data load from Informix to Oracle
Next Topic: unable to extend index
Goto Forum:
  


Current Time: Tue Dec 06 13:51:15 CST 2016

Total time taken to generate the page: 0.14919 seconds