Discussion List

• Receiving alerts for CHA_IOPS_HIGH_X on one of our RAC database instances

  Answered 61 views 2 comments 0 points Most recent by User_WB2XU Dec 1, 2025 2:54PMDatabase Administration (MOSC)
• Compression causing performance issue.

  Answered ✓ 42 views 3 comments 0 points Most recent by Ken J -Oracle Nov 3, 2025 12:28PMDatabase Tuning (MOSC)
• Incremental statistics taking long time suddenly

  Answered 61 views 6 comments 0 points Most recent by S-George Aug 11, 2025 5:38PMDatabase Administration (MOSC)
• Seeking Advice on Oracle EBS Table Growth – LOB and Index Size Concerns, EBS R12.2.10 , Performance

  Answered 46 views 2 comments 0 points Most recent by Jonathan Lewis Aug 7, 2025 9:35AMDatabase Tuning (MOSC)
• Oracle Data Guard Setup between windows DB servers

  Answered ✓ 34 views 4 comments 0 points Most recent by SethuKanthiah-Oracle Jul 24, 2025 6:31PMHigh Availability Data Guard, Sharding and Global Data Services (MOSC)
• RMAN backup performance on NFS storage degraded after the OS upgraded from OEL 8.7 to 8.10

  Answered 31 views 3 comments 0 points Most recent by User_EUO9Y May 27, 2025 5:06AMDatabase Backup and Recovery (MOSC)
• "Best Practices for Secure Password Management in Oracle Forms 12c/WebLogic 12c/Oracle 19c Environme

  Answered ✓ 41 views 5 comments 0 points Most recent by masami-Oracle May 26, 2025 4:41AMDatabase Security Products (MOSC)
• Oracle memory model AMM, ASMM

  Answered 42 views 8 comments 0 points Most recent by Mr. C Feb 21, 2025 12:13PMDatabase Memory & 4030/4031 (MOSC)
• Database Trigger

  Answered ✓ 51 views 20 comments 0 points Most recent by T1DSoldier Dec 10, 2024 4:57PMDatabase Tuning (MOSC)
• SQLHC.zip is blocked to transfer using WinSCP sftp utility to prod and Non Production by DLP policy

  Answered 2 views 2 comments 0 points Most recent by User_YTSX0 Oct 29, 2024 9:35AMDatabase Utilities (MOSC)
• INCREMENTAL stats. collection on large table takes long time after new column

  Answered 51 views 3 comments 1 point Most recent by Ken J -Oracle Sep 9, 2024 1:13PMDatabase 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)
• Oracle histogram creating 75 buckets with method_opt => 'FOR ALL COLUMNS'

  Answered ✓ 21 views 2 comments 0 points Most recent by Jonathan Lewis Jun 27, 2024 9:09AMDatabase Tuning (MOSC)
• In Project status>commitment seeing Reject PR

  Answered 11 views 3 comments 0 points Most recent by Christine M-Oracle May 20, 2024 2:56PMProjects - EBS (MOSC)
• SQL Optimization Strategies

  Answered 21 views 5 comments 0 points Most recent by Mustafa KALAYCI May 14, 2024 2:05PMDatabase Tuning (MOSC)
• Can we Create Policies in Traditional audit

  Answered 21 views 2 comments 0 points Most recent by Masiuddin Ahmed-Oracle Feb 29, 2024 6:04AMDatabase Administration (MOSC)
• Is it possible to monitor/detect/repair execution plan in case oracle optimizer changed it surprisin

  Answered 51 views 4 comments 0 points Most recent by Jonathan Lewis Jan 18, 2024 11:16AMDatabase Tuning (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)
• LVM with ASM

  Answered ✓ 321 views 3 comments 0 points Most recent by SureshMuddaveerappa Dec 18, 2023 4:17PMStorage Management (ASM ACFS DNFS ODM) (MOSC)
• HOW TEMP is calculated for Parallel sessions.

  Answered ✓ 51 views 7 comments 0 points Most recent by Jonathan Lewis Oct 18, 2023 8:44PMDatabase Tuning (MOSC)
• Why no value under EXEC# column in execution plan?

  Answered 21 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)
• Oracle optimizer env

  Answered 12 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)
• EBS and DB Migration and upgrade in single window

  Answered 41 views 2 comments 0 points Most recent by Nikhil Wani Jul 28, 2023 7:33AMInstall, Upgrade, Clone, Patch - EBS (MOSC)
• during patch # 33671306 (R12 ENHANCEMENTS: PROGRAM OPTION PROPAGATION, FILE EXT WITH FILE FORMAT)

  3 views 1 comment 0 points Most recent by Chris-FA Tech Jul 12, 2023 5:38AMInstall, Upgrade, Clone, Patch - EBS (MOSC)
• Monthly-Weekly-Daily Database Maintenance Tasks

  Answered 34 views 2 comments 0 points Most recent by SureshMuddaveerappa Jul 1, 2023 3:43AMDatabase Administration (MOSC)
• Best practice for application data purge activity

  Answered 21 views 3 comments 0 points Most recent by SureshMuddaveerappa Jun 16, 2023 6:39PMDatabase Administration (MOSC)
• second NTP server unreachable

  Answered 31 views 10 comments 0 points Most recent by SureshMuddaveerappa Jun 16, 2023 12:45PMExadata General (MOSC)
• query to find all sql statements taking more than a certain amount of time

  Answered ✓ 31 views 2 comments 0 points Most recent by A.Amin May 22, 2023 3:04PMDatabase Tuning (MOSC)