| Disk Useage Problems [message #53466] |
Mon, 23 September 2002 07:35  |
Kevin Lyons
Messages: 2
Registered: September 2002
|
Junior Member |
|
|
Probably a complete newbie question here, but we're having some trouble with oracle using massive amounts of disk space and we can't figure out quite what's going on.
System is a basically fresh Oracle 8.1.7 install on a Solarix 2.8 system.
Situation is, we load a 4.1 million row file into a table (archive log mode on in it's own tablespace with nologging set) with the following schema:
Name Null? Type
---------- --------- ------------------------
CASETYPE CHAR(1)
COUNTY CHAR(2)
CASEID1 CHAR(2)
CASEID2 CHAR(2)
CASEID3 CHAR(7)
PARTYTYPE CHAR(3)
PARTYNAME CHAR(40)
ATTORNEY CHAR(5)
JUDGE CHAR(5)
CAPTION CHAR(60)
The datafile is loaded through sqlldr, with the REPLACE option specified, and the load is done nightly. Indexes (on CASEID1, PARTYNAME, ATTORNEY, JUDGE) are dropped before the load via sqlplus, then recreated afterward, the nologging option used on each one.
The datafile for the table is currently 8Gig, 7.8Gig used, 31Meg free, which seems highly excessive concidering that approx 410Mg of data is being loaded. The file is growing at close to 500M a day.
What APPEARS to be happening (to our limited experience with Oracle) is that, dispite the use of the REPLACE flag, old information is not actually being deleted from the file, it's just, for lack of a better term, being marked as "unused".
If this is true, or if anyone can explain A) What's going on and/or B) how the heck we fix this, it would be VERY much appreaciated.
|
|
|
|
|
|
| Re: Disk Useage Problems [message #53469 is a reply to message #53466] |
Mon, 23 September 2002 09:00  |
Kevin Lyons
Messages: 2
Registered: September 2002
|
Junior Member |
|
|
> REPLACE option overwrites the table data.
> but does not reset the highwatermark!!.
> so, truncte the table before loading the data.
Wonderful, all I had to do was add a TRUNCATE statement after the REPLACE statement in the control file and it worked! Thanks much!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
