Skip to Main Content

Questions

QuestionUpdatedAsked

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

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...
6 hours ago15 years ago

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...
6 hours ago6 years ago

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 ...
6 hours ago5.3 years ago

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 =...
6 hours ago5.4 years ago

How many autonomous db we could have for ExaCC full Rac?...
7 hours ago7 hours ago

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...
34 hours ago5 days ago

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....
42 hours ago5 days ago

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...
43 hours ago4 days ago

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...
43 hours ago5 days ago

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...
43 hours ago2 years ago

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...
43 hours ago20.4 years ago

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...
43 hours ago20.9 years ago

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...
43 hours ago5.3 years ago

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------------------------------ -...
43 hours ago5.7 years ago

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...
44 hours ago5 days ago

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...
44 hours ago2 weeks ago

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....
4 days ago4 days ago

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...
4 days ago5 days ago

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...
4 days ago3 months ago