For Cloud DBAs - AWS

For Cloud DBAs - AWS

Reading alert logs of RDS in AWS

How to read Alert and Listener logs from SQLPLUS
List RDS Details
Step to enable log retention policy for the RDS(Oracle) Instances
RDS Oracle Failover

Disk Usage for RDS Oracle

DevOps & SysOps

Useful links

https://marketplace.atlassian.com/categories/devops

Life, away from India !

Covid & Vaccination

Immigration to Australia

Baby Steps in Melbourne

Buying car in Australia


Singapore :-
Tips for Searching Jobs in Singapore

Australia:

tips for searching jobs in Australia

Application Security - Database (Oracle)

more links on Application Security - Database (Oracle)

General links (Life beyond Oracle)

Hadoop FAQ – But What About the DBAs?

A few pages For MongoDB

A few pages for Ingres (INteractive Graphics REtrieval System)

A few pages for PostgreSQL

A few pages For SQL SERVER

A few pages for Powershell

A few pages for MySQL

A few pages for AWS

Here are few links/ pages for new/beginner DBAs

System Administration/ Unix Scripts

Monitoring CPU output on Solaris and report in excel
tail and grep tools for DBA
Good Linux / Unix System Admin Commands for DBA
Check Hardware configuration of Linux Box
grep next / previous few lines of key word
Collect and report Linux System Activity Information with sar
cpu vs core vs sockets - calculation 
Useful Shell commands and Scripts

Oracle Golden Gate

 

Oracle DBA 

RAC , ASM

Check the distribution of session on all the nodes 

 

SQL, PL/SQL , Automation

useful SQLPLUS settings

Session related sqls

Change column width of show parameter in SQL Plus

Script for Health Check of Database 

Good collection of SQLs

To put all the datafiles of the database or a tablespace in autoextend mode
Move table and dependant LOB to other tablespace
Converting Numbers to millions and more ...
Historical growth of tablespace
for the 1st time database users - How to start the database
Adding name of the table in the output from multiple tables

Performance Tuning

Explain plan for SQLs

Get Table Details
Locks and Waits

mapping tables with sequences triggers
Analyzing a Statspack Report
Schedule snapshot collection in Statspack reports
Local Indexes for Partitioning
Check maximum memory utilization for oracle Database
Identify Top CPU / Memory intensive process and map to corresponding Oracle Process/ Session
Identify Oracle Process ID and related SQL
check fragmentation of table
Identify session waiting on enq: TX - row lock contention 
Identify Sessions using an Object/ many Objects 
Detection of Deadlock errors and investigation 

History of change in parameters

Historical growth of resource limit

General

Oracle DBA Interview Questions
Oracle 11gr2 Database Reference
Configure FGA ( Fine Grain Auditing)
Favorite Oracle Metalink Notes
Renaming table: How does that affect the associated objects?
How to read Alert and Listener logs from SQLPLUS
Resize datafile and enable autoextend
Check Object Inventory & recently created objects
Life Without AWR
Stopping Oracle Services on Windows
Startup failure ORA-00845: MEMORY_TARGET not supported on this system
Check Tablespace Utilisation

Export and import of data

Weblogic

FAILED_NOT_RESTARTABLE in WebLogic Server 11g

Peformance Testing

Load testing Tools Used -Grinder
How To Measure MySQL Query Performance with mysqlslap

Cloud Computing

This page captures the brief view of cloud services

Following are some commonly used terms:

Cloud Computing (wikipedia)

Broadly, servers, virtualisation software, networking and storage are required to form cloud. Following components form a complete cloud:

· Scalable, powerful and cheap servers

· Integrated, virtualised, and hugely scalable storage

· Virtualised 10GbE network switching infrastructure

· Fibre Channel over Ethernet capability to link servers and storage across Ethernet

· Disaster recovery capabilities

· Service-quality tracking and control

· Management of a virtualised data centre

Cloud architecture was used by Web 2.0 but due to changing economies more enterprises are adopting it due to its pay-per-usage model. Virtualization enables cloud to offer more services than cloud could do without

virtualization, e.g. PaaS.

Private Cloud

Smaller cloud than a conventional one. It is cloud like IT systems within a firewall offering similar services, but

to a closed internal network. A private cloud can be expanded to contain resources from within an enterprize (on premise) as well as from external cloud (off premise).

Public Cloud

Cloud available to anyone over the internet. Examples are, Amazon Elastic Compute Cloud (EC2), IBM's Blue Cloud, Sun Cloud, Google AppEngine and Windows Azure Services Platform.

Service Provider

Entity providing cloud services to others.

Subscriber

Entity consuming a cloud service.

Cloud Services

There are various cloud services:

Infrastructure as a Service (IaaS) (wikipedia)

Service user gets infrastructure to run application without spending on hardware (saving CapEx),
e.g. a configured VM.

Platform as a Service (PaaS) (wikipedia)

Service user gets platform to develop/run applications on cloud without spending on cloud infrastructure, e.g. Azure, Google AppEngine, Force.com

Software as a Service (SaaS) (wikipedia)

Service user gets a software to use without spending on software license and hardware, e.g. eXpresso, Google Apps

Storage as a Service (STaaS)

Service user gets storage to use without spending on storage hardware, e.g. Synaptic, Mozy, Box.net, also T-systems, BT, etc offer storage services for enterprizes.

NOTE: Synaptic service is offered by AT&T, a telco. It makes perfect sense for a telco to offer such a service because they already have network to deliver the service. So, they can offer better value for money for the subscribers.