Skip to Main Content

Questions

QuestionAsked

Hi Tom,I am trying to find out how to monitor UNDO generation and REDO generation.On some databases I noticed some dangeros peak in undo generation and redo generation and I need to find out the culprit.Unfortunatly AWR and STATSPACK do not help me: the "top s...
0122.1 years ago10 years ago

When will Oracle be introducing proper async support into the managed provider?...
0122.1 years ago5 months ago

HiIn our application we file emails from outlook i.e in the process we extract the metadata into our tables and create text index on emails including attachments for search purposes. It has been working well until 11.2.0.1 but since we have upgraded our DB to ...
0122.1 years ago3 days ago

Database version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQLcl: Release 21.1 ProductionSQL*Plus: Release 12.2.0.1.0 ProductionInstalled on Red Hat Enterprise Linux Server release 7.9<b>Script:</b><code>set echo offset feedb...
0122.1 years ago3 days ago

Dear TOMThis code is not working for me since my PL/SQL release is too old<code>-- Since PL/SQL 20.2.0.175DEFINE usr = 'YourName';SELECT * FROM Table1 WHERE CreatedBy = '&usr';SELECT * FROM Table2 WHERE CreatedBy = '&usr';</code>How can I run these two queries...
0122.1 years ago3 days ago

Dear Sir,I have one issue while creating listener / starting listenerI am able to create a listener from the net manager but not netca. Even if it is created through net manager but not able to start the listener as it gives the same message "TNS-12560: TNS:pr...
0122.1 years ago3 days ago

Greetings, I have a problem with a rest service that I made from Apex in version 21.1 and at the time of making the post method to insert I started to have problems with my trigger, and it indicates the following error:<code><b>555 User Defined Resource Error<...
0122.1 years ago2 days ago

In the below one string i have to split based on "@" and then have to split "_" fields and then append "^" fields to three fields of "_" values.<code>"08550010201_750000.00_Royalty@0_22500.00_TCS@0_75000.00_DMF@08550010210_104.00_Four Mineral Premium@08550010...
0122.1 years ago2 days ago

Hi,1) There is batch program executing and one query running long is accessing a table T.It is found that an index on column will help query and batch can't be killed.Can we create an index on column of a table which is being used by long running query2) Can w...
0122.1 years ago2 days ago

Hi.My question is about "execution plan". I have a query as you can see below :<code>select t2.n1, t1.n2from t2,t1where t2.n2 = 45and t2.n1 = t1.n1;</code>There’s an index to support the join from t2 to t1 and I've Used "dbms_xplan.dis...
0122.1 years ago3 days ago

Tom,I am little confused about Oracle Database and instances. If I have created a database DB1, and started it,open for all users, does it mean it is one instance? How can I have multiple instances of a database and how do I find what Instance I am using?So, ...
0122.1 years ago12.8 years ago

How do I move lob indexes and lob segments from one tablespace to another. ...
0122.1 years ago21.6 years ago

I have a bit of an unexplainable situation.We have a procedure which executes a query and it consistently chooses the worst index. When I execute it in SQL*Plus or SQL Developer it chooses the correct index. The only way I can get it to work fast in the proced...
0122.1 years ago2 weeks ago

Hello all,Greetings of the new year!Goal - generate an output which can be directly used for pasting hierarchical data into a flat fileLink to liveSQL with sample data and scripts - https://livesql.oracle.com/apex/livesql/s/mw9olr17o7dir21jysn5jni1uExpected ou...
0122.1 years ago2 weeks ago

I wanted to extract all the numbers from this string '12gfsda@3fg,f' and want to display.Like for example i want 123 to be extracted from 12gfsda@3fg,f and display only 123....
0122.1 years ago4.4 years ago

In the company where I work, we have the services of JD Edwards and Orchestrator Studio, but we are using APEX for fast applications. The problem is that we have not managed to use the JD Edwards SMTP in APEX or an external one to test that the apex_mail.send(...
0122.1 years ago2 weeks ago

Tom - I read a little bit about the new features in 10g for HTML DB. I'm pretty excited about it if it effectively delivers on these new features (e.g., the whole meta-data driven framework, the Application Builder, Session Management, Templates, Security, etc...
0122.1 years ago18.3 years ago

Hi Tom and Team, I am looking to remove the invalid records before applying PK<code>create table OLD_ABC( PRODUCT, CLASS, SEASON_KEY, DATE, PRICE)KEY -- (PRODUCT, CLASS, SEASON_KEY, DATE)TABLE records -- Ex. ABC , 121 , S ,1-JAN-21, 15 PQR , 1...
0122.1 years ago7 weeks ago

I need to give access to other user on current DB_LINK, can you provide command ?Current Link: sittestGrant to User: Z9XBIQ1_DWRegardsChaudhry...
0122.1 years ago5.5 years ago

Hello All,The problem I raised uses a scenario from one of the quizzes played recently on Devgym.I try to use DBMS_MVIEW.EXPLAIN_REWRITE for a materialized view in LiveSQLand for some reason, I encounter an error for both the table and the array version.- For ...
0122.1 years ago3 months ago