V$SESSION_LONGOPS and parallel query
For pretty much as long as I can remember, the view V$SESSION_LONGOPS has existed. It has a suite of columns
Tag: parallel
Parallel DML and locking – going manual
Generally speaking, if you have a giant chunk of data over “here”, and you need to load it into a
How to control resource usage on Autonomous
When you connect to your Autonomous Database, you get to choose from some predefined services. The services available depends on
Autonomous Transaction Processing – your slice of the pie
I grabbed the following screen shot from a slide deck I’ve been giving about Autonomous Transaction Processing (ATP). It shows
Session level parallelism
If you’ve got a stack of large I/O operations to perform, you might want to take advantage of the all
Learning is not a spectator sport 