Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Petre Radut

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Oracle | No Comments

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show parameter undo; NAME TYPE VALUE ———————————— ———– —————————— temp_undo_enabled boolean FALSE undo_management string AUTO undo_retention integer 3600 –extended from 900, undo_tablespace string UNDOTBS1 But, are some scenarios where the above rule is not working . We…

Read More
Stephane Biehler
IMG_22

OpenText Enterprise World Europe 2019 – Day 3

By | Application integration & Middleware, Cloud, Database Administration & Monitoring | No Comments

Last but not least, today was mainly dedicated to demos and customer cases. It started with the global stream presenting some OpenText applications like Core for Quality: An application developed with AppWorks and integrated to Magellan. It was meant to manage quality issues and connected to Documentum in order to link issues with SOP documents. In the different demos we saw the integration of these SaaS applications in OT2 and their responsiveness (drag and drop…

Read More
Stephane Biehler
hallpano

OpenText Enterprise World Europe 2019 – Day 2

By | Application integration & Middleware, Cloud, Database Administration & Monitoring | No Comments

Day 2 of OTEW, we followed the global stream this morning which was taking most of the points from yesterday. But we had the pleasure to have a session from Dr. Michio Kaku, Theoretical Physicist, Futurist and popularizer of science. He wrote several books about physics and how he sees the future. He sees us in the next 20 years ultra connected with internet lenses, the Moore’s law will collapse in 2025 where it will…

Read More
David Barbarin

Upgrading SQL Server pods on K8s and helm charts

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes, SQL Server | No Comments

It has been while since my last blog. Today it is about continuing with helm charts and how to upgrade / downgrade SQL Server containers to a specific cumulative update. My first write-up in my to-do list. Last year, I wrote an introduction of SQL Server containers on K8s. I remembered to face some issues when testing upgrade scenarios (probably a lack of knowledge). Since then, I have discovered helm charts and I use them…

Read More
Stéphane Haby

SQL Server Temporal Table – How to store a history table in another file?

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Few days ago, a customer asks me if it is possible to move the history table to slower but cheaper storage. The question behind this is whether it is possible to create a history table on a separate filegroup and file. Few years ago, I write a serie of blogs about temporal table here. I will take the same example to try to set up a filegroup specific to a history table. In my sample,…

Read More
Jérôme Dubar

How to patch your ODA lite to 18.3.0.0.0

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Even you don’t need 18c, or you’re not ready for this release, this patch will also update your 11gR2, 12cR1 and 12cR2 databases to the latest PSU available on ODA, it means for example the patchset from last July if you’re using 12cR1. Here is how to apply this latest patch for your ODA lite. In this example, the patch was applied on an X6-2S ODA running on previous release: 12.2.1.4.0. 1) Download the patch…

Read More
Michael Hein

How to extract sql statements with awk

By | Database Administration & Monitoring | No Comments

A common problem is to extract sql statements out of a sql file e.g. produced by full metadata impdp. Often these files are too big to be edited with vi. Following statement extracts all sql statements with “CREATE MATERIALIZED VIEW” at the beginning with awk: cat impdp_full_metadata.sql | awk ‘BEGIN{ FLAG = 0 } { if( $0 ~ /CREATE MATERIALIZED VIEW/ ) FLAG=1; if(FLAG != 0) print $0; if ($0 ~ /;/ ) FLAG=0; }’…

Read More
Mouhamadou Diaw

PostgreSQL 12: New option –exclude-database for pg_dumpall

By | Database Administration & Monitoring, Postgres | No Comments

Up to PostgreSQL 11 pg_dump all was used to dump all PostgreSQL databases of a cluster into one script file. The script file then contains SQL commands that can be used as input to psql to restore the databases. It does this by calling pg_dump for each database in the cluster. PostgreSQL 12 is under development but we can test new features which will be implemented. Now with PostgreSQL 12 there is a new option…

Read More
Michael Hein

How to disable ACLs in Oracle 12c

By | Database Administration & Monitoring | No Comments

A common problem in Oracle 12c is, that ACLs are often not wanted to limit connections from database to other hosts. To disable ACLs is not that easy, so the best way is to enable connections and resolutions to all hosts for all users like following example: BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => ‘*’, ace => xs$ace_type(privilege_list => xs$name_list(‘resolve’), principal_name => ‘PUBLIC’, principal_type => xs_acl.ptype_db)); DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => ‘*’, ace => xs$ace_type(privilege_list => xs$name_list(‘connect’), principal_name => ‘PUBLIC’,…

Read More
Marc Wagner

How workload policies is making your life easy

By | Database Administration & Monitoring | No Comments

Working as a control-M administrator, we are often requested to hold jobs or stop jobs during a period of time. Holding jobs and updating the job configuration might not be the most efficient way to do this. Workload policies is making your life really easier, giving you the possibility to configure such modification in advance and to let the system act independently whether the NDP (New Day Processing) is in the middle of the period…

Read More