No more spool space error when call getColumns

Database
N/A

No more spool space error when call getColumns

Let's say I have 20 tables in one schema.   I aways able to run all kinds of queires successfully against these tables.   But a simple getColumns call will got error:  "No more spool space in xx" .

getColumns(null, mySchema, myTable, null)

Even for a table contains only 2 columns and couple of rows.

To solve the issue, I have to double the spool space allocated for this user.

Why getColumns call required more spool space and is there guidance for allocating reasonable spool space for a user?