(Sam Alapati) In addition to the many OHS configuration directives you have learned about so far, Oracle HTTP Server provides two special directives, Options and AllowOverride, which you can use to allow or disable several features of the Oracle HTTP Server.

(Bob Watkins) Oracle’s Virtual Private Database (VPD) feature (also called Fine Grained Access Control) provides row-level security checking for DML statements such as SELECT. A PL/SQL policy function is associated with a table; the function can examine the current user context and return additional

(Lucas Jellema) After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously known as XML Publisher). My colleague Marcos is our (AMIS’s) real expert in this area – you may ha

(Sreeram Surapaneni) As a Production or Development DBA, we’d better know all the syntax of the command line interface (CLI) utilities whether it is sqlplus or old srvrmgr, which Oracle no longer supports. Moreover, command line interfaces are easy and certain. Oracle has command line interface tool

(Jeroen van Wilgenburg) The Spring DataBinder is not only useful to bind request parameters, you can also use the DataBinder on other parameters, like command line arguments, JSON objects coming from an Ajax request and query results from a database.

(Subhra P. Dey) In one of our systems, we have several extract, transform and load (ETL) processes written in Ab Initio that regularly unload the latest changes from very large tables. Many of these processes unload few hundred thousand records in every run. Ab Initio has provided a component (Input

(Alex Gorbachev) This is a follow up on my previous post about SYSDBA keeping invoker rights when calling PL/SQL procedure. There was no direct privilege escalation but I mentioned that you need to craft your code so that it gets called by a SYSDBA user. This is what we are going to do now and here

(Andre Crone) I have been investigating Oracle’s Web Service Manager recently. WSM is shipped with the new SOA Suite. The WSM is a service gateway. Existing services can be placed behind the gateway. Security and authentication of the services will be done by the service gateway. WSM also provides a

(Mark Brunelli) Oracle announced the general availability of Oracle Data Integrator (ODI), the first major upgrade of Sunopsis Inc. software since Oracle purchased the Limonest, France-based data integration vendor last year. (R)

(James F. Koopmann) Definition – The amount of time users and applications must wait for a log switch to complete.