Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Merging all rows specific to a keyvalue

    -- 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
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    SELECT queries and even LATCH FREE 39 object stats modification

    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
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Convert a decimal to it's fraction representation

    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 ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Failed operation while altering the non partitined table to a partitioned table.

    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...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Using "Oracle Text" CONTAINS syntax on multiple columns

    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 ...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more