IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

LogMiner setup and investigation with Oracle 10g and above

Posted on June 2, 2010, updated on October 26, 2016 by Yannick Jaquier

Table of contents

  • Preamble
  • Instantiate LogMiner
  • How to get redo size
  • Redo log block size
  • References

Continue reading

Oracle Administration, Redo Log, SQL 2 Comments

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 11gR2, 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
  • Page 36 of 38
  • « First
  • ‹ Previous
  • 34
  • 35
  • 36(current)
  • 37
  • 38
  • Next ›
  • Last »

Search

Certifications

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

Categories

  • AIX (2)
  • Couchbase (2)
  • Hadoop (21)
  • HPUX (6)
  • Linux (29)
  • MariaDB (12)
  • mongoDB (1)
  • MySQL (24)
  • Oracle (138)
  • PostgreSQL (5)
  • Python (3)
  • SQL Server (7)

Recent Comments

  • Table and scalar SQL macros hands-on on Pipelined functions
  • R RAVEENDRA on Data Guard apply lag gap troubleshooting
  • Oracle OpenStack for Oracle Linux Release 2 in Virtualbox (1/2) on How to use Docker to create a MariaDB sandbox for testing
  • SQL Server on Linux – Log Shipping – part 4 on SQL Server on Linux – Failover Cluster Instances – part 2
  • vmckrish on Linux memory usage how to know what is used with basic commands

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