• Inside the Oracle Optimizer - Removing the black magic
  Improvement of AUTO sampling statistics gathering feature in Oracle 11g
  with 11g auto feature gathering improvement oracle sampling statistics
• Is Oracle Smart Flash Cache a "SPOF"?
  Official Pythian® Blog
  with 11r2 12c blog cache flash official oracle pythian smart
• LISTAGG
  Decent Example of LISTAGG
  with analytic columns concatenation function listagg sql
• Maintaining statistics on large partitioned tables (Oracle Optimizer)
  large tables with partitions where statistics incrementally change may help with loading.
  with 10g 11g gathering incremental ndv oracle partitions statistics stats
• Making consistent datapump exports in 11g
  Consistent datapump exports
  with consistent datapump expdp export flashback
• Oracle
  Difference between two Timestamps, in seconds… | Caffeine Induced
  with arithmetic between interval plsql seconds sql timestamps
• oracle 11g - Rename interval partitioning system generated partition names - Database Administrators Stack Exchange
  Rename interval partitioning system generated partition names
  with - 11g generated interval names oracle partition partitioning plsql rename system
• Oracle 11g R2 VLDB - Partitioning Concepts
  Partitioning for Performance
  with 11gr2 joins partition partitioning performance pruning
• Oracle DBMS_SYSTEM
  get environment variables from inside PL/SQL
  with dbms_system environment oracle package unix variable
• Oracle related stuff: Extended DISPLAY_CURSOR With Rowsource Statistics
  Extended DISPLAY_CURSOR With Rowsource Statistics
  with display_cursor extended oracle plans rowsource statistics
• ORACLE-BASE
  Detect And Correct Corruption in Oracle
  with correct corruption oracle v$ view
• ORACLE-BASE - Instance Caging to Manage CPU Usage in Oracle Database 11g Release 2
  Managing CPU usage can be an issue when trying to consolidate multiple databases on to a single server, because if one database starts to hog all the CPU on the server, all the other databases will be affected
  with 11gr2 aio asynch asynchronous count cpu cpu_count databases io managing multiple oracle parameter server
• ORACLE-BASE - Segment Creation on Demand (Deferred Segment Creation) in Oracle Database 11g Release 2
  Segment Creation on Demand (Deferred Segment Creation) in Oracle Database 11g Release 2
  with 11g creation database deferred demand release segment tables
• Partitioning for Availability, Manageability, and Performance
  VLDB Partition Pruning Oracle high level insight
  with availability high oracle partitioning partitions pruning vldb
• PL/SQL Static SQL
  CURSOR Expressions in PL/SQL 11gR2 application development, including REF_CURSORS, cursor subqueries, FETCH
  with cursor expressions ref
• Pythian Group
  Oracle FAQ
  with all bloom filters good not
• Reclaiming Wasted Space Oracle 11g Viewing Segment Advisor Results
  Segment space advisor, DBA_RECOMMENDATIONS shrink compact savings
  with actions advisor compact dba_recommendations index management oem segment segments shrink space table tablespaces views
• Renaming Tablespaces
  with alter new_ts old_ts rename tablespace to
• Send Email Notifications From DBMS_SCHEDULER Job | My Oracle Rants
  Send Email Notifications From DBMS_SCHEDULER Job
  with dbms dbms_scheduler email job notifications package send
• This explains the most common cause of the ORA-30926 and how to fix it
  MacLochlainns Weblog
  with merge message ora ora-30926 rows stable

Bookmarks 61 - 80 « Previous Next »