Temp space issue in OBIEE.

716024

OBIEE queries are taking high volume of temp space in oracle.(almost 60 GB)
could anyome suggest to avoid that.

rmoff

Which temp space - OBIEE, or Oracle DB?
If Oracle DB then I'd suggest speaking to your DBAs about the configuration of the DB.

If OBIEE then one thing to try is reducing the size of the datasets that your reports are bringing back. Also check Metalink as I think there's some stuff there about TMP files.

716024

Its the Temp space of Oracle DB.

rmoff

in which case you need to speak to your Oracle DBAs who should be able to help