RE: Oracle From a Sybase DBA perspective

> Also appeared that you are stuck with one block size, anyone know if this
has changed?

Sybase 11.0 and prior had only 1 "page size" - 2k (except for 1 obscure platform that i can't recall which was 4k). With 11.5(?) they added a feature called Large I/O which allowed you to have 2k, 4k, 8k, or 16k "pools" in memory to improve I/O.

FWIW - i agree the person who wrote that paper isn't the sharpest tool in the shed. i stopped reading after point 14. in my opinion Sybase and Oracle both have strengths and weaknesses; as does any platform. a wise person will leverage the strengths and strive to minimize the weaknesses of whatever platform she finds herself on.

-----Original Message-----
Sent: Friday, March 29, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L

I can only speak to Sybase 11 since that is the book I am reading but the book actually makes the suggestion to speed up backups on large databases to split your database into multiple databases because you can backup each database independently. This also appears to be how they exert more control over distribution of IO. This presents serious problems with database consistency and referential integrity of course.

Also appeared that you are stuck with one block size, anyone know if this has changed?

• Ethan

-----Original Message-----
Sent: Friday, March 29, 2002 2:10 PM
To: Multiple recipients of list ORACLE-L

Part III of ????

Point 23: "Only one database per server"???? Oh no! Now what do I do with our HP that has 3 or 4 Oracle instances on it????!?

OK, OK, I need to stop reading this and get back to work...

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

Disclaimer: I'm an idiot, but the difference between me and other idiots is that I know I'm an idiot.

-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: STEVE OLLIG
  INET: sollig_at_lifetouch.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).