• About Oracle
  Fast refreshable materialized view errors, part seven: a summary
  with errors materialized refreshable summary view
• Basic Materialized Views
  Using MV_CAPABILITIES_TABLE. DDL to create it for explaining feature availability, explain plan for materialized view
  with explain mv_capabilities_table plan
• bitmap join index tips
  bitmap join index tips and gotchas
  with bitmap burleson create index join tips
• Calculating ASM diskgroup Usable Size | OracleNext - Solution to your Oracle problems.
  select name, TOTAL_MB, FREE_MB, REQUIRED_MIRROR_FREE_MB, USABLE_FILE_MB from v$asm_diskgroup where group_number=2;
  with 11g asm diskgroup lsdg required_mirror_free_mb size total_mb usable vasm_diskgroup
• Configuring Authentication
  Proxy Users, Accessing client roles through other users
  with authentication configure oracle proxy users
• Creating Partitions
  Oracle VLDB partitioning guide 11g
  with 11g guide oracle partitioning vldb
• CVE security vulnerability database. Security vulnerabilities, exploits, references and more
  Common Vulnerabilities and Exploits
  with cve oracle security
• Data Pump - How to avoid exporting/importing jobs
  SELECT named, object_path, comments FROM schema_export_objects WHERE object_path LIKE 'JOB%' Named Object_path Comments NULL JOB Jobs in the selected schemas. If the Named column=Y, you can exclude the object type and if its null,you cannot.
  with database database_export_objects datapump exclude expdp export job named null schema schema_export_objects table table_export_objects
• Datatypes
  Datatypes built in to Oracle. Handy for understanding output of DUMP() function to ascertain data type, length, and actual value returned.
  with 11g datatypes dump function oracle
• DBA Tips Archive for Oracle
  Jeffrey Hunter Oracle 11gR2 RHEL6 install
  with 11g 11gr2 enterprise hat kernel linux manager memory oracle red rhel rhel6 setup tuning
• Format Models
  Oracle TO_DATE, TO_NUMBER, TO_CHAR with formats and examples
  with date format models oracle time to_char to_date to_number
• How do I force a query to use bind-aware cursor sharing? (Oracle Optimizer)
  How do I force a query to use bind-aware cursor sharing?
  with aware bind bind-aware cursor force query sharing
• How to “MAX” out your Fast Refresh Materialized Views - Blue Gecko
  DBMS_ADVISOR.TUNE_MVIEW,
  with dbms_advisor materialized max mv tune tune_mview view views
• How to get the last executed SQL statement and bind variable values in oracle
  Inspecting the bind variables for a given sql_id in Oracle 11g
  with bind sql_id v$sql_bind_capture variables
• How to stop a running job of DBMS_JOB ?
  Oracle Exclusive Mark it broken and commit
  with broken dbms_job mark oracle stop
• improving performance with pipelined table functions
  Excerpt on pipelined table functions from Feuerstein book on PL/SQL
  with billington developer functions merge object oracle performance pipelined plsql table type
• Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table? (Oracle Optimizer)
  strategies for gathering statistics DML new feature 11g; helpful for partitioned tables
  with 11g blog gathering incremental oracle partitioned statistics table tables
• Kerry Osborne’s Oracle Blog » Blog Archive » Flush A Single SQL Statement – Kerry Osborne’s Oracle Blog
  Flush A Single SQL Statement DBMS_SHARED_POOL.PURGE
  with advisor execution flush osborne plans single sql statement tuning
• Kerry Osborne’s Oracle Blog » Blog Archive » What Did My New Index Mess Up? – Kerry Osborne’s Oracle Blog
  find significantly different average elapsed times per execution. It uses AWR data and computes a normalized standard deviation between the average elapsed time per execution before and after the date specified by the days_ago parameter
  with 11g analysis awr changed index oracle performance snap snap_id sql_id statistics whats
• listagg function in 11g release 2
  Adrian Billington teaches listagg function with examples, GROUP BY , comparison of alternates to listagg, including WM_CONCAT and CAST with COLLECT
  with billington collect group listagg partition stragg within wm_concat

Bookmarks 1 - 20 Next »