Liron Amitzi Oracle ACE
Oded Raz Oracle ACE Director
Learn how to protect oracle database using ORACLE’s revolutionary feature – Database Vault.
In this first chapter we will show you how to install ORACLE Database Vault, and PROTECT schema objects using DV REALMS.
Oracle 10g Supply a new alter table option that enables online table reorganization, this option is shrink
Programmers often retrieve big result set using queries and need to split them up in order to display the result correctly. This tip shows you how to split oracle query result sets into pages.
The temporary tablespace in Oracle is used to store data that is temporary and session specific (sort operations, hash joins, temporary tables data, etc.).
Once a session needs to perform a large sort operation
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.