Big usr1xxx.ora Files ??

Is here a real PRO wich can tell me why Oracle uses so much space in the USR file ? When I generate a DMP-File of a DB, wich uses 1.8 Gig, the Dump is only 200Meg's. Also, very funny, when I set the compress-attribute (under NTFS, WIndows NT 4.0), the 1.8 Gig shrinks to a size of only 328Meg, and, really funny, the Database becomes faster at all !

any hints, or explanations ?

Regards Markus Received on Mon Nov 30 1998 - 11:55:35 CST