We requested oracle apex work space area 100MB?It exceeds the over 90% size? How to calculate Current file Utilization and current database size?Requested Size: 100(in MB)Current File Utilization: 6.49(in MB) What is this?Current Database Size: 91.... | 4 minutes ago | 7.9 years ago |
I have done a little searching, and not found anything that speaks to this, thought I would ask the experts:Recently I had to build an SQL script to be run in SQLPlus, and this script invoked another with the @ usage, and passed in a derived value as an argume... | 5 minutes ago | 7.1 years ago |
We are going to MOVE the TBS of AUD$ table in PROD. Purpose:AUD$ table is totally fragmented and the CLEANUP / PURGE runs very slow - even with max 1.000.000 batch size but as per test in our test environment we had some issues regarding using API (DBMS_AUDIT_... | 5 minutes ago | 6 weeks ago |
According Metalink note 785347.1 it seems possible to have a dataguard with primary 11.2 and standby 12.2 or even later but it is really very condensed.Could you please just confirm that 11.2 -> 12.2 is really possible?If so, what about 11.2 -> 19.x ?Or 12.2 -... | 7 minutes ago | 3 weeks ago |
It took me 25 years to get used to Oracle using 1-based indexing in pretty much all API's.How the rather new json_array_t data structure used a 0-based indexing and drives me crazy.Is there any reason behind this "strange anomaly" or did someone just want to d... | 5 days ago | 6 days ago |
I have a table like below.<code>create table t2 ( id varchar2(1),val number) ;insert into t2 values ('a',1);insert into t2 values ('a',2);insert into t2 values ('a',3);insert into t2 values ('a',4);insert into t2 values ('b',1);insert into t2 values ('b',2);in... | 6 days ago | 4.9 years ago |
Got information from your archives, BUT solution is not provided or there's no solution???Archive : "Why the trigger disappears... May 28, 2003 Reviewer: Kamal Kishore from New Jersey, USA "Hi Tom,After you re-create the view definition using CREATE OR REPL... | 6 days ago | 20.3 years ago |
Hi Tom,We run a multi-user OLTP system on Exadata Quarter Rack (Linux version). Though the system response time is consistent and is performing well. We observed Run queues with CPU utilization at 70% on both the nodes. What could be the reason?My understandin... | 6 days ago | 12.2 years ago |
Hi Tom , I need to write a query which will give me a list of dates between two date ranges (start date and end date) . For Example if my start date is 12/01/2003 and end Date is 12/31/2003. i need to generate my output as Date----12/01/200312/02/200312/03/200... | 6 days ago | 20.4 years ago |
I am looking for read consistency across multiple cursors in a packaged procedure. In the past I have opened the cursors that I wanted to be consistent at the start of the procedure, used them, and closed them at the end. I am starting to think that the time... | 6 days ago | 21.3 years ago |
Here is my challenge. I am developing an application that receives webhook notifications when events occur. I have successfully used the restful services functionality in Apex (SQL Workshop>Restful Services) to retrieve data at the first (root?) level succes... | 6 days ago | 2 months ago |
How to call rest api which accept x-www-form-urlencoded in PL/SQL procedure in Apex I am calling https://api.textlocal.in/docs/sendsms... | 2 weeks ago | 3 weeks ago |
When i try to run this code:DECLARE STUDENT_ID NUMBER;BEGIN -- Generate the next value for the sequence SELECT LMS_STUDENT_DETAILS_SEQ.nextval; -- Insert data into LMS_STUDENT_DETAILS table INSERT INTO LMS_STUDENT_DETAILS (STUDENT_ID, STUDEN... | 2 weeks ago | 3 weeks ago |
Tom,I create databases then I run the catalog.sql and catproc.sql. Sometimes, I donot run pupbld.sql. Users may get warning message but they could login and work.But, My friend says that if pupbld.sql is not run as system then users will get the error messages... | 2 weeks ago | 23.7 years ago |
connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist... | 2 weeks ago | 7.7 years ago |
We have an application that has been written to insert a variable that is char(50) into a column that is defined as char(40). In Oracle 11g (I know this is very old) it would merely truncate the last 10 characters without issue. However, Oracle 19c doesn't a... | 2 weeks ago | 5 weeks ago |
Hi TeamI have below scenario.Step#1) User clicks to particular App UI screen.Step#2) User selects multiple filters on UI - say filter1, filter2 which correspond to table columns.Step#3) For each filter selected by user, he needs to enter data - say Mark (for f... | 2 weeks ago | 4 weeks ago |
I have a user defined database package which is used quite heavily. When I need to update the code body, I will get several<code>ORA-04061: existing state of package body "CS.PACKAGE" has been invalidatedORA-04065: not executed, altered or dropped package bod... | 2 weeks ago | 3 weeks ago |
Hi,I used explain plan and got the following results. Based on cost and time, does query 2 perform significantly better than query 1? The runtime for query 1 is approximately 1 minute and 40 seconds, but it shows 07:47:02. Why is the estimated time so differen... | 2 weeks ago | 3 weeks ago |
Hi, Tom. Please see below script.<code>create table t0326 (id number, num varchar2(100)); declare v_empno number:=125854437665589038536841445202964995521300;begin dbms_output.put_line('v_empno -- ' || v_empno); dbms_output.put_line('to_char(v_empno) -- '||... | 2 weeks ago | 3 weeks ago |