Discussion List

• 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)
• Does AWR capture every SQL/PLSQL in "Complete list of SQL Text" category

  Answered ✓ 21 views 1 comment 0 points Most recent by SureshMuddaveerappa Jan 25, 2024 8:36PMDatabase Tuning (MOSC)
• 2736319.1 : Step 6

  Answered 1 view 2 comments 0 points Most recent by SureshMuddaveerappa Dec 29, 2023 6:32PMDatabase Utilities (MOSC)
• Choosing correct non-standard block size tablespace

  Answered 21 views 4 comments 0 points Most recent by SureshMuddaveerappa Dec 27, 2023 11:40PMDatabase Tuning (MOSC)
• Need suggestion on performance books.

  Answered 21 views 3 comments 0 points Most recent by Mohammad Rahmath Ali Dec 8, 2023 11:24AMDatabase Administration (MOSC)
• awrrpt

  Answered ✓ 21 views 2 comments 0 points Most recent by SureshMuddaveerappa Oct 18, 2023 10:48PMDatabase Administration (MOSC)
• HOW TEMP is calculated for Parallel sessions.

  Answered ✓ 46 views 7 comments 0 points Most recent by Jonathan Lewis Oct 18, 2023 8:44PMDatabase Tuning (MOSC)
• maintenance window gathering oracle stats results in optimizer choosing bad plan

  Answered 112 views 11 comments 0 points Most recent by ShaunS Oct 4, 2023 7:33PMDatabase Tuning (MOSC)
• Same query execution plan is different in 2 databases

  Answered 11 views 1 comment 0 points Most recent by asahide Sep 27, 2023 3:28AMDatabase Tuning (MOSC)
• Sort merge join fails with ORA-03113 and reports ORA-07445:

  Answered 21 views 8 comments 0 points Most recent by Mohammad Rahmath Ali Sep 18, 2023 3:56PMSQL Performance (MOSC)
• Why no value under EXEC# column in execution plan?

  Answered 22 views 1 comment 0 points Most recent by Balamurugan Sivalingam Sep 9, 2023 10:29AMDatabase Tuning (MOSC)
• Oracle execution plan in order

  Answered 61 views 2 comments 0 points Most recent by Justin Bleistein Sep 6, 2023 12:52PMDatabase Tuning (MOSC)
• Is there a way to use varchar2 fields bigger than 4k which don't use clobs internally?

  Answered ✓ 31 views 2 comments 0 points Most recent by Mustafa KALAYCI Aug 22, 2023 9:28AMDatabase Tuning (MOSC)
• Oracle optimizer env

  Answered 11 views 4 comments 0 points Most recent by Jonathan Lewis Aug 17, 2023 9:26PMDatabase Tuning (MOSC)
• Finding objects referenced in SQL query

  Answered 41 views 4 comments 0 points Most recent by Justin Bleistein Aug 17, 2023 12:21PMDatabase Tuning (MOSC)
• When will the x$tables or gv$views get refreshed or reloaded

  Answered ✓ 21 views 6 comments 1 point Most recent by Arsalan Dehghanisariyarghan Jul 7, 2023 4:56PMSQL Performance (MOSC)
• Does the create baseline template, creates baselines for all the sql's with the given start and end

  Answered 11 views 1 comment 0 points Most recent by SureshMuddaveerappa Jun 28, 2023 10:46PMSQL Performance (MOSC)
• High PGA Memory Consumption and CPU Usage By Optimizer Statistics Advisor Task (Doc ID 2885895.1)

  Answered ✓ 171 views 5 comments 1 point Most recent by SureshMuddaveerappa Jun 27, 2023 4:31PMDatabase Tuning (MOSC)
• Best practice for application data purge activity

  Answered 23 views 3 comments 0 points Most recent by SureshMuddaveerappa Jun 16, 2023 6:39PMDatabase Administration (MOSC)
• Rebalancing ASM

  Answered ✓ 41 views 7 comments 0 points Most recent by SureshMuddaveerappa May 19, 2023 3:02PMDatabase Administration (MOSC)
• Performance improvement

  Answered 11 views 2 comments 0 points Most recent by GregV May 10, 2023 7:01AMPL/SQL (MOSC)
• Is there a script or tool to monitor database uptime/down time for reporting database availability ?

  Answered 92 views 3 comments 0 points Most recent by Mark D Powell Apr 20, 2023 2:20PMSQL Performance (MOSC)
• QUERY WITH SQL CONNECT BY WITH 150 ROWS (((((( NEVER END ))))

  Answered ✓ 21 views 3 comments 0 points Most recent by SureshMuddaveerappa Mar 31, 2023 10:22PMSQL Performance (MOSC)
• Does flush shared pool really flushes he cursors. ?

  Answered 51 views 6 comments 0 points Most recent by Mohammad Rahmath Ali Mar 19, 2023 8:09AMSQL Performance (MOSC)
• Insert waiting Library cache wait and Parse calls == Execution

  Answered ✓ 103 views 6 comments 0 points Most recent by Balamurugan Sivalingam Feb 5, 2023 4:32PMSQL Performance (MOSC)
• Redo log switches a lot - Checkpoint not complete / Slow database

  Answered 72 views 19 comments 0 points Most recent by Parissa Jan 16, 2023 4:19PMDatabase Tuning (MOSC)
• LTOMg Tool Issues

  Answered 4 views 2 comments 0 points Most recent by Balamurugan Sivalingam Dec 23, 2022 12:01PMDatabase Tuning (MOSC)
• Workaround for Merge Hint Not Honored Reliably in Semi-Join (Bug 30305603)

  11 views 0 comments 0 points Most recent by user11255257 Nov 4, 2022 5:30AMPatch Reviews - DB (MOSC)