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 ago | 9.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 ago | 3 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 ago | 3 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 ago | 3 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 ago | 3 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 ago | 3.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 ago | 8 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 ago | 2.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 ago | 3 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 ago | 9 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 ago | 3 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 ago | 3 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 ago | 3 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 ago | 14.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 ago | 3 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 ago | 10 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 ago | 4.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 ago | 8 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 ago | 3 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 ago | 9 days ago |