tuning

Discussion List

• 
  Query takes twice as long in DB with huge difference in 'current' and 'disk' columns

  Question Sebino 5 views 0 comments 0 points Started by Sebino 10:06AM General Database Discussions
• 
  Select from DBMS_XPLAN.DISPLAY_AWR and from DBA_HIST_SQL_PLAN does not show same stuff

  Question Sebino 7 views 0 comments 0 points Started by Sebino Jun 23, 2021 1:28PM General Database Discussions
• 
  Query takes twice as long on DB than others with huge 'direct path read|write temp' waits

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

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

  Question User_3DSZW 13 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 49 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 16 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 70 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 26 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 21 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 31 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 308 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 61 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 202 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 217 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 436 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 52 views 1 comment 0 points Most recent by fac586 Jun 14, 2019 5:41PMAPEX Discussions
• 
  session lived synonym

  Solution Accepted Dmitrii Dunaev 164 views 16 comments 1 point Most recent by Dmitrii Dunaev May 22, 2019 12:17PMSQL & PL/SQL
• 
  failed name resolution extremely slow on 18.3 (EZCONNECT)

  Responded But No Solution Sven W. 416 views 16 comments 1 point Most recent by Sven W. Mar 15, 2019 2:04PMGeneral Database Discussions
• 
  Oracle partition wise join

  Responded But No Solution Closed Sekar_BLUE4EVER 323 views 13 comments 1 point Most recent by Mohamed Houri Jun 13, 2018 5:00AMGeneral Database Discussions
• 
  Join predicate pushing

  Solution Accepted Closed Sekar_BLUE4EVER 273 views 11 comments 1 point Most recent by Jonathan Lewis Apr 19, 2018 10:44AMGeneral Database Discussions
• 
  Reading Row Counts on an Explain Plan Clarify.

  Solution Accepted Closed Tater_Salad 707 views 24 comments 1 point Most recent by Jonathan Lewis Apr 2, 2018 1:57PMSQL & PL/SQL
• 
  Limiting "OR expansion" using use_concat

  Responded But No Solution Closed Sekar_BLUE4EVER 172 views 2 comments 0 points Most recent by Sekar_BLUE4EVER Mar 29, 2018 3:47AMGeneral Database Discussions