(Vivek Sharma) What is optimizer_index_cost _adj and why do you need to set this parameter ?

(Pawe³ Barut) In oracle there is no build-in group function that will concatenate strings, just like max summarizes all numbers. But there is quite easy way to do that in pure SQL. Assume we want to have get as an query result list of tables and column. But we want all columns to be concatenated and

(Antony Reynolds) Last week I had a question from a consultant about how to efficiently process a large number of records in a file within BPEL. He needed to take a large file and insert all the records in it into a database. Lets look at the challenges and gotchas along the way.

(Brian Peasland) I am working on Oracle 9i. One of my tables contains around 10 million records. I want to find out the size occupied (in MB) by the first 8.5 million rows. I cannot possibly use the VSIZE function because my table contains 136 columns (which means writing 136 queries). (R)

(Sjoerd Michels) This post is about a feature in Oracle’s SOA Suite / JDeveloper 10.1.3.x that may easily go unnoticed: the option to publish a BPEL process as a template by using the Mark as Template option in JDeveloper.

(Michael McLaughlin) Managing secure access to Web pages and applications is a common problem. You want to enable those you trust to access data while preventing unauthorized ones from gaining access to it. In most cases, database-based authentication is the solution.

(James F. Koopmann) In Part I we learned how to set the CLIENT_IDENTIFIER session variable to more accurately pinpoint resource consumption for an individual user or group of users. We did this through queries to real-time activity views such as V$SESSION and V$ACTIVE_SESSION_HISTORY.

(Gerwin Hendriksen) During my work a lot of times I have heard the same rumour. Lots of people are stating that when a system is doing index scans the system is doing well. But is this actual true, that is the question. In my work I experienced a lot of times that I was called to look at a system […]

(Syed Jaffar Hussain) It was like a long cherished dream become true when we successfully moved one of our highly OLTP database from the single node to 2 node RAC on AIX platform.

This document contains a guide to migrate the commonly used Microsoft Access sample application, Northwind Traders, to Oracle Application Express. This is a multi-step process that utilizes several products to migrate first the database to Oracle and then the application. It is important that these