rajeev-oracledbaessential.blogspot.com

ORACLE DBA ESSENTIAL

Tuesday, January 10, 2012. SOME TIPS ABOUT ASH. Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second from v$session and stores them in a circular FIFO buffer in the. Dba hist active session history. ASH resides in the SGAand it’s size is calculated by the lesser of:. Total # of cpu x 2MB memory. 5% of shared pool. So on a 16 cpu server with a shared pool of 500MB. Ash desired size 16 x 2MB = 32MB. Client ID, Service ID.

http://rajeev-oracledbaessential.blogspot.com/

OVERVIEW OF rajeev-oracledbaessential.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

8

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR RAJEEV-ORACLEDBAESSENTIAL.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

March

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Tuesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.2 out of 5 with 10 reviews

5 star

2

4 star

2

3 star

4

2 star

0

1 star

2

Hey there! Start your review of rajeev-oracledbaessential.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT RAJEEV-ORACLEDBAESSENTIAL.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

8

SSL

EXTERNAL LINKS

14

SITE IP

173.194.46.106

LOAD TIME

0.266 sec

SCORE

6.2

PAGE TITLE

ORACLE DBA ESSENTIAL | rajeev-oracledbaessential.blogspot.com Reviews

<META> DESCRIPTION

Tuesday, January 10, 2012. SOME TIPS ABOUT ASH. Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second from v$session and stores them in a circular FIFO buffer in the. Dba hist active session history. ASH resides in the SGAand it’s size is calculated by the lesser of:. Total # of cpu x 2MB memory. 5% of shared pool. So on a 16 cpu server with a shared pool of 500MB. Ash desired size 16 x 2MB = 32MB. Client ID, Service ID.

<META> KEYWORDS

1 oracle dba essential

2 sql id

3 ash enable=true

4 milliseconds

5 posted by

6 rajeev

7 no comments

8 email this

9 blogthis

10 share to twitter

CONTENT

Page content here

KEYWORDS ON PAGE

oracle dba essential,sql id,ash enable=true,milliseconds,posted by,rajeev,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,export path=$agent home/bin $path,startup the agent,emctl start agent,emctl clearstate agent

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

ORACLE DBA ESSENTIAL | rajeev-oracledbaessential.blogspot.com Reviews

https://rajeev-oracledbaessential.blogspot.com

Tuesday, January 10, 2012. SOME TIPS ABOUT ASH. Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second from v$session and stores them in a circular FIFO buffer in the. Dba hist active session history. ASH resides in the SGAand it’s size is calculated by the lesser of:. Total # of cpu x 2MB memory. 5% of shared pool. So on a 16 cpu server with a shared pool of 500MB. Ash desired size 16 x 2MB = 32MB. Client ID, Service ID.

INTERNAL PAGES

rajeev-oracledbaessential.blogspot.com

1

ORACLE DBA ESSENTIAL: HOW TO SET-UP RAC IN 10G USING OPENFILER FOR VIRTUAL STORAGE

http://www.rajeev-oracledbaessential.blogspot.com/2010/07/how-to-set-up-rac-in-10g-using.html

Wednesday, July 28, 2010. HOW TO SET-UP RAC IN 10G USING OPENFILER FOR VIRTUAL STORAGE. 2- NODE RAC SETUP WITH OPENFILER. Install openfiler on a machine (Leave 60GB free space on the hdd). Login to root user. Start iSCSI target service. Chkconfig –level 345 iscsi-target on. PART –B Configuring Storage on openfiler. From any client machine open the browser and access openfiler console (446 ports). Open system tab and update the local N/W configuration for both nodes with netmask (255.255.255.0). 1929201&#...

2

ORACLE DBA ESSENTIAL: SOME TIPS ABOUT ASH

http://www.rajeev-oracledbaessential.blogspot.com/2012/01/some-tips-about-ash.html

Tuesday, January 10, 2012. SOME TIPS ABOUT ASH. Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second from v$session and stores them in a circular FIFO buffer in the. Dba hist active session history. ASH resides in the SGAand it’s size is calculated by the lesser of:. Total # of cpu x 2MB memory. 5% of shared pool. So on a 16 cpu server with a shared pool of 500MB. Ash desired size 16 x 2MB = 32MB. Client ID, Service ID.

