Questions

The maximum number of cores before needing RAC licensing is per Cluster or for the sum of the Clusters?...

I have confusion about explain plan, autotrace and tkprof. When explain plain showing to us the prediction about how optimizer will work to produce result and tkprof show the real thing that happen, so how about autotrace. In autotrace there are two part, as f...

Hi Tom, I went through the articles & documentation, your article answers most of the issues Asktom EBR Part 1 => http://www.oracle.com/technetwork/issue-archive/2010/10-jan/o10asktom-172777.htmlAsktom EBR Part 2 => http://www.oracle.com/technetwork/issue-arch...

Hello Tom,I have one column INTERVAL_TIME with datatype as TIMESTAMP(0) and stores data in 15 mins interval time.Since there was DST on 13 March 2016 , the interval was store at 1:45 AM and next interval at 3:00 AM.But when i am applying to_char on the column ...

Hi Tom,Good day.Which of this queries is better in performance specially when joining with multiple tables and huge data ?example.1.option 1SELECT h.name, h.je_source, l.entered_dr, l.accounted_drFROM gl_je_headers hINNER JOIN gl_je_lines l ON h.je_header_id =...

How many autonomous db we could have for ExaCC full Rac?...

Hi Tom – My task: move several dozen text file imports from SQLLDR (on AIX) into callable PL/SQL procedures. The text files are static in structure with daily refreshes of the contents. The contents are loaded into individual tables in our 19c EE database.Th...

Is there a way to create a index for a xpath that is including a xpath function?Please consider that xmltype index creation fails at oracle livesql....

Hi,We have Oracle 12C on 2 instances. I know GV$license can give maximum number of concurrent sessions since start of instances. But is there a way to get maximum we had accessing the database from both together ?Syed...

Hi,<i>Background and Requirement</i> - I am working for a firm that uses <b>Oracle SQL Developer</b> for Data Cleaning and Manipulation of the data residing in the Oracle Database. We use <b>Microsoft Azure</b> for complete lifecycle management and work planni...

Hi Tom,I have a query ,I want to pass multiple values to pbd_prod_code is this possible ,as I am getting null v after passing 1001,1002 values to the parameterSELECT field_key, field_lable,FROM json_table( (SELECT PBD_BLOCK_INFO FROM PIIM_PROD_BLOCK_DE...

We have a single schema with few 100 objects some of them having millions of rows. The schema have data for various clients. Each client is identified by thier clientid and is a column in almost all the tables. Ex: (will have data of all the clients in the sam...

Hi Tom,Here are the few questions on Locking. 1)How do I use v$lock to figure out lock details ? Details likewhos has locked,on which table,who else is waiting, and what typeof locking (shared or exlusive ?), since when it is locked.2)Why and when exclusive/sh...

Hi,I have a column of type <code>TIMESTAMP</code> t in which I safe timestamps with 6 digit precision e.g. 03-FEB-17 04.45.01.909000 PMDue to the way they have ben added to the table they are missing two things:1. The time zone information2. the correct centur...

Some Days before I have Install Oracle Database New version 12.1.0.2 with no error or warnings.Created 2 pluggable databases in the DB container. <code>SELECT name, open_mode from v$pdbs; NAME OPEN_MODE------------------------------ -...

Hi Tom and Team,I guess that this issue is related to the namespace, but as I don´t know well this, Could you help meto solve the error running this Select, please?<code>with testTable as ( select xmltype ('<soap:Envelope xmlns:soap="http://schemas.xmlso...

Greetings oracle DB gurus,On this subject I want a recommendation, the database weighs 7 teras in total but 5 of that 7 teras is only the audit table, that table only has 3 years of data (The business needs to keep all the data) and it has more than 900 millio...

Is FORCE_LOGGING enabled at CDB level in ADB-S?I checked that FORCE_LOGGING was not enabled at the PDB level and the Tablespace level....

The latest Oracle docs has the following design tip:9.13.5.2 Circular Dependencies Among TypesAvoid creating circular dependencies among types. In other words, do not create situations in which a method of type T returns a type T1, which has a method that retu...

Hello Tom,After Migration to Oracle 19c from 11.2.0.4, we found at least one query which completely changes the explain plan and is very slow.<b>Details and Pre-Requisite: </b>All DB Stats are built.All Indexes are up to date.Open a new DB session.optimizer_mo...