Blobs and Extents

2002-02-22 Thread Browett, Darren
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 tablespaces will be holding Tiff images. These images range are on average 25 Megs and there will be upto 200 images. It is

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