IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

Active Session History visualization with Matplotlib and Altair

Posted on March 13, 2019, updated on April 19, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • Active Session History visualization with Altair
  • Active Session History visualization with Matplotlib
  • References

Continue reading

Oracle, Python Active Session History (ASH) 2 Comments

Jupyter Lab installation on Fedora to access an Oracle database

Posted on February 14, 2019, updated on October 28, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • Python 3.7 installation
  • Jupyter Lab installation
  • Jupyter Lab testing
  • References

Continue reading

Oracle, Python SQL 1 Comment

Minimum required privileges for PL/SQL debugging with SQL Developer

Posted on January 16, 2019, updated on January 16, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • PL/SQL debugging as object owner
  • PL/SQL debugging with another account
  • References

Continue reading

Oracle Security, SQL 2 Comments

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
  • Page 8 of 36
  • « First
  • ‹ Previous
  • 6
  • 7
  • 8(current)
  • 9
  • 10
  • 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

11gR2 (9) 12cR1 (6) Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (37) 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 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 Resource Manager (DBRM) (3) Database Vault (2) Data Guard (7) Data Recovery Advisor (2) Data Redaction (1) Development (3) Directory Naming (3) Docker (4) Fast Application Notification (FAN) (1) Fast Connection Failover (FCF) (1) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) GATHER_STATS_JOB (1) GoldenGate (3) Grid Control (4) Grub (1) Health Monitor (2) Heat Map (1) High Availability (28) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) Machine Learning (1) Multi-Master Replication Manager (MMM) (1) 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) Privilege Analysis (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (5) Real Application Testing (RAT) (1) Recovery (2) Redo Log (2) RMAN (5) Security (23) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (26) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (1) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (1) 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) Transaction Guard (TG) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (44) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

  • AIX (2)
  • Couchbase (2)
  • Hadoop (21)
  • HPUX (6)
  • Linux (29)
  • MariaDB (10)
  • mongoDB (1)
  • MySQL (24)
  • Oracle (137)
  • PostgreSQL (3)
  • Python (3)
  • SQL Server (3)

Recent Comments

  • Subash Raja C on Pacemaker configuration for an Oracle database and its listener
  • Subash Raja C on Pacemaker configuration for an Oracle database and its listener
  • Kubernetes on virtual machines hands-on – part 3 on UDEV to replace ASMLib on Red Hat 7 and OEL 7 for ASM configuration
  • Kubernetes on virtual machines hands-on – part 4 on Kubernetes on virtual machines hands-on – part 3
  • Kubernetes on virtual machines hands-on – part 3 on Kubernetes on virtual machines hands-on – part 2

Blogroll

  • Ask Tom
  • Data Virtualizer
  • Exile on Keyboard St. (French)
  • Kevin Closson’s Oracle Blog
  • MySQL Performance Blog
  • Official Pythian Blog
  • Oracle Optimizer
  • Oracle Scratchpad
  • Richard Foote’s Oracle Blog
  • Tanel Poder's blog
  • The Oracle Instructor

Visitors

Meta

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