Skip to Main Content

Questions

QuestionUpdatedAsked

Hi, I support a comparatively small project of around twenty OLTP instances on AWS. My customer expects both full auditing and least necessary privileges in all environments -- which hasn't been a problem for code development and artifact promotion. My team le...
4 hours ago7 days ago

Hello Tom,Is there a way to find out the maximum SGA and PGA ever used in an instance ?We need to do some strict assessment where we need to check whether the SGA and PGA assigned by us is being completely utilised or not. If not 100% utilised then how to find...
5 hours ago6 days ago

Hello,Any advice or suggestion on what tool or software (3rd party) i can use to replace BMC fast unload? i have several scripts running using it but with upgrade in oracle, sometimes i am having problem with the software (compatibility i guess). i learned tha...
5 hours ago7 days ago

What info fo weather forecasters have that make them not agree with the computer models? ...
5 hours ago5 days ago

Hello, I am studying and analyzing Oracle Redo Logs. They have a pattern for each DML such as OP 5.1/ OP 11.2 for INSERT Statement. Few days ago, I found new OP Code that I have not seen before, which is OP 11.22 and 11.28.Unfortunately, the only information a...
5 hours ago4 days ago

Team,Given this JSON, how do i increment the quantity by two in each level?tried the below using json_transform but ended up with error.is that possible using json_transform function? kinldy help.<code>demo@XEPDB1> select json_serialize(y pretty) y 2 from t ...
3 days ago5 weeks ago

I have query like:<code>select case when 1 in (1,2,3) then(select 'abc' as "name 1",'xyz' as "name 2" from dual)else 'pqr' end from dual; </code>How can I return two columns if a condition is satisfied in case?...
3 days ago3.6 years ago

Before understand question mind I have one table with 3 columns one is id second is description and third is sql query, i created one Apex page with two region one is static region and one is Interactive Report Region. In Static region i have one select list ...
4 days ago1.5 years ago

Hi,I have a nested table with three columns within the nested column. I have 3 entries for the same ID within the nested column. I want to unnest this table and get the 3 entries as separate columns in single row. How do I do it?Below is the code:<code>create ...
4 days ago7 days ago

Hi Tom,I tried to use Bind Variables in my Script. But that script is taking more time than expected. Please have a look at the below script.area@DBWH> truncate table t1;Table truncated.Elapsed: 00:00:00.50area@DBWH> declare 2 begin 3 for i in 1..100000...
4 days ago18.8 years ago

The following question was asked, but got attached to the Nov 24th session which was re-scheduled to this Nov 18th session:Question from USER399341 forDatabase In-Memory Office Hours - 2021-11-24I have a Table with all transaction amounts (both +ve and -ve amo...
5 days ago5 days ago

Hello ,i want to have multiple value per cell and i used nested tables.After creating my table projects with a the nested column categories, i insert some rows. but when i do select * from tables , i have the error unsupported data type by the column categorie...
5 days ago4.7 years ago

Hey Connor :-),I've seen this pretty nice graph about "Active Sessions Per Activity Class" from EMCC 13.5, take a looking at the following 2 number of screenshots.https://quanwenzhao.files.wordpress.com/2021/11/active-sessions-per-activity-class_1.pnghttps://q...
7 days ago2 weeks ago

Hi Tom/Team,I have installed Oracle 11g Database on my Windows 10 64-bit machine.All installation has been completed successfully. I have checked connections by sqlplus and it's running fine. I am able to run queries as well there. So database is working fine ...
7 days ago2.9 years ago

Hello team, RMAN report unrecoverable is showing that we have NOLOGGING operations in the database. Is there a way to find out which query performed the NOLOGGING operation? Thanks for your help. ...
7 days ago11 days ago

<code></code>Team,<i>The version of oracle we use is :" Oracle Database 19c Enterprise Edition Release 19.0.0.0.0".</i>Lets consider our basic scott.emp table for this scenario limited to few columns.The external table creation script goes something like this ...
7 days ago11 days ago

We are unable to install 18c Expression Edition in Windows 10 it is extracting and in middle, it is start rollback. Finally below the below message. Below is the message.The wizard was interrupted before Oracle Database 18c Express Edition could be completely...
7 days ago2.7 years ago

Hi, I have a simple sql like "SELECT max(case when day=:1 then tra else 0 end) tra, max(case when tra=1 and day<:2 then day else '0' end) lasttradingday FROM settlement.t_calendar@dl_otcdb WHERE day <= :3 ". It query blocked offen. I cannot find an...
10 days ago11 days ago

Hi Team,I have a disaster recovery scenario using RMAN. RMAN backup settings:- Database is backup using RMAN incremental Level 0 every Sunday- Database is backup using RMAN incremental Level 1 daily (Mon-Sat)- The archive log is backup every 15 minutes- Contr...
10 days ago11 days ago

looking for the best way to move data from oracle 19c oltp system(size 13tb) to oracle 19c warehouse db. Currently using stantby database to fetch the modified rows and add to warehouse system. This process is taking so much time. ...
10 days ago11 days ago