Liron Amitzi Oracle ACE
Oded Raz Oracle ACE Director
The temporary tablespace in Oracle is used to store data that is temporary and session specific (sort operations, hash joins, temporary tables data, etc.).
Users use the same temporary segments in the temporary tablespace to perform the sort operation, joins, etc. How can we tell which users use the temporary tablespace and how much space they use?
In some cases we have to connect to the database as a specific user, but don’t know the password.
There are two ways to handle this problem:
A physical standby database could always be opened in “read only” mode. The problem was that it didn’t apply any archived logs at that time. It could only apply logs when mounted.
Then came Oracle 11g…
Datafiles in Oracle can be resized to a smaller size only if there are no used blocks at the end of the file. If there is a used block at the end of the file we will not be able to reduce it size even if the rest of the file is empty
This video will show you how to create an Oracle 11g database
DBMS_MONITOR is a new package in ORACLE 10G. This package allows us, amongst others, to trace sessions in the database.
Always wanted to see all Oracle parameters? Including the hidden ones?
There are several specific operations that are considered as long operations.
When performing one of these operations, we can follow the progress of the operation
enjoy the benefits of single sign-on to all of your applications, whether you are connected to the corporate network, traveling away from the office, roaming between computers or working at a shared workstation.
