tuning

Discussion List

• 
  Where to find EXTENTS and SEGMENTS of a table

  Responded But No Solution Yockee 41 views 12 comments 0 points Most recent by Jonathan Lewis Mar 9, 2022 2:23PMGeneral Database Discussions
• 
  How to check if a procedure is currently running with a specific parameter

  Solution Accepted rjsosi 203 views 14 comments 0 points Most recent by rjsosi Feb 22, 2022 10:57PMSQL & PL/SQL
• 
  Same Date column picking filter and access predicates in execution plan - how to avoid the filter?

  Responded But No Solution User_WCGX4 42 views 5 comments 0 points Most recent by Jonathan Lewis Jan 28, 2022 10:41AMSQL & PL/SQL
• 
  ORA-13785 while running DBMS_SQLTUNE.REPORT_TUNING_TASK

  Question User_AOUZ4 11 views 0 comments 0 points Started by User_AOUZ4 Jan 10, 2022 2:38PM General Database Discussions
• 
  "control file parallel write" wait event occurs too frequent on BLOB operations

  Solution Accepted user12024388 40 views 3 comments 0 points Most recent by Jonathan Lewis Dec 30, 2021 10:55AMGeneral Database Discussions
• 
  Do WRH$_* views (ACTIVE SESSION HIST, SQLTEXT etc.) record *all* statements executed at least once?

  Responded But No Solution Sebino 11 views 1 comment 0 points Most recent by saratpvv Dec 26, 2021 12:44PMGeneral Database Discussions
• 
  10053 trc file showing hidden params with another value than that which is set at DB level

  Responded But No Solution Sebino 31 views 12 comments 0 points Most recent by Jonathan Lewis Dec 20, 2021 12:25PMGeneral Database Discussions
• 
  Removing histogram on a (very skewed) column makes query incommensurably quicker

  Responded But No Solution Sebino 43 views 14 comments 0 points Most recent by cormaco Dec 10, 2021 11:02AMGeneral Database Discussions
• 
  From 10046 trc file to tkprof Parse/Exec/Fetch and count/cpu/ela... table

  Solution Accepted Sebino 11 views 2 comments 0 points Most recent by Sebino Dec 8, 2021 12:42PMGeneral Database Discussions
• 
  enq: SQ - contention -

  Responded But No Solution 0614 51 views 4 comments 0 points Most recent by Jonathan Lewis Nov 18, 2021 9:40AMGeneral Database Discussions
• 
  Java G1 Tuning Impacts - Multiple JVMs on Host

  Question User_U6GUE 11 views 0 comments 0 points Started by User_U6GUE Aug 19, 2021 4:59PM Java Essentials
• 
  Find Logical Reads cause

  Solution Accepted User_DUYMH 21 views 3 comments 0 points Most recent by mathguy Aug 11, 2021 4:56AMSQL & PL/SQL
• 
  Necessary privileges to use dbms_sqltune

  Responded But No Solution Laury 32 views 9 comments 0 points Most recent by Laury Jul 29, 2021 1:40PMGeneral Database Discussions
• 
  Creating a SQL Profile with dbms_sqltune

  Responded But No Solution Laury 11 views 2 comments 0 points Most recent by Laury Jul 17, 2021 9:11AMGeneral Database Discussions
• 
  Query takes twice as long in DB with huge difference in 'current' and 'disk' columns

  Responded But No Solution Sebino 42 views 9 comments 0 points Most recent by User_GSQTY Jun 26, 2021 2:03PMGeneral Database Discussions
• 
  Select from DBMS_XPLAN.DISPLAY_AWR and from DBA_HIST_SQL_PLAN does not show same stuff

  Solution Accepted Sebino 12 views 1 comment 0 points Most recent by Jonathan Lewis Jun 24, 2021 1:03PMGeneral Database Discussions
• 
  Query takes twice as long on DB than others with huge 'direct path read|write temp' waits

  Solution Accepted Sebino 26 views 4 comments 0 points Most recent by Sebino Jun 22, 2021 10:41AMGeneral Database Discussions
• 
  Query tuning

  Responded But No Solution User_R4VJD 22 views 1 comment 0 points Most recent by Frank Kulash Jun 9, 2021 10:30PMSQL & PL/SQL
• 
  Improve View Merging

  Question User_3DSZW 11 views 0 comments 0 points Started by User_3DSZW Jun 4, 2021 9:12AM General Database Discussions