Questions

Hi all,It's first time post.We are facing a problem in 19c when generating a csv file.In 12c, results were as expected.Spaces are added after or before the content of the column.Please find attached the information about the environment.-- tables structureColu...

Hi Tom and Team,I have a SELECT query that runs fine if submitted the 1st time (takes about 3 seconds), but if I submit it right after again, it could take anywhere from 22 to 37 seconds (on a pretty consistent basis). If I wait a few hours (or if I issue the...

Hi TomWant to understand how and where memory is allocated in an instance to evaluate decode, regexp functions in oracle? If we are reading data from a table and writing it any other location(not oracle), then what would be better-->while firing the query wit...

I have a table with 100 million rows. Table size is around 25 GB in the DB.I need to unload this data to a csv file.What is the best fastest way to do this.I was reading about external tables to do this by using CTAS but I dont think there is an option to dire...

Hi Tom, Some questions about the SQL tuning. 1) I found that when using "IN" in the where clause , INLIST ITERATOR is shown on the explain plan in a cost-based database (and using the index correctly, the response is fast). However, no such INLIST ITERATOR ...

Hello, Ask Tom Team.I want to do pagination in a report connected to an Oracle 18c database. I have read there are some methods to do the pagination like: offset and seek. I have several questions1. What method is the best? I have heard that OFFSET methods can...

Hi Tom,We have a query which has to get a set of rows over the db link which has a CONTAINS predicate on a column of CLOB.E.g.There is a DB A and DB B with table T1( c1 varchar2(10),c2 clob) .I want to run a query from DB A using dblink on DB B to query T1 whi...

I have a sqlldr control file that looks like this name char(255) enclosed by '"',contactemail char(255) enclosed by '"',rawtext1 filler enclosed by '"',rawtext2 filler enclosed by '"',auditdate char(255) enclosed by ...

Hi,I am trying to load a data file into a database table using SQL loader. I received the data in an Excel spreadsheet but I saved it as a comma delimited file.When I run the SQL Loader command no records are loaded - looking at the log file I get the followin...

I read the article, titled:<b>Event Monitor Process: Architecture and Known Issues (Doc ID 105067.1)</b>…Notification implements a high-watermark scheme where when the backlog of notification events hit an in-memory limit the messages are, in the case of 9.2, ...

Hi,I'm trying to consume Oracle fusion rest web service's in PLSQL using apex_web_service. I'm getting the below error. could you please guide me on this.also Pls suggest how to enable the basic authentication in web service like how to set the basic auth.ORA-...

Hello!Thanks for answering my questions regarding the testing of Oracle SE2's CPU thread limit on Oracle 11g Standard Edition - I really appreciate the informative response.I have a related question...If we have a server with, say, 18 CPUs hosting 4 SE2 single...

Dear Tom,about two weeks ago we moved a test database from 12.2.0.1 SE2 to 18c XE via data pump. We used schema import into a pdb with compression enabled (from the parameter file: TRANSFORM=TABLE_COMPRESSION_CLAUSE:"ROW STORE COMPRESS ADVANCED"). There is no ...

Hi Tom,Just want to ask is there any difference between doing objects(tables,indexes and etc) reorganization within same tablespace and to new tablepsace? Normally i used to do reorganization to another tablespace but this method will need extra space to move ...

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...

Hello,I am attempting to delete a record / object (that may use several tables at the DB level) from an application.The delete statement is raising aORA-02292: integrity constraint <constraint name> violatedHow can I find the Delete statement (DML) being execu...

Is there a way to update all listeners to a new OHome after upgrade? Going in manually to each listener (say 10) to update the new OHome seems like there should be an easier way but I'm unable to locate anything on it....

a sql code to remove all the special characters from a particular column of a table .for example :iNPUT-ABC -D.E.FOUTPUT ABC DEFAND IF THERE IS TWO NAMES LIKE ABC PRIVATE LTDONE SPACE SHOULD BE MAINTAINED BETWEEN 2 WORDS....

Experienced this across 3 different instances now. On 19.11.0.0.When IMCS is enabled on a partition which is composite-partitioned. Partition is on a DATE column and SUB-PARTS are on a VARCHAR2 column.IMCS enabled on the latest partition changes the query plan...

Tom,I am trying to POST the webservice all using UTL_HTTP function with the file from pl/sql procedures. The same processed working from Curl scripts.PL/SQL :<code>DECLARE req utl_http.req; resp utl_http.resp; l_value VARCHAR2(1024); l_url_import VARCHAR...