Discussion List

• os authentication for backup tool

  Answered 21 views 9 comments 0 points Most recent by Mr. C Aug 26, 2025 8:03AMDatabase Backup and Recovery (MOSC)
• Reducing Cluster factor

  Answered ✓ 23 views 2 comments 0 points Most recent by Jonathan Lewis Aug 21, 2025 9:29PMSQL Performance (MOSC)
• Performance Issues with INV Tables and Indexes in Oracle EBS R12.2.10 – Need Expert Guidance

  Answered 21 views 4 comments 0 points Most recent by Suhasini-Oracle Aug 11, 2025 8:22PMInventory Management - EBS (MOSC)
• Seeking Advice on Oracle EBS Table Growth – LOB and Index Size Concerns, EBS R12.2.10 , Performance

  Answered 31 views 2 comments 0 points Most recent by Jonathan Lewis Aug 7, 2025 9:35AMDatabase Tuning (MOSC)
• How to enable SARM logs for specific components (like EAI and Workflow) to triage Siebel REST API.

  Answered 62 views 2 comments 0 points Most recent by Mallik Kalluri -Oracle Jul 30, 2025 9:28PMSiebel System Admin, Install and Upgrade (MOSC)
• Oracle on Windows – Why Is Swap Used With 49 GB Free RAM?

  Answered 21 views 2 comments 0 points Most recent by Mustafa KALAYCI Jun 2, 2025 9:54AMDatabase Tuning (MOSC)
• Data load SQL runs nightly with same sql-id but execution plan changes

  Answered 12 views 2 comments 0 points Most recent by Arsalan Dehghanisariyarghan May 29, 2025 11:54AMDatabase Administration (MOSC)
• Gather Schema Stats Failing with error on Custom Table - Database 19C

  Answered 121 views 23 comments 0 points Most recent by Jonathan Lewis Apr 25, 2025 7:55AMDatabase Administration (MOSC)
• Query for Forms Runtime Process

  11 views 1 comment 0 points Most recent by User0108 Mar 5, 2025 5:25AMTechnology Stack - EBS (MOSC)
• For *a single SQL* what command stops the automated SQL-TUNING-ADVISOR

  Answered ✓ 51 views 6 comments 0 points Most recent by DDeb Feb 19, 2025 5:07PMDatabase Administration (MOSC)
• Exporting HFM Data Audit to excel hangs

  Answered 31 views 2 comments 0 points Most recent by Abdul Sherif-Oracle Feb 13, 2025 6:51AMHyperion Financial Management (HFM) (MOSC)
• In which sections of AWR and Statspack can we identify how much CPU the database usually consumes?

  Answered 41 views 4 comments 0 points Most recent by Mr. C Feb 6, 2025 1:31PMDatabase Tuning (MOSC)
• DBMS_RESOURCE_MANAGER.CALIBRATE_IO ran in CDB$ROOT, results not showing in DBA_RSRC_IO_CALIBRATE PDB

  Answered ✓ 21 views 1 comment 0 points Most recent by MarkStewart Jan 14, 2025 8:38PMSQL Performance (MOSC)
• Request for Optimization Solutions for High Transaction Volume

  Answered 11 views 1 comment 0 points Most recent by Nirmal Natarajan-Oracle Oct 31, 2024 4:04PMPerformance - EBS (MOSC)
• SQLHC.zip is blocked to transfer using WinSCP sftp utility to prod and Non Production by DLP policy

  Answered 1 view 2 comments 0 points Most recent by User_YTSX0 Oct 29, 2024 9:35AMDatabase Utilities (MOSC)
• Performance tuning a query

  Answered 11 views 3 comments 0 points Most recent by Sadeesh - Oracle-Oracle Oct 13, 2024 1:18AMPayables and Cash Management - EBS (MOSC)
• PeopleSoft FIN Reporting Environment - MS SQL Server DB

  Answered 21 views 2 comments 0 points Most recent by Velu Angusamy Sep 23, 2024 5:12PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• ERROR at line 1: ORA-31011: XML parsing failed ORA-19213: error occurred in XML processing at lines

  Answered ✓ 81 views 1 comment 0 points Most recent by Ken J -Oracle Sep 13, 2024 4:26PMDatabase Tuning (MOSC)
• INCREMENTAL stats. collection on large table takes long time after new column

  Answered 53 views 3 comments 1 point Most recent by Ken J -Oracle Sep 9, 2024 1:13PMDatabase Tuning (MOSC)
• Creating plan baseline from AWR in PDB

  Answered ✓ 141 views 4 comments 0 points Most recent by dougk Aug 26, 2024 4:23PMDatabase Tuning (MOSC)
• How to mitigate slow performance validating account chartfield values

  Answered 1 view 3 comments 0 points Most recent by Vicki K Aug 23, 2024 3:56PMSupply Chain Management - PSFT (MOSC)
• Highest I/O consuming queries

  Answered 31 views 5 comments 0 points Most recent by Jonathan Lewis Aug 6, 2024 3:04PMDatabase Tuning (MOSC)
• Copy SQL Tuning Task to different database

  Answered 31 views 5 comments 0 points Most recent by Swati Aryasomayajula -Oracle Jul 22, 2024 8:40AMDatabase Tuning (MOSC)
• Display the buffer cache hit ratio of my Oracle 19c production database

  71 views 8 comments 0 points Most recent by BPeaslandDBA Jul 19, 2024 2:55PMDatabase - RAC/Scalability (MOSC)
• Performance Tuning Tips on EPM 11.2.17 / Essbase 21.5.5.

  Answered 174 views 1 comment 0 points Most recent by Kiran Nagaraja-Support-Oracle Jul 16, 2024 6:12AMHyperion EPM General (MOSC)
• I have faced, db hanging , 'library cache pin' wait event while calling procedure

  Answered 31 views 6 comments 0 points Most recent by Shravani-Oracle Jun 13, 2024 9:51AMDatabase Administration (MOSC)
• SQL Optimization Strategies

  Answered 21 views 5 comments 0 points Most recent by Mustafa KALAYCI May 14, 2024 2:05PMDatabase Tuning (MOSC)
• REORG not completed on-time but business requested to hold the activity to trigger the jobs.

  Answered ✓ 11 views 1 comment 0 points Most recent by BrunoVroman May 7, 2024 2:53PMDatabase Tuning (MOSC)
• PL/SQL Performance tuning

  Answered 21 views 1 comment 0 points Most recent by Masiuddin Ahmed-Oracle Apr 16, 2024 6:12AMDatabase - RAC/Scalability (MOSC)
• PLSQL slowness

  Answered 11 views 1 comment 0 points Most recent by SureshMuddaveerappa Jan 25, 2024 10:59PMDatabase Tuning (MOSC)