3

ORACLE DBA ESSENTIAL: CASE STUDY ON BUFFER BUSY WAIT EVENT

http://www.rajeev-oracledbaessential.blogspot.com/2012/01/case-study-on-buffer-busy-wait-event.html

Monday, January 9, 2012. CASE STUDY ON BUFFER BUSY WAIT EVENT. S008 2731.trc: ORA-07445: exception encountered: core dump [kzdurtc() 4] [SIGBUS] [Invalid address alignment] [859063291] [] [] Wed May 16 00:38:15 2001 Errors in file /db admin/prod/bdump/mlrep. S014 2737.trc: ORA-07445: exception encountered: core dump [kzdurtc() 4] [SIGSEGV] [Address not mapped to object] [926430458] [] [] Wed May 16 00:41:13 2001 Errors in file /db admin/prod/bdump/mlrep. Subscribe to: Post Comments (Atom).

4

ORACLE DBA ESSENTIAL: January 2012

http://www.rajeev-oracledbaessential.blogspot.com/2012_01_01_archive.html

Tuesday, January 10, 2012. SOME TIPS ABOUT ASH. Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second from v$session and stores them in a circular FIFO buffer in the. Dba hist active session history. ASH resides in the SGAand it’s size is calculated by the lesser of:. Total # of cpu x 2MB memory. 5% of shared pool. So on a 16 cpu server with a shared pool of 500MB. Ash desired size 16 x 2MB = 32MB. Client ID, Service ID.

5

ORACLE DBA ESSENTIAL: May 2011

http://www.rajeev-oracledbaessential.blogspot.com/2011_05_01_archive.html

Wednesday, May 4, 2011. When agent unable to upload files to grid repository. When a grid control agent was installed during a RAC setup an error showed up at the end of the agent configuration assistant. The agent was started successfully, but it was not possible to force the agent to have the XML files uploaded to the grid server, it was when the dreaded error "EMD upload error: uploadXMLFiles skipped : OMS version not checked yet." showed up. The Troubleshooting Procedure Outline was:. Check if HTTPS ...

UPGRADE TO PREMIUM TO VIEW 3 MORE

TOTAL PAGES IN THIS WEBSITE

8

LINKS TO THIS WEBSITE

gssdba.wordpress.com

2014 May « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/2014/05

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Archive for May, 2014. Database house keeping scripts. Find -name “*.trc” -mtime 0 xargs rm -f “*.trc”. Find -name “*.trm” -mtime 0 xargs rm -f “*.trm”. Find -name “*.aud” -mtime 0 xargs rm -f “*.aud”. Find -name “*.xml” -mtime 0 xargs rm -f “*.xml”. Find -name “*.dat” -mtime 1 xargs rm -f “*.dat”. Create a free website or blog at WordPress.com. Follow “ON CALL DBA SUPPORT”. Get every new post delivered to your Inbox.

gssdba.wordpress.com

RAC « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/rac

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Notify me of new comments via email.

gssdba.wordpress.com

2015 July « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/2015/07

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Archive for July, 2015. From oracle 11g R2 we have a new feature in oracle cluvfy , It will generate the HEALTHCHECK report in html format FOR RAC . Mkdir -p /tmp/clu tmp. Cluvfy comp healthcheck -collect cluster -html -save -savedir /tmp/clu tmp. Create a free website or blog at WordPress.com. Follow “ON CALL DBA SUPPORT”. Get every new post delivered to your Inbox. Join 60 other followers.

gssdba.wordpress.com

2015 April « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/2015/04

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Archive for April, 2015. CLONE ORACLE 11g HOME. STEPS TO CLONE ORACLE 11g ORACLE HOME FROM ONE SERVER TO ANOTHER. STEP 01 : ZIP THE ORACLE HOME FILE FROM THE SOURCE. Tar -pcvf 11204.tar 11.2.0.4. STEP 02 : SCP .tar file to the target server. Scp -p username@target.com:/u01/app/oracle/product/ . STEP 03 : UNTAR THE .tar FILE. Tar -xvf 11204.tar. STEP04 : RUN CLONE.PL FROM ORACLE HOME. WARNING:A new inventory has been crea...

