Journey to GPC. Part 2.

My next step was to try to install some open source software and I needed to install git SCM at first. Let's try to do that. My new terraform file looks like: provider "google" { project = "postgretrial" region = "us-central1" zone = "us-central1-c" } data "google_compute_default_service_account" "default" { } data "google_compute_image" "image-terra-io" { provider …

Journey to GPC by means of terraform

By this post I am starting to describe my newbye experience in Google Public Cloud journey. I am going to use terraform project (pre-installed on your Google Cloud shell by the way) as IaC solution. I have collected a set of pitfalls and met many fallacies which I want to share with you. I'll try …

Crunchydata PostgreSQL deployment on GKE step-by-step 2

Once you have crunchydata postgres-operator installed (as described in https://dmitryremizov.wordpress.com/2020/08/20/crunchydata-postgresql-deployment-on-gke-step-by-step/) it is time to configure a new database cluster.First of all you need to setup a pgo client. let's open your "cloud shell" for your new cluster (cluster-3 in my case). It is easy to do from Kubernetes Engine/Clusters page as show below In your …

Crunchydata PostgreSQL deployment on GKE step-by-step

This post is all about  https://www.crunchydata.com/ quite interesting open source project providing PostgreSQL database as managed service. Crunchy data offering exists on GCP (Google Public Cloud) and here I will describe how to set it up step by step from 1st time user perspective. First of all Crunchydata is a part(or partner) of Google Marketplace …

GDB Python API

I've recently realized that gdb have built-in python interface/API see here Debugging with GDB:Python API which can be extremely usefull in investigating Oracle internals. To use python API you need to print "python" keyword in GDB command prompt then any Python code of arbitrary complexcity, finally you should finish you Python subprogram with an "end" …

Once again about GDB

A really great post from Frits Hoogland has appeared recently How to obtain semaphore information in gdb when the symbols are missing. Methodology described there can be used much wide actually, not limited to standard libraries but rather you can apply really any structure on Oracle internal structures. I have tried to reproduce results of …

Session stats locations summary

Here I am publishing a location of pointer to session stats array (as offset from session address - v$session.saddr) for various Oracle versions: Oracle versionOffset of session stats pointerSome gdb command example 12.10x628 watch *(*(0x000000006AFD7830+0x628) +8*108) 12.2c0x820 watch *(*(0x000000006AFD7830+0x820) +8*108) 18.3c0x848 watch *(*(0x000000006AFD7830+0x848) +8*108) 19.30x7f8 watch *(*(0x000000006AFD7830+0x7f8) +8*108)  Those examples above show how to use …

Where session stats leave (algo since 12c)

This post is about methodology you can use to find out a location of session stats array (v$sesstat) given your session address in SGA. AS I shown in my previous posts session stats are located in some array. Here I will discuss a way to determine it for any version of Oracle in a few …

Cursors related parameters

1367 557 _row_cache_cursors 20 number of cached cursors for row cache management 1394 572 _cursor_features_enabled 2 Shared cursor features enabled bits. 1397 575 _cursor_stats_bucket 15 Hash table buckets for cursor stats (2^). 1398 576 _cursor_stats_heap 4 Heaps/latches for cursor stats. 1459 5B3 _fast_cursor_reexecute FALSE use more memory in order to get faster execution 1460 5B4 …

my BGOUG2019 presentation

Oracle12c_Snapshot_clone2_Ext