Questions

I have a PL/SQL package and want to find that package's code coverage. I am using the DBMS_PLSQL_CODE_COVERAGE utility. I can get the code coverage for the whole PL/SQL package. But I want to get the coverage at the Function/Procedure level.The coverage tables...

Hi!, What is the best way to defragment SYS.AUD$? It is possible to use DBMS_REDEFINITION.REDEF_TABLE ?Thank you in advance....

Hello Sir Is there any view avaiable through which we can know from which file our instance has started.Is it pfile or spfile.Without making any changes to file and then seeing it by opening it.Thanks ...

In 11g RAC, the init.ora file points the spfile in ASM, so sqlplus can find it.but in 19c, sqlplus can startup even without the spfile nor init.ora,how does that happen?(I understand when I startup with svrctl , it will create a init.ora automatically)Thank yo...

Hello,I'm trying within a trigger to compare two clobs to see if there is any change. I am trying to prevent any unnecessary writes.Prior to writing to audit trail I compare two values.<code> v_clob_compare := dbms_lob.compare( :old.clob_text, :new.clob_text ...

While we are working on dbms_cloud API in ATP DB, we are facing some issues. When we are calling the API directly from SQL Developer, it works perfectly fine and data is getting loaded into the tables.<code>BEGIN dbms_output.put_line('Start Time : '||TO_CHAR(...

HiI'm trying to understand the shrink space behaviors when dealing with multiple tables with multiple lob columns sharing a single tablespace. We've 3 tables (e.g. T1, T2, T3) with each table having a lob column. And the lob columns are stored in a single tabl...

It has been stressed by Oracle, for example by The Oracle Real World Performance Team, that Dynamic Connection Pools can be a killer for database performance and should be avoided.We therefore strive to persuade application server administrators to set up Stat...

The following is a simplified version that exhibits the behavior in question.There are two tables T and F.1% of the rows of table T are indexed by T_IX.Though F has the same number of rows as T_IX, F has 1% of rows "in common" with T_IX.The cardinality are as ...

Hi Team,I use ApEx 22.1 and SQL Developer.In an ApEx page, users have to upload 4 photos of their workstation. Then with PL/PDF I generate the PDF containing texts, photos and ID number.I have no control over the uploaded photos. The aspect ratio of the images...

Hi ASKTOM team, I'm a beginner of APEX. In our system we have many differents DBs (different hosts) but they have same table structures. If user A choose in a DB-list DB1 and logged in, APEX server will connect to DB1 and uses all data from DB1If user B choose...

Greetings,In this version SQL developer 23.x, when clicking on the "+" sign next to the database, it disappears, and the database does not open.However, in older versions like version 19, the database opens normally.I have tried many versions of Java, but the ...

How can I reduce CPU utilization of Oracle database? ...

Hi,I am carrying out an update on dept table with update query as - "update dept set dname = initcap(dname) where deptno=20;"As, I have not committed, row lock will be placed on the row. I want to find out the rowid of dept table locked from V$LOCK. Currently,...

TomI've been re-visiting my knowledge on NOLOGGING as a colleague asked me a question about it today and I hate to say I couldn't remember fully why the term is a tiny bit of a misnomer (there's no denying that there is a general confusion "out there" about NO...

We have a context index that is SYNCing every 6 seconds. Here is the DDL for the index: CREATE INDEX "SSS"."QUOTE_NUMBER_CONTEXT" ON "SSS"."QUOTE" ("NUMBER_") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('SYNC (EVERY "SYSDATE+1/14400")');This was working p...

It took me a while pick database development over dabase administration, concerning a editions.My questions is simple, if I've decided to create an editioning view over a table with N triggres, what would I do about this??some people says all triggers must be ...

I activated audit on some just for unsuccessful connection attempts ( my purpose was finding who/what locks some users ).This is something I had already done many times, always fine.However on a 19 version I noted something I could not find an explanation for:...

Trying to deal with timezone + DST aware datetime handling, but I couldn't get it safe and convenient at the same time.The almost perfect solution would be timestamp with local time zone , except the fact that it uses nls_timestamp_format (opposed to using nl...

Hello, As far as I understand it, Oracle processes regular expressions according to the POSIX standard, but also supports expressions that originate from Perl.Currently I had some missleading results when searching for a space. Theoretically, this should be fo...