tuning

Discussion List

• 
  enq: SQ - contention -

  Responded But No Solution 0614 53 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 12 views 0 comments 0 points Started by User_U6GUE Aug 19, 2021 4:59PM Java Essentials
• 
  Find Logical Reads cause

  Solution Accepted User_DUYMH 23 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 21 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 13 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 41 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 11 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 22 views 4 comments 0 points Most recent by Sebino Jun 22, 2021 10:41AMGeneral Database Discussions
• 
  Query tuning

  Responded But No Solution User_R4VJD 21 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
• 
  What is the optimal way for reading the huge data from oracle DB?

  Responded But No Solution User_CK8A6 372 views 6 comments 0 points Most recent by BluShadow May 14, 2021 10:52AMSQL & PL/SQL
• 
  Difference between dba_tables.last_analyzed and dba_tab_stats_history.stats_update

  Question hob 11 views 0 comments 0 points Started by hob May 11, 2021 12:59PM General Database Discussions
• 
  Cursor Invalidation is not working in Oracle 19c

  Solution Accepted sabyakgp 214 views 4 comments 0 points Most recent by Rainer Stenzel Apr 15, 2021 7:46AMSQL & PL/SQL
• 
  Forall delete with rowid- top wait event - db file sequential read further optimization

  Responded But No Solution user591200 23 views 3 comments 0 points Most recent by Jonathan Lewis Mar 30, 2021 6:52PMGeneral Database Discussions
• 
  why index is not used for the inequality ( <>, != )condition in where clause?

  Responded But No Solution Ramkumar M 25 views 1 comment 0 points Most recent by Luís Gustavo Lira Mar 10, 2021 11:39PMWorkshops
• 
  FAST materialized view refresh Vs Oracle Golden Gate. Which is better and cost effective ?

  Responded But No Solution User_6AJ1Z 44 views 1 comment 0 points Most recent by Paulzip Feb 18, 2021 4:56PMSQL & PL/SQL
• 
  How to solve buffer busy waits due to Concurrent INSERTS?

  Solution Accepted 0614 852 views 5 comments 0 points Most recent by Jonathan Lewis Nov 28, 2020 5:19PMSQL & PL/SQL
• 
  log file sync and block recovery from logseq

  Responded But No Solution User_96XRQ 67 views 3 comments 0 points Most recent by User_96XRQ Nov 5, 2020 3:01PMGeneral Database Discussions
• 
  Data staging tables instead of flat files

  Responded But No Solution User_OKMG9 275 views 11 comments 2 points Most recent by User_OKMG9 Jan 27, 2020 11:20AMGeneral Database Discussions
• 
  Explain Plan Better using Literals vs Bind Variables ... odd!

  Responded But No Solution Duncs 353 views 14 comments 5 points Most recent by Sven W. Jul 25, 2019 9:44AMSQL & PL/SQL
• 
  help with sql monitor report

  Solution Accepted kaericn 440 views 21 comments 1 point Most recent by AndrewSayer Jul 11, 2019 2:51AMSQL & PL/SQL
• 
  Where is APEX 4.x app SQL Perf bottleneck graph?

  Solution Accepted rocket_man 54 views 1 comment 0 points Most recent by fac586 Jun 14, 2019 5:41PMAPEX Discussions
• 
  session lived synonym

  Solution Accepted Dmitrii Dunaev 168 views 16 comments 1 point Most recent by Dmitrii Dunaev May 22, 2019 12:17PMSQL & PL/SQL