gssdba.wordpress.com

2015 June « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/2015/06

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Archive for June, 2015. ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode(During RMAN COLD BACKUP). RMAN-03009: failure of backup command on c3 channel at 05/15/2012 18:49:11. ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode. Continuing other job steps, job failed will not be re-run. Channel c4: starting compressed full datafile backupset. Channel c4: specifying datafile(s) in backupset.

gssdba.wordpress.com

2015 February « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/2015/02

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Archive for February, 2015. COMPILE ENTIRE SCHEMA OBJECTS. EXEC UTL RECOMP.recomp serial(‘SCOTT’);. Blog at WordPress.com. Follow “ON CALL DBA SUPPORT”. Get every new post delivered to your Inbox. Join 60 other followers. Build a website with WordPress.com.

gssdba.wordpress.com

2014 October « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/2014/10

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Archive for October, 2014. QUERY TO FIND RMAN BACKUP STATUS IN A DATABASE. Set lines 200;. Set pages 200;. SELECT INPUT TYPE “Backup Type”,incremental level,d.session recid,. TO CHAR(d.START TIME,’mm/dd/yy hh24:mi’) “start time”,. TO CHAR(END TIME,’mm/dd/yy hh24:mi’) “End time”,. Delapsed seconds/3600 “Elapsed Time”,. QUERY TO FIND FRA UTILIZATION. Set lines 200;. Col “Flashback Area” for a40;. Join 60 other followers.

gssdba.wordpress.com

2014 March « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/2014/03

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Archive for March, 2014. ORA-15000: command disallowed by current instance type. ORA-15000: command disallowed by current instance type. When you try to connect to ASM instance remotly you will get this error:. Connect to the ASM instance as sysasm :. SQLPLUS CONNECT SCOTT/TIGER AS SYSASM. If above fix did not worked for you, then you have to add one more step:. 1 Take the backup of the listener.ora file. SID NAME = ASM).

gssdba.wordpress.com

2013 November « ON CALL DBA SUPPORT

https://gssdba.wordpress.com/2013/11

ON CALL DBA SUPPORT. 8212; Database blog. Join 60 other followers. Pavan's DBA blog. Archive for November, 2013. Srvctl ACTION PROCESS – h – -h Stands for help, this command will give you the details about the command which we can use:. Srvctl stop instance -h. Srvctl version: 11.0.0.0.0. Srvctl stop instance -i orcl1 -d orcl -o immediate. Srvctl start instance -i orcl1 -d orcl. Srvctl status instance -i orcl1 -d orcl. 8212;————–. F Include disabled applications. Srvctl status asm -n vmlinux1. USER (ospi...

UPGRADE TO PREMIUM TO VIEW 5 MORE

TOTAL LINKS TO THIS WEBSITE

14

OTHER SITES

rajeev-gupta.blogspot.com

Managing High-Tech

Bridging academics with main-street. Friday, June 1, 2007. Sales and Marketing (S&M) is probably the most important part of demand creation and revenue generation. According to Ajay Shah of Shah Capital, it is really important to be first-to-market, which not only means you get the first revenue, but also means you establish yourself as an innovator and the trend-setter. 8220; 90% of all marketing programs are based on communicating the essence of the better product or service. How will it help them?

rajeev-kapur.com

Welcome rajeev-kapur.com - Justhost.com

Web Hosting from Just Host. Design By Design Fusions.

rajeev-mahura.blogspot.com

Rajeev Mahura

rajeev-mohan.blogspot.com

Splash Of Watercolour

The magic and madness of watercolour. Sunday, April 5, 2015. Summer shower - Mysuru. Sunday, April 05, 2015. Sunday, February 1, 2015. Sunday, February 01, 2015. Monday, January 26, 2015. Brihadeeshwara Temple, Tanjavur. Monday, January 26, 2015. Wednesday, January 7, 2015. Varadaraja Perumal Temple, Kanchipuram. Wednesday, January 07, 2015. Tuesday, December 30, 2014. Shore temple - Mamallapuram. The breathtaking 8th Century Pallava temple in Mamallapuram. Tuesday, December 30, 2014. Sunday, May 4, 2014.

