DBA Blogs

What happens when a user cancels a query

Tom Kyte - Tue, 2017-08-01 10:06
Hi Team, I have some doubts can you pls help me clear it out - Backend db is oracle 11g Frontend is Java Q.1 When a user triggers a download report query, and he closes the window immediately does the query get aborted in the backend or i...
Categories: DBA Blogs

Partition Table : unable to create INITIAL extent for segment (ORA-01658)

Tom Kyte - Tue, 2017-08-01 10:06
Hi Team, When i create a Range Partition table and try to insert row into that, I am getting below error: SQL Error: ORA-01658: unable to create INITIAL extent for segment in tablespace 01658. 00000 - "unable to create INITIAL extent for segme...
Categories: DBA Blogs

cpu count question

Tom Kyte - Tue, 2017-08-01 10:06
I was reading </code> http://www.dba-oracle.com/oracle_tips_cpu_count_wrong.htm <code>and was wondering if this is really a bug? Is it really dangerous?
Categories: DBA Blogs

Checkpoint&logswitch -- what is their relationship.

Tom Kyte - Tue, 2017-08-01 10:06
Please Tom can you help me to understand what happens at the log switch time and what happens at checkpoint time and how one event can determine the other one. Also i am very confuse where SCN is written: in datafile header, in rolback segment ...
Categories: DBA Blogs

Error ora-01640 making tablespace read only without active transaction

Tom Kyte - Mon, 2017-07-31 15:46
Hi Tom, We are trying put a tablespace into readonly mode and getting error ora-01640. There is no transaction as the database was stopped and started in normal mode.. Only one session was established from which table space readonly was executed....
Categories: DBA Blogs

How to create FIFO report based on evaluation system

Tom Kyte - Mon, 2017-07-31 15:46
I want to implement FIFO Stock model in my inventory. So I face some problems but before staring query i describe my physical structure of the table. <code>create table purchase_mas ( stock_id number pur_date date, product_code number...
Categories: DBA Blogs

PLS-00302 using XMLTABLE

Tom Kyte - Mon, 2017-07-31 15:46
I'm getting PLS-00302 when trying to select from a chunk of XML using XMLTYPE and XMLTABLLE. This works, and I get the desired output... <code> SELECT xt.* FROM (SELECT xmltype ( '<TABLE> <TR><TD>Organization</TD><TD>Organization Title</TD>...
Categories: DBA Blogs

How to do a EXP full excluding some schemas?

Tom Kyte - Mon, 2017-07-31 15:46
Hello Oracle Masters, Thanks a lot for taking time to answer questions. I know that it is possible to do an export full datapump and use the exclude clause. Since I have space limitations, I'm using original export with exp_pipe. It's possi...
Categories: DBA Blogs

loading jar files into Oracle

Tom Kyte - Mon, 2017-07-31 15:46
Could you please provide an example that 1) Loads a jar file into oracle [any permissions and path variables that needs to be set-up using DBAs help] 2) Load a class that uses the above jar file 3) Create a PL/SQL procedure or function that uses ...
Categories: DBA Blogs

How to Compile Code on all Connections

Tom Kyte - Mon, 2017-07-31 15:46
Hi, Scenario: We are using 6 different schemas and we are compiling codes on all of them. So first, I connect to those schemas, then when I need to compile my codes, what i do is: Select Schema, Compile, Repeat. I was wondering if there's a tec...
Categories: DBA Blogs

Oracle DB audit

Tom Kyte - Mon, 2017-07-31 15:46
We have set Oracle DB audit to DB, Extended. From the 2 hour span AWR report, there are 824,993 physical reads to AUD$ table. Is this physical read, Oracle internal process? or external query to the AUD$ table? Will it affect the database perform...
Categories: DBA Blogs

Performance of the PL/SQL function

Tom Kyte - Mon, 2017-07-31 15:46
Hi Team , I need some help here for performance improvement I have an XML as below ,this XML would be input to my PL/SQL function <?xml version="1.0" encoding="UTF-8"?> <n1:Request xmlns:n1="urn:global:cs:common"> <n1:Conditions> ...
Categories: DBA Blogs

String extraction

Tom Kyte - Sun, 2017-07-30 21:26
Hi I have a query regarding strings. If I give a string like 'Mrs xxxxxx yyyyy', I should get the output like Title FirstName LastName Mrs xxxxxx yyyyy How can I do this using string functions. Many...
Categories: DBA Blogs

How is undo data retrieved for the purpose of a Flashback Query?

Tom Kyte - Sun, 2017-07-30 21:26
Hello Tom, Looking at a flashback version query, it is obvious that all changes to a row are kept in the undo, not just the latest one. My understanding is that the address of the undo corresponding to a specific row is stored in the header of...
Categories: DBA Blogs

Frequency of archive log switches

Tom Kyte - Sun, 2017-07-30 21:26
Hi, I've been a DBA for a very long time (since 7.3.4) and in the old days I remember 'rules-of-thumb' that stated that you should never switch logs more than 'x' times an hour. This was of course due to the fact that checkpoints take up a lot of ...
Categories: DBA Blogs

INSERT SELECT with APPEND NOLOGGING PARALLEL(t,8) - Whether this can able to process upto 15 crores records ?

Tom Kyte - Sun, 2017-07-30 21:26
As part of data migration project , i need to transfer data from staging table to target table (with out filter criteria) for about 41 tables. Its a simple insert select and below query i am using for 41 tables. INSERT /*+ APPEND NOLOGGING */...
Categories: DBA Blogs

Best practice for ETL update

Tom Kyte - Sun, 2017-07-30 21:26
We have an ETL process on a table with 38 updatable columns. The source data is a CSV file with a single column unique record identifier and we set this file up as an external table. The target table has a corresponding primary key column. The sou...
Categories: DBA Blogs

Dynamic file names with sql Loader

Tom Kyte - Sun, 2017-07-30 21:26
Hi Can I load a file using sqlloader within a batch file where the file name changes dynamically. Eg: The file name is FUNC_DDMMYY.csv Can I load this file by passing it to SQLLoader as FUNC_*.csv? Would wild cards work in this case. How...
Categories: DBA Blogs

Presented at CLOUG OTN Day 2017, Chile stop of the 2017 LAD OTN Tour

Pakistan's First Oracle Blog - Sun, 2017-07-30 20:37
Amidst lots of Empanadas and Lomo Saltodos, I presented at CLOUG OTN Day 2017, Chile stop of the 2017 LAD OTN Tour last week and it was great to see a very passionate audience.




Despite of long flight and opposite time zone difference, Santiago, Chille came out very welcoming and lively. The event was very well organized and was studded with international speakers including fellow Pythianite Bjoern Rost, and various other well known speakers like Markus Michalewicz, Ricardo Gonzalez, Craig Shallahamer and so on.





Categories: DBA Blogs

Partner Webcast – Inter Process Communication with Correlations in Oracle Process Cloud Service

Oracle Process Cloud Service (PCS) started a while ago as a lightweight process automation cloud tool that very quickly picked up momentum. It has been making a huge progress in all aspects and...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs