I'm not a DBA, I only play one occassionally. I know when to stop. We're using TOAD 12.
This is one of those situations.
We're running Oracle 11 on Windows Server 2008 R2.
We have a tablespace called Warehouse1that has about 39G Used, 24G free initial extent = 64, nextExt = 0, Min Extents = 1and max is a very large number (2B).
It has a WTEMPDF Tempfile that has 64G Total.
When I run my awesome query, it fills up the 64G and then produces a ORA-1652 error. It sounds like its maxing the Temp space and not expanding it.
If my thinking is correct, I need to somehow expand my tempfile or create another one.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…