Free cookie consent management tool by TermsFeed

IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

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 August 29, 2024 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 August 6, 2024 by Yannick Jaquier

Table of contents

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

Continue reading

Oracle High Availability, Transaction Guard (TG) 1 Comment

Fast Connection Failover (FCF) – JDBC HA – part 4

Posted on August 7, 2018, updated on December 27, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • Fast Connection Failover (FCF) testing
    • Universal Connection Pool (UCP) for JDBC
    • Java testing code
    • Java testing code
  • References

Continue reading

Oracle Fast Connection Failover (FCF), High Availability 1 Comment
  • Page 16 of 44
  • « First
  • ‹ Previous
  • 14
  • 15
  • 16(current)
  • 17
  • 18
  • 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