-- Create table create table test1 as ( select 2001 as keyvalue, 1 as counter, '+++ Input: My Name is ABC' as text from dual union all select 2001 as keyvalue, 2 as counter, '+++ Input: Cricket is my favourite sport' as text from dual union all select 2001 as keyvalue, 3 as co

Hi Tom, While checking ASH, I found some SELECT queries blocked other transactions with LATCH FREE with latch# = 39, which is "object stats modification". Can you explain what that particular latch is for and in which area it stays ? Thanks, Vu

Hello, This is math/algebra question, but I was interested to see if there was a sql based solution as I am pleasantly surprised by the depth and breath of solutions on this site. At our company, we print labels, brochures etc. For each print job, the item's length and width are ...

Hi, I am planning to partition some of the very large tables in our data warehouse (some exceeding 600GB size). And considering their size, I thought of not duplicating the entire table data into another partitioned table. But that old approach makes rollback very simple, just re...

We have a DB where users are able to search for text, using Oracle Text (I guess it's Intermedia in 8.1.7). Anyway, there are 3 columns that are indexed. Each of them is in a separate table. The user has a single field to type in their search criteria. It's great that the entire ...