Oracle 11gR2 New Feature – Deferred Segment Creation
In this DBSNAPS tutorial video we will present you a new feature of Oracle database 11gR2: Deferred segment creation.
Liron Amitzi Oracle ACE
Oded Raz Oracle ACE Director
Category archives for:
Administration
Parallel New Features in Oracle 11gR2
Oracle 11gR2 brings us new features related to parallelism.
The new features are controlled by the PARALLEL_DEGREE_POLICY initialization parameter. Learn how to use these new features to leverage your needs.
Oracle – Writing into the Alert.log file
The Alert.log file is a log that chronological records important information about error messages and exceptions during daily database operations, learn how to insert a manual records into this useful file.
Replicating virtual machines with Oracle databases
Virtual machines are used in many organizations due to the simplicity of administration, especially in development environments.
This post will describe how to configure the new replicated machine to work with the Oracle database.
August 23, 2010 | Posted in Administration, Main-Administration, Oracle, Oracle - Latest Articles, Tips & Tricks | Read More »
Creating Multiple AWR reports
Analyzing AWR (Automated Workload Repository) is a common operation while doing a performance and tuning sessions on a database instance.
June 22, 2010 | Posted in Administration, Oracle, Oracle - Latest Articles, Tips & Tricks | Read More »
Oracle Temporary Tablespace Free Space
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
Oracle Temporary Tablespace Usage
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?
Connect as an Oracle User Without Knowing the Password
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:
Oracle Active Standby Database tutorial
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…
February 7, 2010 | Posted in Administration, High Availability, Main-Availability, Oracle, Videos | Read More »
Creating an Oracle 11g Database tutorial
This video will show you how to create an Oracle 11g database