Discussion List

• Bad Performance, How to tune query for Journal Entries with drillDown ?

  Answered 41 views 3 comments 0 points Most recent by Chandra Sekhar Kadali-Oracle Apr 2, 2025 4:45AMGeneral Ledger - EBS (MOSC)
• SQL_profile and Tunning Advisor

  Answered 16 views 1 comment 0 points Most recent by Arsalan Dehghanisariyarghan Feb 26, 2025 10:53AMSQL Language (MOSC)
• SYSAUX taking so much space.

  Answered 82 views 5 comments 0 points Most recent by Shravani-Oracle Jan 22, 2025 4:16AMDatabase Administration (MOSC)
• Weblogic STUCK ThreadsTuning also closed normal users threads

  Answered 64 views 2 comments 0 points Most recent by Steff2-Oracle Jul 24, 2024 12:04PMOracle Weblogic Server (MOSC)
• WRT DocID 1507116.1 is there a way to revert the lob retention to "default"

  Answered ✓ 11 views 1 comment 0 points Most recent by Jonathan Lewis Mar 15, 2024 5:35PMDatabase Administration (MOSC)
• How to get CBO parameters from DBA_HIST_OPTIMIZER_ENV optimizer_env column?

  Answered 361 views 5 comments 0 points Most recent by User_MX2M4 Nov 21, 2023 5:14PMDatabase Tuning (MOSC)
• Using AWS EBS to provide ASM disks

  Answered 485 views 1 comment 0 points Most recent by gthrower-Oracle Dec 1, 2022 9:40PMStorage Management (ASM ACFS DNFS ODM) (MOSC)
• rebuilding index and gather stats

  Answered ✓ 51 views 7 comments 0 points Most recent by Mark D Powell Mar 30, 2021 5:07PMDatabase Backup and Recovery (MOSC)
• Shared pool low

  Answered ✓ 23 views 9 comments 0 points Most recent by Arsalan Dehghanisariyarghan Mar 8, 2021 9:55AMDatabase Tuning (MOSC)
• JBOSS app restart time growing.

  Answered ✓ 50 views 5 comments 0 points Most recent by SureshMuddaveerappa Sep 22, 2020 2:30PMDatabase Administration (MOSC)
• Sql Performance - HCM - Partitioned table - Query not filtering partitions.

  Answered 104 views 22 comments 1 point Most recent by User_8KB49 Jun 18, 2020 2:41PMDatabase Tuning (MOSC)
• Alertlog hugepage recommendation at startup?

  Answered ✓ 6.3K views 6 comments 0 points Most recent by BPeaslandDBA Apr 23, 2020 10:52AMDatabase Tuning (MOSC)
• Large table updates and stats gather

  Answered ✓ 63 views 6 comments 0 points Most recent by Mark D Powell Dec 20, 2019 11:25AMSQL Performance (MOSC)
• Analyzing AWR Report

  Answered 55 views 4 comments 0 points Most recent by Helmut -Oracle Oct 10, 2019 9:01AMDatabase Tuning (MOSC)
• Performance tuning best practices for inbound web services (Doc ID 2107536.1)

  Answered ✓ 134 views 1 comment 0 points Most recent by Pēteris Priedītis Sep 23, 2019 2:06AMSiebel Developers: UX, Web Tools, Scripting, Integration (MOSC)
• Queries in the shared pool

  Answered ✓ 96 views 6 comments 1 point Most recent by juduque Sep 14, 2018 8:28AMDatabase Tuning (MOSC)
• Differences between access method by index

  Answered ✓ 67 views 8 comments 2 points Most recent by juduque Jul 11, 2018 1:54PMSQL Performance (MOSC)
• Database Peformance tuning using application user

  Answered 15 views 2 comments 0 points Most recent by Vinod Shetkar-Oracle Jul 10, 2018 2:43AMDatabase Tuning (MOSC)
• Query Performance question

  Answered 53 views 5 comments 0 points Most recent by Stelios Charalambides -Oracle Jan 12, 2018 8:40AMSQL Performance (MOSC)
• optimizer_feature_enable parameter impact

  Answered 34 views 5 comments 1 point Most recent by DDeb Dec 26, 2017 12:00PMSQL Performance (MOSC)
• dbms_lob and ctx packages

  Answered 33 views 1 comment 0 points Most recent by Mark D Powell Oct 9, 2017 10:07AMDatabase DataWarehousing (MOSC)
• sql execute elapsed time

  Answered 119 views 2 comments 0 points Most recent by Tedper-Oracle Jan 18, 2017 10:01AMDatabase Tuning (MOSC)
• query tuning issue

  Answered 98 views 11 comments 0 points Most recent by J.P. Boileau Dec 20, 2016 8:51AMSQL Performance (MOSC)
• tuning about in clause SQL

  Answered 170 views 8 comments 0 points Most recent by Tedper-Oracle Sep 1, 2016 9:37AMSQL Performance (MOSC)
• Database 10.2.0.1.0 response is too late on sparc t5120 as compared to V240

  Answered ✓ 67 views 9 comments 1 point Most recent by Mark D Powell Aug 25, 2016 8:57PMSQL Performance (MOSC)
• Why are there periodic regular slow transactions

  Answered 72 views 6 comments 0 points Most recent by BPeaslandDBA Jul 25, 2016 3:22PMDatabase Tuning (MOSC)
• are running Oracle 12c on Windows Server 12 R2.We have a pluggable database TESTPERS. I was monitori

  Answered 242 views 6 comments 1 point Most recent by 3230652 Jun 28, 2016 3:20PMDatabase Networking (MOSC)