The goal of this tutorial is to show the power of using the Virtual Private Database capability to restrict access to certain data to certain users.
Tag: Oracle
Advanced Queuing Working Example – (PL/SQL)
(Jeff Hunter) This article provides a brief overview on configuring and using Oracle’s Advanced Queuing features using PL/SQL. This will demonstrate the basic functionality of Oracle Advanced Queuing (AQ). AQ was first introduced in Oracle8 and has been extended and improved on into future versions.
Addition Not Applicable
(Tim Dexter) Apologies for the tenuous title, I went looking for a synonym for today’s subject and came up with this, anyway, moving on …
Installing Oracle E-Business Suite Release 12 with shared APPL_TOP on CFS
(Arnoud Roth) As soon as EBS Release 12 became available, I started with the installation, eager to find out what the differences were compared to 11i.
ASM Enhancements
(Sreeram Surapaneni) ASM enhances the performance that raw disks provide, without the pain or difficulty of administrating the raw disks. Moreover, ASM provides storage mirroring policies that can be configured on a file level rather than at the volume level that traditional volume managers provide.
Dedicated vs. shared server configuration
(Brian Peasland) What is the difference between dedicated and shared server configuration? Please tell me how to configure shared server configuration. In which situations should we use these configurations? (R)
Configuring J2EE Application XML Files
(Sam Alapati) In this fourth part of a series covering the management of OC4J and configuring J2EE applications with Oracle 10g Application Server, we take a closer look at at J2EE application deployment files and more.
New Strategies Simplify Backups
(Ari Kaplan) Backing up data used to be simple. At night, when system use was low, you physically copied everything to tape. If you needed more space, you bought more. Backups might take several hours, but that didn’t bother most people. If you ever had to restore the data, you just copied everythin
Restrict User Access to Specific IP
(Muthukumar Singaram) This trigger restricts user access to specified IP addresses.
Oracle RAC Administration – Part 16: Balancing act between Server and Client
(Tarry Singh) We will take a little detour from our regular path of following the manual, some would say, to more practical path. One topic that most intrigues both an Oracle DBA and their clients (in their own way) is connectivity. DBAs are sometimes puzzled with the load balancing and failover par
