Free cookie consent management tool by TermsFeed

IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

Script to generate series of awr reports

Posted on May 26, 2010, updated on June 4, 2019 by Yannick Jaquier

If you want to generate series of AWR reports, it is really boring to use the provided script awrrpt.sql as you have to launch it per each step of the interval. Following script automate this generation and will ask for the start and last snapshot and then generate all intermediate AWR reports.

Continue reading

Oracle Automatic Workload Repository (AWR) 3 Comments

Data compression with Oracle 11gR2

Posted on May 1, 2010, updated on December 1, 2017 by Yannick Jaquier

Table of contents

  • Preamble
  • Test table
  • Basic compression
  • OLTP compression
  • Hybrid columnar compression
  • Performance
  • References

Continue reading

Oracle Compression Leave a comment

Oracle Streams advanced configuration

Posted on April 28, 2010, updated on August 10, 2015 by Yannick Jaquier

Table of contents

  • Preamble
  • Manual add of a table
  • With the supplied Streams procedure
  • How to remove one table from Streams
  • References

Continue reading

Oracle Streams Leave a comment

Oracle Streams errors

Posted on April 21, 2010, updated on August 7, 2015 by Yannick Jaquier

Table of contents

  • Encountered Streams errors
  • ORA-01341
  • Capture forever in DICTIONARY INITIALIZATION state
  • MISSING Streams multi-version data dictionary!!!
  • Propagation disabled after 16 consecutive errors
  • Capture process in Paused For Flow Control
  • DBSNMP sessions consuming lots of CPU on monitored server
  • References

Continue reading

Oracle Streams Leave a comment

Oracle Streams in 5 minutes

Posted on April 16, 2010, updated on August 7, 2015 by Yannick Jaquier

Table of contents

  • Preamble
  • Streams basic configuration
    • Source database
    • Target database
  • Streams basic testing
  • Streams apply error correction
  • Streams monitoring
  • To remove Streams configuration
  • References

Continue reading

Oracle Streams 3 Comments

Oracle Automatic Shared Memory Management (ASMM)

Posted on April 9, 2010, updated on January 14, 2014 by Yannick Jaquier

Oracle Automatic Shared Memory Management (ASMM) is a new 10g great functionality but beyond just setting the parameters in initialization parameter file you could be disappointed with what you can easily see with Grid Control.

sga-breakdown
sga-breakdown

Continue reading

Oracle Automatic Shared Memory Management (ASMM) Leave a comment
  • Page 42 of 44
  • « First
  • ‹ Previous
  • 40
  • 41
  • 42(current)
  • 43
  • 44
  • Next ›
  • Last »

Search

Certifications

Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA)
Microsoft Azure Fundamentals Microsoft Azure Solutions Architect Expert

Tags Cloud

Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (42) Ambari (1) Application Continuity (AC) (1) Automatic Data Optimization (ADO) (1) Automatic Diagnostic Repository (ADR) (1) Automatic Memory Management (AMM) (2) Automatic Segment Space Management (ASSM) (1) Automatic Shared Memory Management (ASMM) (4) Automatic SQL Plan Management (ASPM) (1) Automatic SQL Tuning Sets (ASTS) (1) Automatic Storage Management (ASM) (2) Automatic Workload Repository (AWR) (3) Backup (7) Benchmark (7) Bug (1) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Container (4) Database Links (1) Database Migration Assistant for Unicode (DMU) (2) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (9) Data Recovery Advisor (2) Data Redaction (1) DBMS_REDEFINITION (1) Development (12) Directory Naming (3) Docker (4) Edition-Based Redefinition (EBR) (1) Exadata (1) Fast Application Notification (FAN) (1) Fast Connection Failover (FCF) (1) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) Galera (3) GATHER_STATS_JOB (1) GoldenGate (6) Grid Control (4) Grub (1) Health Monitor (2) Heat Map (1) High Availability (35) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) In-Memory (1) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) JSON (1) Kafka (3) Machine Learning (1) Multi-Master Replication Manager (MMM) (1) Multitenant (5) Non-Uniform Memory Access (NUMA) (3) OpenStack (2) OpenView Performance Agent (OVPA) (1) Oracle Configuration Manager (OCM) (1) Oracle Label Security (OLS) (1) oradebug (1) Patch (2) PL/SQL (1) Polymorphic Table Functions (PTF) (1) Privilege Analysis (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (5) Real Application Testing (RAT) (2) Recovery (2) Redo Log (2) Resource Governor (1) RMAN (5) Security (27) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (36) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (2) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (2) SQL Profile (1) SQL Trace (1) SQL Tuning Advisor (STA) (5) SQL Tuning Set (STS) (1) Streams (3) System Global Area (SGA) (1) Tivoli Data Protection for Oracle (TDPO) (2) Tivoli Storage Manager (TSM) (1) Transactional Event Queues (TxEventQ) (1) Transaction Guard (TG) (1) Transparent Application Continuity (TAC) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (54) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

  • AIX (2)
  • Couchbase (2)
  • Databricks (5)
  • Hadoop (21)
  • HPUX (6)
  • Linux (30)
  • MariaDB (20)
  • MongoDB (1)
  • MySQL (30)
  • Oracle (156)
  • PostgreSQL (8)
  • Python (3)
  • SQL Server (11)

Recent Comments

  • SQL Access Advisor and SQL Tuning Advisor in 11gR2 on SQL Access Advisor versus SQL Tuning Advisor
  • Adaptive Query Optimization in action on Cardinality feedback to automatically improve query plans
  • MySQL Utilities versus Master High Availability Manager (MHA) on MySQL Replication with Global Transaction Identifiers (GTID) hands-on
  • geek on SQL Server on Linux – Availability Groups – part 3
  • sai sumanth on SQL Server on Linux – Availability Groups – part 3

Blogroll

  • Ask Tom
  • Kevin Closson’s Oracle Blog
  • Official Pythian Blog
  • Oracle Optimizer
  • Oracle Scratchpad
  • Percona Database Performance Blog
  • Richard Foote’s Oracle Blog
  • Tanel Poder's blog

Visitors

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
IT World Proudly powered by WordPress