Greenplum DBA Quick Reference

  • Installing Greenplum SNE (Single node edition) - Fedora/Ubuntu/Cent OS - For Step by Step Instruction visit https://sites.google.com/a/greenplumdba.com/gpdb/installing-the-greenplum-database
  • Dynamic UNIX script to change the owner of tables in Greenplum -- Change owner of all tables of a given schemafor tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" sachi` ; do  psql -c "alter table $tbl ...
    Posted Oct 26, 2014, 6:34 AM by Sachchida Ojha
Showing posts 1 - 1 of 13. View more »

Himanshu's Blog

  • Goroutines with closures You can use goroutines with closures, allowing you to run a program in the main thread and have your variables all set up and defined there, BUT then even if ...
    Posted Apr 10, 2016, 8:52 AM by Himanshu Ojha
Showing posts 1 - 1 of 1. View more »

  • Public Yum Server The Oracle public yum server offers a free and convenient way to install the latest Oracle Linux packages as well as packages from the Oracle VM installation media via a ...
    Posted Apr 22, 2013, 8:43 AM by Sachchida Ojha
  • Oracle external table just like external table in Greenplum In the Greenplum database, we use external table combined with gpfdist to read the data from a  csv file located in in a directory and then then load that data ...
    Posted Feb 23, 2013, 5:08 PM by Sachchida Ojha
  • RESUMABLE SPACE ALLOCATION Oracle database provides a way to suspend long-running operations in the event of space allocation failure. Once the DBA is notified and space issue has been corrected, the long ...
    Posted Feb 4, 2012, 12:01 AM by Sachchida Ojha
Showing posts 1 - 3 of 19. View more »
  • How to check if oracle instance is leaking memory 1] Use session statistics (to measure)The Oracle server maintains statistics that record the PGA and UGA memory consumption on a per session basis. If you suspect a memory leak ...
    Posted Sep 23, 2010, 1:57 PM by Sachchida Ojha
  • Archive location filled - How to set the archive log location to new location? conn "sys/pass as sysdba"show parameter log_archive_dest alter system set log_archive_dest_1="new loc" or alter system set db_recovery_file_dest="new loc";alter ...
    Posted Mar 22, 2011, 6:51 AM by Sachchida Ojha
Showing posts 1 - 2 of 14. View more »
  • Unix Command Reference for Oracle and PostgreSQL DBA's
  • Install flash plugin firefox - RHEL/Fedora 32bits surpm -ivh http://linuxdownload.adobe.com/adobe-release/adobe-release-i386-1.0-1.noarch.rpmrpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-adobe-linuxyum ...
    Posted May 22, 2013, 9:11 AM by Sachchida Ojha
  • Installing Open Office Suite in RHEL 6 Download open office using linkhttp://www.openoffice.org/download/After your download completes, Open Terminal and Execute the following… # tar xzf OOo_3.3.0_Linux_x86_install-rpm ...
    Posted Apr 22, 2013, 1:55 PM by Sachchida Ojha
Showing posts 1 - 2 of 11. View more »
  • Schema Check sum report set serveroutput onset feedback offset verify offset linesize 10000create or replace type chksumType as VARRAY(3000) of NUMBER;/declare  cursor c0 is    select OWNER, TABLE_NAME ...
    Posted Feb 22, 2013, 2:49 PM by Sachchida Ojha
  • User resource usage SELECT   DECODE(ses.username, NULL, 'SYS', ses.username) username,         TO_CHAR(ses.SID) SID, sn.NAME, sest.VALUE, ins.instance_name,         DECODE(ses.username, NULL, 'SYS', ses.username) || TO_CHAR ...
    Posted Sep 27, 2010, 6:38 AM by Sachchida Ojha
Showing posts 1 - 2 of 10. View more »
  • Configuring PostgreSQL on ORHEL6.1 -bash-4.1$ initdb -D /var/lib/pgsql/dataThe files belonging to this database system will be owned by user "postgres".This user must also own the server process ...
    Posted Apr 22, 2013, 5:47 AM by Sachchida Ojha
  • SECURITY DEFINER or AUTHID CURRENT USER I've just come to minor notice: PostgreSQL defaults to executing procedures with current user rights, Oracle - with definer's rights. It was rather interesting.Let's say we have ...
    Posted Apr 3, 2013, 5:54 PM by Sachchida Ojha
Showing posts 1 - 2 of 20. View more »
  • RECOVERY CATALOG :The recovery catalog is optional. If a The controlfile(s) of the target database are the sole repository of metadata if a recovery catalog is not used. A recovery catalog ...
    Posted Mar 18, 2011, 8:48 AM by Sachchida Ojha
Showing posts 1 - 1 of 2. View more »

Oracle RMAN - Tips and Tricks

  • Flash Recovery Area The Flash R ecovery Area: The flash recovery area (FRA) is not a requirement for using RMAN, but it should be. New in 10g, the FRA is a specific location ...
    Posted Jul 13, 2011, 9:28 AM by Sachchida Ojha
  • Auxiliary Database The auxiliary database refers to the instance that will become host to restored files from the target database in the event of a tablespace point-in-time recovery (TSPITR), a ...
    Posted Jul 12, 2011, 2:08 PM by Sachchida Ojha
  • The RMAN Server Processes RMAN makes a client connection to the target database, and two server processes are spawned. The primary process is used to make calls to packages in the SYS schema in ...
    Posted Jul 12, 2011, 1:55 PM by Sachchida Ojha
Showing posts 1 - 3 of 8. View more »