IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

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 9 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
  • Page 5 of 33
  • « First
  • ‹ Previous
  • 3
  • 4
  • 5(current)
  • 6
  • 7
  • Next ›
  • Last »

Search

Certifications

Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA)

Tags Cloud

11gR2 (9) 12cR1 (6) Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (31) 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 (6) Benchmark (7) Bug (1) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Database Links (1) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (7) Data Recovery Advisor (2) Data Redaction (1) Development (1) Directory Naming (3) Docker (4) 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 (1) Heat Map (1) High Availability (22) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (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) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (4) Real Application Testing (RAT) (1) Recovery (2) Redo Log (2) RMAN (5) Security (17) 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) 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 (20)
  • HPUX (6)
  • Linux (24)
  • mongoDB (1)
  • MySQL (32)
  • Oracle (127)
  • Python (2)
  • SQL Server (3)

Recent Comments

  • Yannick Jaquier on How to identify table fragmentation and remove it ?
  • Tony on How to identify table fragmentation and remove it ?
  • Yannick Jaquier on How to identify table fragmentation and remove it ?
  • Mike on How to identify table fragmentation and remove it ?
  • EL FEHYLY on ORA-00020: maximum number of processes (string) exceeded

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