RE: Blobs and Extents

2002-02-22 Thread Gogala, Mladen
-Original Message- Sent: Friday, February 22, 2002 12:43 PM To: Multiple recipients of list ORACLE-L We are in the process of installing a GIS package (Arc/info) which has an oracle component (SDE) I have to setup tablespaces to handle various types of data, one of the

Re: Blobs and Extents

2002-02-22 Thread Peter Gram
Darren a 1 : === I would use both thprof to make sure that the SQL is efficient and statpack to monitor the full database a 2 : === I would never recommend to make the data files bigger than 2 Gb on unix, so anything up to 2 GB will be fine. How small you what to make the files depends on the