Discussion List

• MTL_SYSTEM_ITEMS_B Performance - any recommendations related to paritioning

  Question 1 view 2 comments 0 points Most recent by Suhasini-Oracle Sep 2, 2022 5:08PMInventory Items (APC/PLM/PIM) - EBS (MOSC)
• INCREMENTAL Statistics taking long time

  Answered 21 views 4 comments 0 points Most recent by Kazuhiro Jul 3, 2022 1:23AMDatabase Tuning (MOSC)
• SQL Performance through ODI

  Answered 1 view 5 comments 0 points Most recent by SureshMuddaveerappa Jun 3, 2022 4:36AMDatabase Tuning (MOSC)
• Destroy Connection Handle & Create Connection Info are causing performance issues

  Answered 281 views 4 comments 1 point Most recent by Davet-Oracle May 30, 2022 10:32PMPeopleTools and Lifecycle Management - PSFT (MOSC)
• Significant 'Cursor: Pin S Wait On X' Waits When Using In-memory Column Store and Parallel Query (Do

  Answered ✓ 31 views 8 comments 0 points Most recent by Arsalan Dehghanisariyarghan May 19, 2022 10:43AMDatabase Tuning (MOSC)
• INSERT with CLOB column resulting in high db file sequential read events

  Answered ✓ 31 views 2 comments 0 points Most recent by Andrew Tindle May 11, 2022 11:05AMSQL Performance (MOSC)
• User specific performance issue in Oracle PDH for item attribute change

  Question 1 view 0 comments 0 points Most recent by Shenaz Rahaman Mar 22, 2022 5:44PMPerformance - EBS (MOSC)
• Automatic SQL Cursor Invalidation and Execution

  Answered ✓ 21 views 13 comments 0 points Most recent by SureshMuddaveerappa Feb 24, 2022 5:39PMDatabase Tuning (MOSC)
• Set of SQL statements are slow/hung -- Going into endless loop with wait event : latch: cache buffer

  Answered 21 views 6 comments 0 points Most recent by Kazuhiro Jan 24, 2022 11:19AMSQL Performance (MOSC)
• None-Partition Table to Partition Table conversion - Oracle 19c EE/RAC/AIX

  Answered 51 views 4 comments 0 points Most recent by Mark D Powell Jan 20, 2022 3:54PMSQL Performance (MOSC)
• Oracle Custom VIEWS Performance Issues

  Question 1 view 0 comments 0 points Most recent by AnishRV Jan 7, 2022 6:33AMPerformance - EBS (MOSC)
• Oracle Custom VIEW Performance Issues

  Answered 11 views 3 comments 0 points Most recent by Arsalan Dehghanisariyarghan Jan 7, 2022 6:30AMDatabase Tuning (MOSC)
• long running data load procedure

  Answered 11 views 3 comments 0 points Most recent by Helmut -Oracle Oct 28, 2021 9:53AMDatabase - RAC/Scalability (MOSC)
• OEM to monitor older database versions

  Answered ✓ 1 view 4 comments 0 points Most recent by Venkata Thiruveedhi-Oracle Oct 21, 2021 7:08PMEnterprise Manager Certification (MOSC)
• Oracle upgrade from 12C to 29C

  Answered ✓ 11 views 7 comments 0 points Most recent by Ramya S Oct 8, 2021 6:37PMSQL Performance (MOSC)
• SQL_ID changing for same/identical SQL TEXT

  Answered 215 views 2 comments 0 points Most recent by Mark D Powell Oct 4, 2021 5:10PMSQL Performance (MOSC)
• query not using sql baseline

  Answered 72 views 13 comments 0 points Most recent by T1DSoldier Aug 24, 2021 4:13PMDatabase Tuning (MOSC)
• Performance test in DEV with little data applying STATS from PROD

  Answered ✓ 1 view 5 comments 0 points Most recent by JackR Aug 13, 2021 1:55PMDatabase - RAC/Scalability (MOSC)
• index lock

  Answered 11 views 5 comments 0 points Most recent by Jonathan Lewis Jul 5, 2021 9:03PMDatabase Tuning (MOSC)
• RULE BASED OPTIMIZER USED ON PRIMARY AFTER SWITCHOVER WHEN OPTIMIZER_MODE=ALL_ROWS on Version 19

  Answered 11 views 4 comments -1 point Most recent by kfekete-Oracle Jun 14, 2021 7:43AMOracle Database Appliance (ODA) (MOSC)
• Diagnostic and tuning pack

  Answered 41 views 1 comment 0 points Most recent by SureshMuddaveerappa Jun 2, 2021 4:47AMDatabase Tuning (MOSC)
• Does NOAPPEND hint disable Parallel DML for a MERGE statement?

  Answered 31 views 3 comments 0 points Most recent by Jonathan Lewis Apr 28, 2021 4:40PMDatabase Tuning (MOSC)
• Which is better from a performance point of view

  Answered ✓ 11 views 6 comments 0 points Most recent by Christian Gohmann Apr 23, 2021 11:07AMSQL Performance (MOSC)
• decreasing CPU number of cores on DB server

  Answered ✓ 61 views 11 comments 0 points Most recent by Mark D Powell Apr 13, 2021 1:19PMDatabase Backup and Recovery (MOSC)
• Oracle E-Biz Concurrent Programs some times running Slow

  Answered 1 view 1 comment 0 points Most recent by J Reinhart Apr 13, 2021 11:02AMTechnology Stack - EBS (MOSC)
• rebuilding index and gather stats

  Answered ✓ 41 views 7 comments 0 points Most recent by Mark D Powell Mar 30, 2021 5:07PMDatabase Backup and Recovery (MOSC)
• What would be the cause sudden database get slow performance after upgrade

  Answered ✓ 121 views 6 comments 0 points Most recent by Arsalan Dehghanisariyarghan Mar 9, 2021 8:30AMDatabase Install/Upgrade/Opatch (MOSC)
• SQL Profiles : Migration

  41 views 4 comments 0 points Most recent by DDeb Mar 8, 2021 5:29PMDatabase Tuning (MOSC)
• -SQL PLAN BASELINE-

  Answered ✓ 21 views 4 comments 0 points Most recent by Arsalan Dehghanisariyarghan Mar 1, 2021 9:16PMDatabase Tuning (MOSC)