Best Of
Re: Full Package increase the Tablespace
Hello @2011
So you see an increase in tablespace utilization. May Iask what tablespace?
Also you could look in package build kernel log if you see anything like this:
OCI0000179 - Error - ORA-01653: unable to extend table <tablespace>.<table_name> by <x> in tablespace <tablespace>
If this error is encountered, set the tablespace to autoextend.
But a general rule I would go through so you have autoextend turned on, to not encounter any issues if you have an Oracle Database. Your DBA would be able to identify tablespaces that is running out of space to make sure autoextend is on and you dont need to drop anything.
Sincere regards
Johan
Re: Full Package increase the Tablespace
Hi
The following documents can help in archiving and purging to reduce tablespace . It also has information on freeing up disk space as well
E1: ENV: Archive and Purging within JD Edwards EnterpriseOne (Doc ID 1082128.1) E1: ENV: OS: How To Housekeep JDE Objects For More Free Disk Space? (Doc ID 1345177.1)
Regards,
Prabhu
Re: why redo and undo logs are required during flashback of database? aren't flashback logs enough?
Hi,
In Oracle, Flashback Database relies primarily on flashback logs, but redo logs and undo are still required because flashback is not a standalone mechanism—it integrates with Oracle's recovery and transaction management architecture.
Flashback Database = Flashback Logs (physical rewind) + Redo (roll forward committed changes) + Undo (rollback uncommitted transactions). Flashback logs alone can restore block versions.Redo and undo ensure logical consistency at the target point-in-time.
Without redo/undo:
Database would be physically correct at SCN but transactionally inconsistent.
You could end up with partially applied or uncommitted transactions.
Thanks,
Mahesh
Re: why redo and undo logs are required during flashback of database? aren't flashback logs enough?
Physically correct → The database files and blocks are not corrupted; they look like they existed at that SCN.
Transactionally inconsistent → Some transactions were only partially done or uncommitted, so the data does not reflect a clean, committed state.
Thanks,
Mahesh
Re: Full package build is failing after Deployment server OS upgrade to 2022
Thank you JohanR for your recommendations. I have just put this value in registry. Restarted the Server. Submitting a full build now to see how it goes. Will keep you updated.
On Windows the key registry DWORD:
HKLM\SYSTEM\CurrentControlSet\Services\TcpIp\Parameters\KeepAliveTime = 900000
Default is 7200000
Thanks
Jitendra
Re: How to change the Content Response value in Siebel REST inbound services
Hi Jagan,
Thank you very much for the detailed explanation then i will try at the LBR level create the policy.
Regards
Asif
Re: Where can I download the correct opatch version?
Hello,
I see, yes, the download information for "Opatch for DB 23.0.0.0.0" is incorrect, but you do not have Oracle 23, you have Oracle 19 so you need to choose OPatch for DB 19.0.0.0 from the drop down menu and download : p6880880_190000_MSWIN-x86-64.zip
which is the version needed for your configuration.
regards,
Melody S - Oracle
Re: Workflow Java Mailer Analyzer (Doc ID 2901874.1)
Hi Zaheer,
I have informed the respective team to fix this
Regards,
ompriya
Re: how to add the "POS_REG_APPROVE_FULL_ACCESS" in the function to access the approved suppliers
Thanks all.
I have recently included the "POS_REG_APPROVE_FULL_ACCESS" option in the menu, which now allows me to view all supplier users and send password reset requests to their corresponding email addresses.
Thanks all for your kind support.
Re: High latency on ODA X10-HA/HC
Hi Kay,
According to development team the 60ms latency for 1200 IOPS seems in line with our internal tests.
Br,
krisz
