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 … Continue reading Journey to GPC. Part 2.

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 … Continue reading Journey to GPC by means of terraform

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 … Continue reading Crunchydata PostgreSQL deployment on GKE step-by-step 2

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 … Continue reading Crunchydata PostgreSQL deployment on GKE step-by-step

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 … Continue reading Session stats locations summary

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 … Continue reading Cursors related parameters