rajeev-n-aamna.skyrock.com

Blog de Rajeev-n-Aamna - Rajeev-Aamna - Skyrock.com

Mot de passe :. J'ai oublié mon mot de passe. Plus d'actions ▼. S'abonner à mon blog. Boone année, c la saison des galettes des rois et des crêpes régalez vous! Vendredi 31 janvier 2014 12:51. Création : 16/12/2012 à 09:13. Mise à jour : 27/06/2015 à 14:08. Kajol et Sharuk:les meilleurs acteurs indiens! Bienvenue pour ce qui sont nouveaus mais aussi pour tous les autres. Je vais faire une story. Http:/ histoire-indienne.Skyrock.com. Http:/ Delighful-Kads.Skyrock.com. Http:/ Kajol-000.Skyrock.com. N'oubli...

rajeev-oracledbaessential.blogspot.com

ORACLE DBA ESSENTIAL

Tuesday, January 10, 2012. SOME TIPS ABOUT ASH. Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second from v$session and stores them in a circular FIFO buffer in the. Dba hist active session history. ASH resides in the SGAand it’s size is calculated by the lesser of:. Total # of cpu x 2MB memory. 5% of shared pool. So on a 16 cpu server with a shared pool of 500MB. Ash desired size 16 x 2MB = 32MB. Client ID, Service ID.

rajeev-photoblog.blogspot.com

Rajeev_photoblog

Saturday, April 07, 2012. Here are some photos of my son, Abhiram. Whole of last year, I haven't travelled much. The reason being him. So, the only photo-op for me was him. These are just a small bit of the photos I have. Posted by rajeev at 8:08 AM. I had been to Igatpuri a few weeks back, it was one of the best monsoon trips i've had, it was refreshing and beautiful. here are some snaps. Posted by rajeev at 7:19 AM. Saturday, April 09, 2011. So, here's are the few snaps. Copy - paste from wikipedia.

rajeev-r.blogspot.com

Random Musings

Monday, October 12, 2009. The bus left Madivala promptly at 7.15 and we were the only people in the bus. My understanding was that it was coming from Indiranagar and would go to Majestic for further pickups and then leave the city. Wrong again. We were just starting our Bangalore Darshan. That was about the Bangalore Darshan we went through as part of the Hyderabad Trip. So what about the trip itself? Well, that ended up being even more eventful. So have to leave all that for the next post. :). From the ...

rajeev-reddy.com

Rajeev Reddy

Hi, I'm Rajeev Reddy. Web developer and robotics enthusiast. Stay Hungry Stay Foolish. I'am a fresh graduate of IIT Kharagpur, India with a bachelor's and master's degree in chemical engineering. Apart from studies, I love web based programming and have developed various apps using Ruby on Rails. I also have experience in the area of web scraping and crawling. I have participated in various coding competitions like Yahoo Hack U. 2012 and 2013, Microsoft's Code Fun Do. You can view my full resume here.

rajeev-shrivastava.com

Dr. Rajeev Shrivastava

Dr Rajeev Prakash Shirvastava. Shri D.K. Shrivastava. Contribution as Honorary Secretary CSI 2005-2008.

rajeev-upadhye.blogspot.com

राजीव उपाध्ये यांची चिन्तनिका

राजीव उपाध्ये यांची चिन्तनिका. आता अभिनव वाग्विलासिनी जे चातुर्यार्थ कलाकामिनी ते शारदा विश्वमोहिनी नमस्कारिली मिया. माझ्या फोटोग्राफी प्रदर्शनाला इथे अवश्य भेट द्या. मंगळवार, ११ ऑगस्ट, २०१५. मी एक दलित आहे. श्रीमंत मला श्रीमंत म्हणत नाहीत. अन् गरीब मला गरीब म्हणत नाहीत. म्हणुनच मी एक दलित आहे. मुंबईकर मला पुणेकर म्हणतात. अन् पुणेकर त्यांच्यात घेत नाहीत. म्हणुनच मी एक दलित आहे. हुशार लोक मला मठ्ठ समजतात. अन् मठ्ठ मला हुशार समजतात. म्हणुनच मी एक दलित आहे. राजीव उपाध्ये. ११:३३ म.पू. Links to this post.