RAMSHANKARMG.BLOGSPOT.COM

Ramshankar MG

Tuesday, August 4, 2015. Shell Script to generate Hourly AWR Report. Echo Syntax awr report.sh ORACLE SID. Oraapp/oracle/tools/scripts/crontab.env ${l sid} myDate=`date " %m%d%Y"` myHour=`date " %H"` l start time=`sqlplus -s '/ as sysdba'. Usr/bin/rm ${l logdir}/awrrpt ${l sid} * l awr log file=${l logdir}/awrrpt ${l sid} ${l starttime log}.html. Sqlplus -s '/ as sysdba'. Sqlplus -s '/ as sysdba'. Select to char(sysdate -1,'mm/dd/yy mm:ss') "End of AWR two" from dual;. Echo "mime-version: 1.0". ORA-06512...

http://ramshankarmg.blogspot.com/

OVERVIEW OF ramshankarmg.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR RAMSHANKARMG.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

May

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.9 out of 5 with 12 reviews

5 star

6

4 star

1

3 star

4

2 star

0

1 star

1

Hey there! Start your review of ramshankarmg.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.1 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT RAMSHANKARMG.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

0

SITE IP

173.194.46.107

LOAD TIME

0.141 sec

SCORE

6.2

PAGE TITLE

Ramshankar MG | ramshankarmg.blogspot.com Reviews

<META> DESCRIPTION

Tuesday, August 4, 2015. Shell Script to generate Hourly AWR Report. Echo Syntax awr report.sh ORACLE SID. Oraapp/oracle/tools/scripts/crontab.env ${l sid} myDate=`date %m%d%Y` myHour=`date %H` l start time=`sqlplus -s '/ as sysdba'. Usr/bin/rm ${l logdir}/awrrpt ${l sid} * l awr log file=${l logdir}/awrrpt ${l sid} ${l starttime log}.html. Sqlplus -s '/ as sysdba'. Sqlplus -s '/ as sysdba'. Select to char(sysdate -1,'mm/dd/yy mm:ss') End of AWR two from dual;. Echo mime-version: 1.0. ORA-06512...

<META> KEYWORDS

1 ramshankar mg

2 oracle dba

3 sociable

4 usr/bin/ksh

5 if $#

6 then

7 exit

8 l sid=$1

9 set linesize 300

10 set echo off

CONTENT

Page content here

KEYWORDS ON PAGE

ramshankar mg,oracle dba,sociable,usr/bin/ksh,if $#,then,exit,l sid=$1,set linesize 300,set echo off,set head off,set feed off,rm tmpscr1 sql,spool tmpscr1 sql,tmpscr1 sql,cd ${l logdir},echo,echo xxxrandomatingxxx,echo hello,echo dba team,posted by

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Ramshankar MG | ramshankarmg.blogspot.com Reviews

https://ramshankarmg.blogspot.com

Tuesday, August 4, 2015. Shell Script to generate Hourly AWR Report. Echo Syntax awr report.sh ORACLE SID. Oraapp/oracle/tools/scripts/crontab.env ${l sid} myDate=`date " %m%d%Y"` myHour=`date " %H"` l start time=`sqlplus -s '/ as sysdba'. Usr/bin/rm ${l logdir}/awrrpt ${l sid} * l awr log file=${l logdir}/awrrpt ${l sid} ${l starttime log}.html. Sqlplus -s '/ as sysdba'. Sqlplus -s '/ as sysdba'. Select to char(sysdate -1,'mm/dd/yy mm:ss') "End of AWR two" from dual;. Echo "mime-version: 1.0". ORA-06512...

INTERNAL PAGES

ramshankarmg.blogspot.com

1

Ramshankar MG: Shell Script to generate Hourly AWR Report

http://ramshankarmg.blogspot.com/2015/08/shell-script-to-generate-hourly-awr.html

Tuesday, August 4, 2015. Shell Script to generate Hourly AWR Report. Echo Syntax awr report.sh ORACLE SID. Oraapp/oracle/tools/scripts/crontab.env ${l sid} myDate=`date " %m%d%Y"` myHour=`date " %H"` l start time=`sqlplus -s '/ as sysdba'. Usr/bin/rm ${l logdir}/awrrpt ${l sid} * l awr log file=${l logdir}/awrrpt ${l sid} ${l starttime log}.html. Sqlplus -s '/ as sysdba'. Sqlplus -s '/ as sysdba'. Select to char(sysdate -1,'mm/dd/yy mm:ss') "End of AWR two" from dual;. Echo "mime-version: 1.0".

2

Ramshankar MG: June 2015

http://ramshankarmg.blogspot.com/2015_06_01_archive.html

Monday, June 22, 2015. How to Delete SQL PLAN BASELINE in Oracle 11g. Steps to delete SQL PLAN BASELIN in oracle 11g. SQL select SQL HANDLE,SQL TEXT,PLAN NAME,CREATOR,CREATED,LAST MODIFIED,LAST EXECUTED,LAST VERIFIED,ENABLED,ACCEPTED,OPTIMIZER COST MODULE,ACTION from dba sql plan baselines;. SQL HANDLE SQL TEXT PLAN NAME CREATOR CREATED LAST MODIFIED LAST EXECUTED LAST VERIFIED ENA ACC MODULE ACTION. SQL set serveroutput on. 2 ret value pls integer;. 3 sql handle in varchar2(30);. 4 cursor c1 is. Awesome...

3

Ramshankar MG: July 2015

http://ramshankarmg.blogspot.com/2015_07_01_archive.html

