Postgres MV Fast Refresh

I had the pleasure on working on a fast refresh module for postgres something that is missing and we really needed for a project i was working on so in collaboration with AWS we managed to create this capability which is now in production and works very well, go take a read of the blog […]

Quicksight API

AWS have now put a nifty API behind quicksight so we can automatically create users, data-sources, data-sets, analysis, templates and dashboards all through the API. I will go through the api commands and show some demo’s of the commands Template Build  So we have test_list_demo analysis which has been built and we want to build a […]

S3 import into RDS Postgres

I wanted to test the functionality to pull S3 data into a Postgres RDS database so i’ve set-up a test that pulls a csv file from a s3 bucket into the RDS instance the RDS instance needs to have the s3Import feature set-up via a role, see the screen shot below  So we first create […]

PostgreSQL RDS snapshot to S3

A really nice new feature to RDS is the capability of taking a snapshot of your data to S3 and it being stored in parquet format, we have a use case to try and get insight to some of the data we have in our RDS database so a nice cheap risk free way of […]

Setting up Instance Caging

A great way to limit CPU on a shared database server is by using instance caging, below are the steps to implement instance caging. 1. Check to see if instance caging is enabled SQL> select name from v$rsrc_plan where is_top_plan = ‘TRUE’ and cpu_managed=’ON’; no rows selected Its not enabled 2. Set the CPU count Set the […]

Changing Default profile limits

How to change the default profile limits useful for setting the password life time to stop the password timing out and asking the user to change the password especially when applications are connecting to the DB. SYSTEM@WEBDB1> @qprofileEnter value for 1: DEFAULTold   1: select * from dba_profiles where profile =upper(‘&1’)new   1: select * from dba_profiles […]

Entering the world of blogging

Welcome to my blog, this is going to be a site dedicated to tools and tips for Oracle DBA’s! it will be mainly a place for me to store all my sql scripts I have created over the years but i’m sure they will be helpful to many a DBA.