IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

Database Resident Connection Pooling (DRCP) hands-on

Posted on January 28, 2022, updated on January 25, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • Database Resident Connection Pooling creation
  • Database Resident Connection Pooling testing
  • References

Continue reading

Oracle Administration, Development Leave a comment

Gradual Database Password Rollover hands-on

Posted on December 28, 2021, updated on December 14, 2021 by Yannick Jaquier

Table of contents

  • Preamble
  • Gradual Database Password Rollover testing

Continue reading

Oracle High Availability, Security Leave a comment

Secure Oracle application design and the ANY privileges

Posted on November 28, 2021, updated on November 23, 2021 by Yannick Jaquier

Table of contents

  • Preamble
  • The not so bad solution to avoid CREATE ANY TABLE
  • Oracle proxy user
  • Conclusion
  • References

Continue reading

Oracle Security Leave a comment

PHP OCI8 and PDO_OCI extensions installation to access Oracle

Posted on October 28, 2021, updated on October 25, 2021 by Yannick Jaquier

Table of contents

  • Preamble
  • OCI8 from pecl
  • PDO_OCI
  • OCI8 from PHP source
  • References

Continue reading

Linux, Oracle Development Leave a comment

DBMS_DATA_MINING package for Machine Learning inside the database

Posted on September 28, 2021, updated on September 27, 2021 by Yannick Jaquier

Table of contents

  • Preamble
  • Loading dataset
  • Dataset queries and charts
  • Model creation and testing
  • Conclusion
  • DBMS_PREDICTIVE_ANALYTICS all in one bonus package
  • References

Continue reading

Oracle Machine Learning Leave a comment

PostgreSQL graphical monitoring tools comparison

Posted on August 28, 2021, updated on May 8, 2023 by Yannick Jaquier

Table of contents

  • Preamble
  • pgAdmin
  • Postgres Enterprise Manager
    • Postgres Enterprise Manager Server
    • Postgres Enterprise Manager Agent
  • OmniDB
  • Percona Monitoring and Management
    • Server
    • Client
  • PGWatch
  • To be continued...
  • References

Continue reading

PostgreSQL Administration, Health Monitor Leave a comment
  • Page 4 of 38
  • « First
  • ‹ Previous
  • 2
  • 3
  • 4(current)
  • 5
  • 6
  • 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 (38) 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 (6) 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 (33) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) In-Memory (1) 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) 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) (1) Recovery (2) Redo Log (2) RMAN (5) Security (24) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (29) 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 (45) 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 (13)
  • mongoDB (1)
  • MySQL (25)
  • Oracle (140)
  • PostgreSQL (6)
  • Python (3)
  • SQL Server (8)

Recent Comments

  • PostgreSQL graphical monitoring tools comparison on How to use Docker to create a MariaDB sandbox for testing
  • 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

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