Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 473 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Oracle APEX - How to deal with Unresponsive Page when executing in SQL Command ?
Hi,
In Oracle Apex 20.2, when I execute a simple Delete query, the page hangs and just gives off a pop up that says the page is unresponsive.
Code:
DELETE FROM wwv_flow_files where ID = 19575854524840376
Pop Up:
Not only does this occur when I execute a simple delete query but I also have other codes that triggers this issue such as loops and inserts.
I have already tried to do the following:
- Log off from the workspace and relogged in.
- Close all browsers and relogged in.
- Restarted laptop.
After doing all of the above, I am still encountering the same issue. I have encountered this before but simply relogging into the workspace usually solved it but this time it has become more persistent.
How can I fix this issue?
Any ideas or suggestions are appreciated.
-Jazz
Best Answer
-
Just a reference for anyone reading this thread.
We were not sure how to specifically locate the locked rows and table and was taking much time so a workaround that my DBA did was restart the Autonomous database and that seemed to kill all the sessions on the locked rows so now it's working well.
I think this is not recommended if you have multiple developers and your app should be running all the time.
Answers
-
Tried to clear browser's cache and tried to use another browser (Firefox). I does not work.
-
I am able to delete other files like
But for some reason I cannot delete this specific file I uploaded named Process.zip, When I try to delete this rows, it would just hang or the page just freezes forever.
I am working with files called Process.zip and I have successfully uploaded and deleted this kind of file before. Just this day it decides to be freezing now.
-
I don't know what is issue with your browser. But you shouldn't directly update, insert or delete anything from APEX internal tables. That isn't supported.
-
Do the DELETE statement - then find that session in v$session and look at its wait and event states.
-
Hi @Billy Verreynne , I found out about the term locks and this is very new to me and I think this is the cause of my issue. It's something like a session that's still running so I think I'll need to find out where that is and then kill it.
I remember I did execute a WHILE LOOP on those rows that will never exit the loop.
I have tried to query FROM v$session, or v$lock, or dba_objects but I'm only getting table or view does not exist.
Can you help how I could query this in Oracle Apex?
-
Your Oracle schema needs select privs on the data dictionary.
Talk to your DBA about providing this grant, or to assist in determining the wait and events states of the problem session.
Wearing my DBA hat, I have no issues granting developers access to v$ virtual performance views in dev environments - it provides them with better insights into the technical workings of Oracle.
-
Would the query my DBA need to execute be this? grant select any dictionary to schema_name;
-
Would the query my DBA need to execute be this? grant select any dictionary to schema_name;
Yes.
-
Thank you @Billy Verreynne. I'll be trying this approach as it also seems to be the only solution I have seen through my extensive research on this today.
-
Just a reference for anyone reading this thread.
We were not sure how to specifically locate the locked rows and table and was taking much time so a workaround that my DBA did was restart the Autonomous database and that seemed to kill all the sessions on the locked rows so now it's working well.
I think this is not recommended if you have multiple developers and your app should be running all the time.
