Skip to Main Content

Can't see the Ask Question button?

Connor and Chris will be back taking questions again soon. Click Notify Me to be emailed when we're back taking new questions.

In the meantime, you can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Questions

QuestionUpdatedAsked

Tom, your site has been very usefull, and usually I can get an answer by looking at past responses. However, this time I need to ask you a question.An application analyst wants to track the total number of SQL executed per day in Prod database, and look at lon...
42 hours ago9.4 years ago

Hello, I researched your Q/A bank before asking this question. What are some of the things to keep in mind, where a benefit to using a sql profile turns into a curse. What are the things that can cause the use of sql profile to go bad or problems that can go u...
43 hours ago3 days ago

<code>CREATE OR REPLACE PACKAGE BODY INTLECM.PRODUCT_UTF_CHECK ASG_FILE UTL_FILE.FILE_TYPE; DEBUG_PROCESS_ID LOG_PARAMETERS.PROCESS_ID%TYPE; PROCEDURE NL ISBEGIN UTL_FILE.NEW_LINE(G_FILE);END NL;FUNCTION ITE (B BOOLEAN, T NVARCHAR2, F NVARCH...
2 days ago3 days ago

Hi Tom,On your website I didn't find anything about this topic that could help me, so I decided to write.We detect a situation in the execution of a procedure that is not expected to happen. The output parameters are returned with values, when it was not suppo...
2 days ago3 days ago

Typically companies that can afford the high cost of a multiple node RAC license, they can afford to have an enterprise SAN solution. The SAN solution like a Netapps is an appliance with it's own software and CPUs to process data quickly. They also usually h...
2 days ago3 days ago

Hi I have a rman full backup and I want to restore single table due to drop that table how can I do this.I can not create a clone due to space and resources issue..Thanks...
2 days ago3.6 years ago

Hi,We executed several SQL queries via SQL Developer and SQL*Plus on Windows 10 but got the following error.<b>Error: </b><code>ORA-27102: out of memoryIBM AIX RISC System/6000 Error: 12: Not enough spaceAdditional information: 7195Additional information: 1677...
2 days ago8 days ago

I have several scripts that are hard wired when creating a database link and all works well. The time has come though to take them to the next level and expand the user community. To do that the CREATE DATABASE LINK statement needs to be dynamically determin...
2 days ago2.9 years ago

GM,Do you guys know of a whitepaper or training that describes an approach to estimating how many Oracle DBA hours are needed to perform X, Y, Z? We are bidding on an effort, and I would prefer not to have to reinvent the wheel if something already exists. F...
2 days ago3 days ago

Hi Team,We have SSL certificates imported on database server using ORAPKI after creating wallet.We are using utl_http for external system communication from database and using utl_http.set_wallet to access the certificates.Now, we are en-queuing the messages t...
2 days ago9 days ago

Hi,We just went live on Oracle a couple of weeks ago. I have a legacy process that includes running a script that was coded for Sybase. I have most of it converted to Oracle, but I'm having trouble with the Age field (it's the last piece I need to get workin...
2 days ago3 days ago

I have a SQL statement can run by itself and get the result back over db link. But if I want to put result set into a table either using “create table….as..” or “insert into …” before the same select statement, I will get ORA-22992 error. What caused this?The ...
3 days ago3 days ago

I have recursive query on Oracle 11g table with undirected graph data. Each row represents one edge. The recursive query traverses all edges starting from given input edge. The idea of query is: - input edge is at the 0th level- for n>0, edge is on n-th level ...
3 days ago3 days ago

Hi Tom , I have your book and am still not able to understand the mechanism of hash join . it just says similar to this ( I do not have book at work so can not exactly reproduce it )one table would be hashed into memory and then the other table would be used t...
3 days ago14.3 years ago

Hi,I have a table with partitions. I am trying to select the data and partition name in the same query. I have created a part_test table and inserted data. It is on the Live SQL link.Looking to query something like this,SELECT ld_dt, ld_src, <partition name> F...
4 days ago3 weeks ago

Hello,We have an application that monitors applications, detects anomalies, does correlation between metrics, performs Root Cause Analysis based on a few machine learning algorithms.We are planning onboard oracle monitoring for this application with a few metr...
4 days ago10 days ago

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

Hello, This is more of a fundamental question, sorry i dont have any test cases. Does table fragmentation also imply index fragmentation for the same table. ? ...
4 days ago8 days ago

When I deploy Oracle Database on Amazon EC2, I can backup to Object Store with RMAN, using "Oracle Secure Backup Cloud Module for Amazon S3".This is great.When I deploy Oracle Database on Azure, I would like to use Azure Blob Storage with RMAN. Is there a simi...
4 days ago3 months ago

my local db is a 19ci downloaded the latest version of the mobile server and while going through the installation, i came to this error, i have check my sqlnet.ora file, the tns configuration is good because i am able to connect with toad and sql developer.thi...
4 days ago9 days ago