DBA Blogs

Log File Switches Twice as Often as ARCHIVE_LAG_TARGET

Tom Kyte - Sat, 2017-02-18 06:26
I have an odd issue occurring on my primary pre-production database server. In both my production and pre-production environments, we have the ARCHIVE_LAG_TARGET parameter set to force a log switch at regular intervals. I know this is not a modern-...
Categories: DBA Blogs

UTL_MAIL.SEND issue with Senders email domain

Tom Kyte - Sat, 2017-02-18 06:26
I am not getting any error in the application when I use sender's email domain as @yahoo.com and email is not delivered to recipient. recipient will get email If I use sender's domain as @gmail.com or @abc.com or any other valid domains. So how to tr...
Categories: DBA Blogs

after update count of executed updates

Tom Kyte - Sat, 2017-02-18 06:26
I have a script executed in SQL*PLUS command line that should give out the summ of all real updated rows from the WHERE clause after all update executes simiilar as on execute update command directely in SQL*Plus with "1 row updated". But the fol...
Categories: DBA Blogs

View peformance

Tom Kyte - Sat, 2017-02-18 06:26
I have composite partitioned FACT table that list-range partitioned and it currently houses 1756515660 rows. In order to incorporate dynamic partitioning/sub-partitioning, we want to switch to list-list style of table. Given the large size of the t...
Categories: DBA Blogs

Regexp_Substr negative position

Tom Kyte - Fri, 2017-02-17 12:06
Hi, I would like to use regexp_substr to treat comma as delimiter and search the string backwards. For example: String: a, b, c, d e, f, g, h, j c, c, c I should expect the output from the following query d j c Sele...
Categories: DBA Blogs

Match Recognize Examples (SQL Pattern Matching)

Tom Kyte - Fri, 2017-02-17 12:06
Hi Ask Tom Team, Recently I came across MATCH_RECOGNIZE clause. I checked the Oracle documentation but it's not easy to digest. Looking at OLL webinars, youtube videos and some of Ketih's article on oracle blog helped me understanding a little of i...
Categories: DBA Blogs

Performance on using oracle Table of an object type

Tom Kyte - Fri, 2017-02-17 12:06
Hi I am working on a reporting tool that extracts data from Oracle Stored Procedures base and generates reports using Jasper. Please find below a sample of the procedure written. --Creating Object CREATE OR REPLACE TYPE my_row_type AS OBJECT ...
Categories: DBA Blogs

Apex idle user goes to login

Tom Kyte - Fri, 2017-02-17 12:06
Hello When my users log in and idle like 15 minutes then some users are loged out. How can i prevent that? That user will be never logged out only when they do it. it is very important. I hope you can help me with that. Kristjan
Categories: DBA Blogs

char (10) data type hosting numeric data for natural keys

Tom Kyte - Fri, 2017-02-17 12:06
Hi, Can you please provide some guidance on the possible performance issue one might have in creating a char(10) data type that hosts natural keys? Also, I'm baffled by the following results.. THIS WORKS FINE even char(10) blank pads the ...
Categories: DBA Blogs

Skip scripts based on a variable value during run

Tom Kyte - Fri, 2017-02-17 12:06
Hi, We run the same script package to each environment (production, acceptance test, etc.). We have some of these scripts which shouldn't run e.g. into PRO db. Is there any way to define which script can run in which environment if environment type ...
Categories: DBA Blogs

Bind variables in a View?

Tom Kyte - Fri, 2017-02-17 12:06
It is possible to use bind variables in a view? It is possible to replace the values ??10, 11, 12 and VISOR by BindVariables or how can I optimize this view? CREATE OR REPLACE VIEW VIEW1 AS SELECT a.column1, a.column2 FROM TABLA1 a WHERE a...
Categories: DBA Blogs

Tuning

Tom Kyte - Fri, 2017-02-17 12:06
Hi there! I want to know if it possible to get information about queries in database (like v$active_session_history contains) without diagnostic and tuning packs? This datadictionary view v$active_session_history consists of x$kewash and x$ash fi...
Categories: DBA Blogs

How RowProcessed works and updated in GV$SQL

Tom Kyte - Fri, 2017-02-17 12:06
How row_processed,disk read and buffer gets actually works while executing any query. I came across two scenarios while executing two different queries.(My sql arrayfetch size is 50) 1. Disk read and buffergets increased till the entire executio...
Categories: DBA Blogs

getting string

Tom Kyte - Fri, 2017-02-17 12:06
i have a table A and in that column B. column b has below data. sdkjksdfFDOR:1234; wwerwerrFDOR:12344; how to read the data after FDOR: and upto ';' my output should be 1234 12344 Please help me. Regards. T.prasad
Categories: DBA Blogs

Links for 2017-02-16 [del.icio.us]

Categories: DBA Blogs

Return blob from remote database

Tom Kyte - Thu, 2017-02-16 17:46
Hi, I have a question on how to get Blob from remote database with out using Temporary table and MVIEW. Can you please provide a way to deal with blob.
Categories: DBA Blogs

Data copy from Staging to Application table

Tom Kyte - Thu, 2017-02-16 17:46
Hi Team, Can you pleas eheve alook ate below scenario and suggest any better alternative to achive it I have Staging table - Tb_Staging_0001 Columns - Card_No, Address_1, .. Address_5, Credit_amount, Debit_amount, .... so on.. And Applicati...
Categories: DBA Blogs

How to apply for a job with Oracle

Tom Kyte - Thu, 2017-02-16 17:46
I need a job in oracle. How would I apply?
Categories: DBA Blogs

Commit more aften

Tom Kyte - Thu, 2017-02-16 17:46
Hi ask tom team. what is the effect on Oracle Database if i commit a lot in a loop like following. <code> begin for i in 1..10000000 loop commit; end loop; end; </code>
Categories: DBA Blogs

"Next" Clause when creating a tablespace

Tom Kyte - Thu, 2017-02-16 17:46
Hello, I was recently wondering exactly what the limits of the "next" clause are in a create table space statement. If I create a tablespace with the "Next" clause value of 50mb and maxsize unlimited (with autoextend on), does that mean that the m...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs