performance

Discussion List

• 
  How to rewrite the cursor query by removing the OR clause in where conditiion ?

  Solution Accepted gg 42 views 9 comments 0 points Most recent by Paulzip Apr 13, 2022 8:28AMSQL & PL/SQL
• 
  Oracle Spatial index creation and index options

  Solution Accepted Laury 8 views 1 comment 0 points Most recent by Hviehman-Oracle Apr 4, 2022 4:59PMOracle Graph
• 
  SQL Dev connection properties display very slow

  Responded But No Solution user637881 993 views 3 comments 0 points Most recent by User_R84QF Mar 14, 2022 1:39PMSQL Developer
• 
  Delete a large amount of data on Partition

  Responded But No Solution User_SWR12 21 views 3 comments 0 points Most recent by Solomon Yakobson Mar 11, 2022 11:24PMSQL Developer
• 
  Where to find EXTENTS and SEGMENTS of a table

  Responded But No Solution Yockee 585 views 12 comments 0 points Most recent by Jonathan Lewis Mar 9, 2022 2:23PMGeneral Database Discussions
• 
  Query gets hanged during first of month

  Responded But No Solution User_DDYV1 31 views 8 comments 0 points Most recent by User_DDYV1 Mar 3, 2022 10:56PMGeneral Database Discussions
• 
  How to check if a procedure is currently running with a specific parameter

  Solution Accepted rjsosi 484 views 14 comments 0 points Most recent by rjsosi Feb 22, 2022 10:57PMSQL & PL/SQL
• 
  Help with performance tuning of query with multiple left joins

  Responded But No Solution user8170666 762 views 3 comments 0 points Most recent by user8170666 Feb 15, 2022 9:58AMSQL & PL/SQL
• 
  Partition pruning and TRUNC function

  Solution Accepted Hesh 430 views 3 comments 0 points Most recent by Hesh Feb 3, 2022 1:31PMSQL & PL/SQL
• 
  Can we convert this case statement to decode to calculate the shift timings in oracle sql?

  Responded But No Solution gg 86 views 8 comments 0 points Most recent by Solomon Yakobson Jan 26, 2022 12:16PMSQL & PL/SQL
• 
  How do we know that the cost of a sql query is high ?

  Responded But No Solution gg 1.1K views 3 comments 0 points Most recent by Billy Verreynne Jan 26, 2022 8:59AMSQL & PL/SQL
• 
  How much maximum RAM is used by Oracle XE ?

  Solution Accepted User_C3D23 265 views 6 comments 0 points Most recent by EdStevens Jan 15, 2022 3:16PMGeneral Database Discussions
• 
  Partition vs Bitmap

  Responded But No Solution User_JNHXJ 45 views 5 comments 0 points Most recent by Mike Kutz Jan 4, 2022 6:30PMGeneral Database Discussions
• 
  Execution plans in AWR

  Responded But No Solution Justin Bleistein 52 views 2 comments 0 points Most recent by Justin Bleistein Dec 18, 2021 12:08AMGeneral Database Discussions
• 
  Create Global Index on Interval partitioned tables

  Responded But No Solution User_NY02I 151 views 4 comments 0 points Most recent by User_NY02I Dec 3, 2021 6:10AMGeneral Database Discussions
• 
  Huge performance drop after upgrading from 12c o 19c

  Responded But No Solution user8740803 5.4K views 1 comment 0 points Most recent by user8740803 Nov 22, 2021 9:52AMDatabase Upgrade
• 
  I am facing memory leak issue in my java application. I have used sonarqube to find the leaks.

  Question User_C7QJP 144 views 0 comments 0 points Started by User_C7QJP Nov 11, 2021 10:07AM Java Programming