Database Ideas - Ideas

Discussion List

• 
  29

  Up Down
  Write ECID to the tracefile when enabling Oracle Extended Trace

  Active Lasse Jenssen 260 views 1 comment 29 points Most recent by CaryMillsap Feb 1, 2019 10:21AM
• 
  2

  Up Down
  Enable Partition Extended Name to Gather Partition Statistics

  Active nemecj 34 views 0 comments 2 points Started by nemecj Jan 30, 2019 9:11AM
• 
  49
  Partitioned sequences to avoid hot block contention on indexes

  Delivered Franck Pachot 1.5K views 11 comments 49 points Most recent by Sven W. Jan 29, 2019 12:38PM
• 
  0

  Up Down
  column property BIND_AWARE to control ACS (adaptive cursor sharing)

  Active Rainer Stenzel 63 views 3 comments 0 points Most recent by Sven W. Jan 23, 2019 6:24AM
• 
  35

  Up Down
  Gather Statistics from Active Data Guard

  Active Franck Pachot 1.1K views 7 comments 35 points Most recent by Franck Pachot Jan 18, 2019 3:24PM
• 
  7

  Up Down
  new literal type: clob literal

  Active Sven W. 354 views 4 comments 7 points Most recent by William Robertson Jan 17, 2019 5:55AM
• 
  0

  Up Down
  Oracle database 12C

  Active User_N9EDK 16 views 1 comment 0 points Most recent by Billy Verreynne Jan 10, 2019 4:52AM
• 
  0

  Up Down
  Secure Link - File Sharing for Business

  Active dd9d59d3-2c2e-4ef7-aabd-75dc9787e363 2 views 0 comments 0 points Started by dd9d59d3-2c2e-4ef7-aabd-75dc9787e363 Jan 9, 2019 1:45AM
• 
  6

  Up Down
  IDEA: Top sessions associated with events on AWR

  Active Raul.Alvarenga 46 views 1 comment 6 points Most recent by ctrieb Jan 8, 2019 8:22AM
• 
  5

  Up Down
  changing DBID PDB Level

  Active Emad Al-Mousa 114 views 2 comments 5 points Most recent by Emad Al-Mousa Jan 7, 2019 12:45PM
• 
  -1

  Up Down
  Script to monitor FileSystems on Database Machine

  Active Raul.Alvarenga 9 views 2 comments -1 point Most recent by Raul.Alvarenga Jan 6, 2019 1:56PM
• 
  -1

  Up Down
  TIP: Avoid performance issues querying tablespaces information

  Active Raul.Alvarenga 12 views 1 comment -1 point Most recent by William Robertson Jan 6, 2019 6:08AM
• 
  6

  Up Down
  Make a RESYNC of RMAN Catalog Database Include Any On-Line Move of a Datafile

  Active User_24E47 53 views 0 comments 6 points Started by User_24E47 Jan 4, 2019 12:11PM
• 
  15

  Up Down
  Column create date in *_tab_cols

  Active Manik 5.3K views 14 comments 15 points Most recent by User_24E47 Jan 4, 2019 11:56AM
• 
  3

  Up Down
  Dump file import security restriction

  Active Emad Al-Mousa 78 views 3 comments 3 points Most recent by Emad Al-Mousa Jan 4, 2019 2:33AM
• 
  2

  Up Down
  JDBC XA Driver to identify itself correctly in SQL MODULE

  Active Simon Moore 16 views 0 comments 2 points Started by Simon Moore Dec 28, 2018 6:14AM
• 
  1

  Up Down
  Aggregate Function to Calculate a Hash Code for a Whole Table

  Active nemecj 2.7K views 9 comments 1 point Most recent by user1161496 Dec 20, 2018 11:01AM
• 
  17

  Up Down
  allow RETURNING clause via database link - ORA-22816

  Active Sven W. 8.6K views 7 comments 17 points Most recent by Sven W. Dec 13, 2018 7:30AM
• 
  11

  Up Down
  Add support for anonymous array types in SQL and PL/SQL

  Active Lukas Eder 285 views 4 comments 11 points Most recent by Lukas Eder Dec 5, 2018 10:27AM
• 
  1

  Up Down
  Optional FOR clause in PIVOT Statement

  Active nemecj 51 views 1 comment 1 point Most recent by Mike Kutz Dec 3, 2018 1:27PM
• 
  8

  Up Down
  Hint to enforce "temp segment merge"

  Active Lothar Flatz 223 views 0 comments 8 points Started by Lothar Flatz Dec 3, 2018 7:56AM
• 
  6

  Up Down
  CTAS with built-in Autodrop

  Active Matheus Boesing 203 views 5 comments 6 points Most recent by BEDE Nov 26, 2018 9:33AM
• 
  -6

  Up Down
  set transaction isolation level allow_dirty_reads?

  Active BEDE 60 views 3 comments -6 points Most recent by Billy Verreynne Nov 21, 2018 9:03AM
• 
  24

  Up Down
  Pass :old and :new pseudo-records in triggers as %rowtype to subprogram

  Active MortenBraten 2.5K views 3 comments 24 points Most recent by gaverill Nov 19, 2018 2:16PM
• 
  10

  Up Down
  Rename a DB Link in 12c (or 11.2.0.4)

  Active LudovicoCaldara 5.1K views 8 comments 10 points Most recent by Sven W. Nov 8, 2018 11:19AM