Saturday, July 11, 2015. Making a Table Readonly. In this example, we’ll create a table, insert data in it, and then create trigger to prevent any insert, update or delete statement on table. SQL CREATE TABLE tbl read only (id NUMBER);. SQL INSERT INTO tbl read only VALUES(1);. SQL SELECT * FROM tbl read only;. 8212;——-. SQL CREATE TRIGGER trg tbl read only BEFORE DELETE OR INSERT OR UPDATE. 2 ON tbl read only. 4 RAISE APPLICATION ERROR(-20202,’Table Status: READ ONLY! INSERT INTO tbl read only VALUES(2).

4

Ramshankar MG: December 2012

http://ramshankarmg.blogspot.com/2012_12_01_archive.html

Friday, December 14, 2012. Oracle SQL TUNING ADVISOR. Oracle allows the optimizer to run in tuning mode where it can gather additional information and make recommendations about how specific statements can be tuned further. In tuning mode the optimizer performs the following analysis:. The optimizer recommends the gathering of statistics on objects with missing or stale statistics. Additional statistics for these objects are stored in an SQL profile. The optimizer suggests alternatives for SQL statements...

5

Ramshankar MG: March 2014

http://ramshankarmg.blogspot.com/2014_03_01_archive.html

Thursday, March 6, 2014. Formatted CRSCTL output for oracle 11gR2. Formatted CRSCTL output for oracle 11gR2:. Crsctl status res grep -v " $" awk -F "=" 'BEGIN {print " "} {printf("%s",NR%4? 2" " : $2" n")}' sed -e 's/ *, /,/g' -e 's/, /,/g' awk -F " " 'BEGIN { printf "%-40s%-35s%-20s%-50s n","Resource Name","Resource Type","Target ","State" }{ split ($3,trg,",") split ($4,st,",")}{for (i in trg) {printf "%-40s%-35s%-20s%-50s n",$1,$2,trg[i],st[i]} '. Thursday, March 06, 2014. Subscribe to: Posts (Atom).

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

ramshandilya.blogspot.com

Lets talk!

Saturday, November 26, 2011. Posted by Ramsundar Shandilya. I've shifted the blog to my own domain. Please visit ramblr.in. Monday, May 16, 2011. Top Footballers to follow on Twitter - revisited. Posted by Ramsundar Shandilya. A lot of footballers have joined twitter.some of them use contructively.some of them get abused.some gets charged by the board. Here's a list footballers to follow on twitter. Rafael van der Vaart. You simply can't miss the everyday banter between Piers Morgan. But in 1989-90 seaso...

ramshandilya.com

RAMSUNDAR SHANDILYA

IOS developer @ Y Media Labs. Care about things that have real and lasting impact. Focused on making Human-Computer interactions simple, beautiful and captivating. I wrote an article on my thoughts on Swift. Head over to medium.com. I’ve been learning swift in detail last couple of weeks. Sharing the notes from my learnings. The #iPhone finally finds its rightful owner. It’s the makeover my Macbook deserved, not the one it needed right now. Good design is obvious. Great design is transparent. Page 1 of 10.

ramshani.com

ram shani cinematographer

ramshankar.in

Surgical Dressing Materials,Gauze Rolls Manufacturers,Triangular Bandage Suppliers,India

Premium Member of ExportersIndia.Com.

ramshankar.info

Index of /

ramshankarmg.blogspot.com

Ramshankar MG

Tuesday, August 4, 2015. Shell Script to generate Hourly AWR Report. Echo Syntax awr report.sh ORACLE SID. Oraapp/oracle/tools/scripts/crontab.env ${l sid} myDate=`date " %m%d%Y"` myHour=`date " %H"` l start time=`sqlplus -s '/ as sysdba'. Usr/bin/rm ${l logdir}/awrrpt ${l sid} * l awr log file=${l logdir}/awrrpt ${l sid} ${l starttime log}.html. Sqlplus -s '/ as sysdba'. Sqlplus -s '/ as sysdba'. Select to char(sysdate -1,'mm/dd/yy mm:ss') "End of AWR two" from dual;. Echo "mime-version: 1.0". ORA-06512...

ramshankaryadav.com

Ram Shankar Yadav's home on web!

I'm a software engineer by choice and currently working with Allscripts. As Principal Software Engineer. I'm born, brought up and did my schooling from Delhi(India), but currently I'm in Pune(India). My hobbies include playing guitar, gym, cruising, photography, cooking and adventure sports. I've done eMBA from IIM Calcutta, MS in Software Systems from BITS, Pilani and BIS(Hons) from Indraprastha University, Delhi. I'm a MCPD.NET - Enterprise Applications. My last tweet on Twitter.

ramshanrasiah.blogspot.com

0

Vendredi 7 août 2015. Jeudi 6 août 2015. Je sens que je vais traverser une phase où je ne vais dessiner que des trucs chiants, pas intéressants, et mal sentis jusqu'à ce que quelque chose se débloque. Après tout, c'est l'été, c'est fait pour ça . Mardi 28 juillet 2015. Dimanche 26 juillet 2015. Je teste des trucs . Un petit croquis fanart du prince des saiyans. Samedi 25 juillet 2015. Petit dessin du samedi pour le characterdesign challenge sur Facebook! Vendredi 24 juillet 2015. Toute reproduction total...

ramshanth.com

Index of /

ramshappyplace.wordpress.com

My Happy Place | A place filled with my favourite things

A place filled with my favourite things. It’s my nephew’s birthday, LoL. June 3, 2013. I decided to try out the technique in this article. To draw some of my nephews favourite game characters on his birthday cake. It works like a charm and I am pretty pleased with the results. My nephew seems to like it too as he seems to want to preserve the iced characters for as long as he can – which isn’t that long as the kids love their chocolate brownies! Share on Facebook (Opens in new window). May 23, 2013.