Questions

Hi Team,Recently, while reading articles by Maria Colgan, I found out that I was able to generate reports from the v$sql_monitor info that help me alot when I am trying to find out what is happening to the performance on our systems. I am also using the histo...

Hello Connor/Chris,Hope you are doing well.Not sure if I am missing something obvious but is there a way to limit execution of specific SQL ID to a certain amount of elapsed time/CPU time? I looked at Resource Manager but it only allows to affect based on user...

Hi Tom.When running a DML, the dba_tab_statistics, stale_stats column will be set to "YES" for the related table also when it was before "NO". It will remain to yes, also when the entire transaction was rolled back.So it looks like the update in dba_tab_statis...

I would like to link a notebook (preferably Jupyter) to an on-prem Oracle DB. I understand that I can do this by making calls with Python, but this is <u><b><i>NOT</i></b></u> what I am looking for. I am looking a way to run the native SQL. Can I do this via S...

El erro al crear un Interactive Grid en la versión Oracle APEX 24.2.0 en versiones anteriores funcionaba sin problemas ORA-01400: cannot insert NULL into ("APEX_240200"."WWV_FLOW_IG_REPORTS"."ID")...

Hi team,I have an oracle apex 19.2 application.My app is supposed to be integrated on my clients web sites as an iframe. This is something which works very badly since Safari doesn't accept third party cookies (cookies of my app are considered third pary cooki...

Hi:(DB version 11.2.0.3, running on Linux 64-bit)In AWR report "SQL ordered by Elapsed Time", - for many top long-running SQLs, quite often I see sum(%CPU+%IO) > 100%.- for SQLs further down (i.e. not long-running ones), quite often I see sum(%CPU+%IO) si...

Hi,While listening through the video "Developer Coaching - Oracle Database 23ai - Zero Slides, Zero Marketing, 100% Live Demo" there mentioned that we can set the oracle wallet path to system: to access the windows level certificates, but when I tried the same...

Hi Team,I have tried to find good explanation for this wait event online, but not found anything that gives me a clear and concise answer.Recently we have started getting "resmgr:cpu quantum" wait event on our production database. This is a database with 40 C...

Hi everyone,We’re developing an APEX app that handles Excel files, and we’ve run into a problem when trying to export the app from one Workspace and import it into another.<b>The main issue:When we export the app and attempt to import it into a different Works...

Hello,We have migration project form Oracle database 11g in Exadata server, to 19c in ODA server, when we tested the query in the new server with client tool such as Sql developper, Sqlplus and Sqlcl, the connection was lost after 1 hour of inactivity, the onl...

Hi,We have a partitioned table that is very critical to the operation of a 24/7 OLTP application. Data is mainly only INSERTED into this table and every transaction that happens writes to this table. Data in this table is usually not required after a month or ...

Hi "Tom",A question regarding the Gradual Password Rollover feature. I'm running Oracle Enterprise 19.24 on Linux.Consider this example, assuming I run it on September 1st:<code>create profile PWROLLOVER limit password_rollover_time 10;alter user SCOTT profile...

Thank you for taking my question.We're getting ready for 23ai and see that there is a new RESET_STATE option we can use if we're using PL/SQL behind a web server connected to Oracle using a connection pool and serving up stateless services. (https://docs.oracl...

Hi Tom,sorry for asking this dumb question. This is about how blocks are placed in the buffer cache, Say a 50 GB table is accessed using Full table scan with buffer cache size 20 GB, Does Oracle bring all the blocks of the 50 GB to the buffer cache and produce...

Tom, I have a doubt about adding columns with default values to a table. Recently, I have stumble upon an Arup Nanda article on it where he states the following"When a user selects the column for an existing record, Oracle gets the fact about the default value...

In my CI workflow I must often remove a complete schema with a very large number of objects in it.Simply using "drop user <user> cascade" works but takes a long time of up to 5 minutes.Starting by first removing constraints and tables before using "drop user <...

There is an requirement to get the DDL for Oracle fusion custom tables is it possible to achieve??...

Hi,is it possible to audit (unified auditing) access to tables only once per session? I don't need to catch all selects from audited tables in a session, I just want to to know if a table was at querried at least once. Currently it generates huge amount of aud...

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...