IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

How to identify table fragmentation and remove it ?

Posted on December 18, 2018, updated on October 16, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • Legacy situation
  • Newest methods to estimate tables size
  • Table fragmentation identification
  • Move, shrink or export/import ?
  • References

Continue reading

Oracle SQL, Tuning 11 Comments

How to non intrusively find index rebuild or shrink candidates ?

Posted on November 23, 2018, updated on November 28, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • Legacy situation
  • Newest methods to estimate indexes size
  • Index rebuild candidates list
  • To go further
  • Rebuild or shrink ?
  • References

Continue reading

Oracle SQL, Tuning 3 Comments

Simple Oracle Document Access (SODA) installation and usage

Posted on November 1, 2018, updated on May 28, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • SODA setup
  • SODA testing
    • Collection creation/deletion
    • Managing document in a collection
  • References

Continue reading

Oracle Administration, SQL Leave a comment

Oracle REST Data Services (ORDS) installation and usage

Posted on October 8, 2018, updated on May 28, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • ORDS installation
  • ORDS setup
  • Automatic Enabling of Schema Objects for REST Access (AutoREST)
  • REST-Enabled SQL Service
  • Configuring Secure Access to RESTful Services
    • First Party Cookie-Based Authentication
    • Third Party OAuth 2.0-Based Authentication
  • ORDS uninstall
  • References

Continue reading

Oracle Administration, SQL 6 Comments

Application Continuity (AC) for Java – JDBC HA – part 6

Posted on September 13, 2018, updated on October 26, 2021 by Yannick Jaquier

Table of contents

  • Preamble
  • Application Continuity (AC) testing
  • Issues encountered
    • No more data to read from socket
    • Closed Connection
    • ORA-41412: results changed during replay; failover cannot continue
    • Diagnostics and Tracing
  • References

Continue reading

Oracle Application Continuity (AC), High Availability 1 Comment

Transaction Guard (TG) for Java – JDBC HA – part 5

Posted on August 27, 2018, updated on October 26, 2021 by Yannick Jaquier

Table of contents

  • Preamble
  • Transaction Guard (TG) testing
  • Issues encountered
  • References

Continue reading

Oracle High Availability, Transaction Guard (TG) 1 Comment
  • Page 10 of 38
  • « First
  • ‹ Previous
  • 8
  • 9
  • 10(current)
  • 11
  • 12
  • 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