Questions

Oracle has published following document for MySQL:https://blogs.oracle.com/mysql/why-your-application-should-not-use-one-mysql-user-for-everything.I have not found similar document for Oracle Database: I would like to know if Oracle has documented something si...

Dear Tom,In our ERP, we are actively consuming both EBR & Supplemental Logging. EBR is for upgrades with a near zero downtime while Supplemental Logging is mainly for CDC, LogMiner & GoldenGate. But we encounter errors when ALTER TABLE statements are executed ...

how to find which field raise the error 6502 or 1408?...

hiI have created an interactive report I want to include heading e.g. Amountwise advances as on how can I do thisAlso I want to include heding while downloading as pdfplease help...

I have a table with partitions and I would like to find the most efficient way to empty a clob column for an entire partition.I thought I could use DBMS_REDEFINITION with col_mapping and part_name but I am always getting ORA-42000.Here are the statements I am ...

what is the difference between logging and nologging when creating an index...

ORDS Landing Page Shows "ok" For Apex And Sql Developer Instead of "GO" button. I can't access to apex workspace page.when i click on the "ok" it toke me to apage shwing "not found http status code :404 Impossible to meet the requirement with a database. Veri...

My question is if they add the column the table will be block during the coluum add because it's not enteprise but standard edition...

Recently we observed that cached sequence values were lost significantly, appearing as large gaps in persisted values.Our system does not expect gapless sequence values, however we are trying to understand root cause.gv$rowcache shows high getmisses in histogr...

We are planning to migrate our database from on-premises infrastructure to ODA. The source platform is Solaris sparc, and the target platform is x86. We intend to use the M5 Cross-Endian Platform Migration approach.However, we have a question regarding whether...

Hello,I have an Oracle Advanced Queuing queue and would like to be able to process this queue from inside of the database, as opposed to using an external app server. However, I am concerned about the scalability of internal solutions.Please assume the followi...

Is there a way to create a On-premise MCP for oracle database without using OCI as a gateway? I want to deploy a real server (vm/container etc) rather than running a local instance of SQLCL on a user desktop that way we are able to configure the agent framewo...

I conducted an experiment with the recyclebin parameter.First, I set recyclebin = OFF to observe the behavior of a regular DROP TABLE.As I understand the architecture:there is a tablespace and a segment, for example T1.Information about this segment is stored ...

Hi Tom, I have created a TYPE as: Create or replace type NUM_ARRAY as table of varchar2(1000);Then I have a procedure which accepts an ARRAY of sql statements and executes one at a time. Now this take a lot of time to process a batch of sql statement.I wa...

I'm using Apex 23.1 and I want to add a new font family in Tiny MCE with url file reference ! here's what I've done :1- in Initialization JavaScript Function section<code>tinymce.init({ /* ... */ font_formats: "Andale Mono=andale mono,times; Arial=arial,helv...

Hello,If we are using Oracle SE2 there is no Tuning Pack or Diagnostic Pack available.So I don't think it's possible to create a SQL profile with SQL Tuning Advisor. would it be possible with SQLTXPLAIN coe_xfr_sql_profile.sql script ?I know it's possible to c...

Hi,I have a database with thousands of tables containing the same kind of information.I need to write a program to aggregate these informations and thought about using a sqlmacro.<code>-- This is a very simplified conceptcreate or replace function get_val (...

Tom,What is connection pooling ? Please, can you give an example(s) that show thorough understanding of the subject matter as related to either ODBC OR JDBC application connections to the oracle database. Your site is more important and most value to the li...

We have PL/SQL stored procedures that perform poorly, Using DBA_HIST or any other AWR / ASH metrics, is it possible to determine the runtimes of PL/SQL Procedures ? ...

Hello Chris/Connor,Hope you are doing well.We are using ExaC@C with 19c databases at work and are exploring whether we can use PDB Snapshot Carousel and/or PDB Snapshot Copy feature.It might be just me but I am somewhat confused with the "art of possible" whil...