rommelpascual-notes.blogspot.com

Rommel's Notes

Monday, August 29, 2005. To avoid producing gaps in sequences when flushing the shared pool, it is recommended to keep/pin the sequences before flushing the SGA. V sqlstmt varchar2(500);. For c1 in (select object name from user objects. Where object type='SEQUENCE') loop. SYSDBMS SHARED POOL.KEEP(c1.object name,'Q');. Execute immediate 'alter system flush shared pool';. Posted by Rommel Pascual at 5:19 PM. Thursday, August 25, 2005. Detecting Broken DBMS JOBS. BROKEN JOBS DETECTED EXCEPTION;. Where desti...

http://rommelpascual-notes.blogspot.com/

OVERVIEW OF rommelpascual-notes.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

10

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ROMMELPASCUAL-NOTES.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: 4.0 out of 5 with 5 reviews

5 star

2

4 star

1

3 star

2

2 star

0

1 star

0

Hey there! Start your review of rommelpascual-notes.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

1.1 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT ROMMELPASCUAL-NOTES.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

10

SSL

EXTERNAL LINKS

0

SITE IP

74.125.226.74

LOAD TIME

1.09 sec

SCORE

6.2

PAGE TITLE

Rommel's Notes | rommelpascual-notes.blogspot.com Reviews

<META> DESCRIPTION

Monday, August 29, 2005. To avoid producing gaps in sequences when flushing the shared pool, it is recommended to keep/pin the sequences before flushing the SGA. V sqlstmt varchar2(500);. For c1 in (select object name from user objects. Where object type='SEQUENCE') loop. SYSDBMS SHARED POOL.KEEP(c1.object name,'Q');. Execute immediate 'alter system flush shared pool';. Posted by Rommel Pascual at 5:19 PM. Thursday, August 25, 2005. Detecting Broken DBMS JOBS. BROKEN JOBS DETECTED EXCEPTION;. Where desti...

<META> KEYWORDS

1 rommel's notes

2 flushing the sga

3 declare

4 begin

5 end loop;

6 end;

7 0 comments

8 end if;

9 exception

10 exit

CONTENT

Page content here

KEYWORDS ON PAGE

rommel's notes,flushing the sga,declare,begin,end loop;,end;,0 comments,end if;,exception,exit,sendmail,mailaddress=email@address,connect as repadmin,commit;,large rollback segments,pl/sql exceptions summary,sql code,handle it here,when others then,name

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Rommel's Notes | rommelpascual-notes.blogspot.com Reviews

https://rommelpascual-notes.blogspot.com

Monday, August 29, 2005. To avoid producing gaps in sequences when flushing the shared pool, it is recommended to keep/pin the sequences before flushing the SGA. V sqlstmt varchar2(500);. For c1 in (select object name from user objects. Where object type='SEQUENCE') loop. SYSDBMS SHARED POOL.KEEP(c1.object name,'Q');. Execute immediate 'alter system flush shared pool';. Posted by Rommel Pascual at 5:19 PM. Thursday, August 25, 2005. Detecting Broken DBMS JOBS. BROKEN JOBS DETECTED EXCEPTION;. Where desti...

INTERNAL PAGES

rommelpascual-notes.blogspot.com

1

Rommel's Notes: Detecting Broken DBMS_JOBS

http://rommelpascual-notes.blogspot.com/2005/08/detecting-broken-dbmsjobs.html

Thursday, August 25, 2005. Detecting Broken DBMS JOBS. Jobs are automatically re-tried when it fails. However, after 16 re-tries, the job is marked as BROKEN and will not be tried again. Here is a query that will monitor the Job Status so that it can send a SMS to the DBA when broken jobs are detected. BROKEN JOBS DETECTED EXCEPTION;. V COUNT NUMBER;. SELECT COUNT(*) INTO V COUNT FROM DBA JOBS WHERE BROKEN='Y';. IF (V COUNT 0) THEN. RAISE BROKEN JOBS DETECTED;. WHEN BROKEN JOBS DETECTED THEN.

2

Rommel's Notes: PL/SQL Exceptions Summary

http://rommelpascual-notes.blogspot.com/2005/08/plsql-exceptions-summary.html

Thursday, August 25, 2005. PARENT KEY NOT FOUND exception;. PRAGMA EXCEPTION INIT(PARENT KEY NOT FOUND,-2291);. Insert into a table with foreign key constraints . WHEN PARENT KEY NOT FOUND THEN. RAISE; - raise it again-. Trap it here again. Posted by Rommel Pascual at 10:30 PM. Recovery Manager (RMAN) Notes. Frequently Forgotten SQL Codes. Visit http:/ www.seawind-network.com. View my complete profile.

3

Rommel's Notes: Fixing Watermark Error in Replication

http://rommelpascual-notes.blogspot.com/2005/08/fixing-watermark-error-in-replication.html

Thursday, August 25, 2005. Fixing Watermark Error in Replication. Sysdbms defer internal sys.parallel push recovery( destination , origin );. Where destination = DBLINK ID of the destination database, e.g. RAPSP.ACNIELSEN.COM.AU. And origin = DBLINK of the originating database, e.g. RECODEP.ACNIELSEN.COM.AU. Posted by Rommel Pascual at 10:34 PM. Recovery Manager (RMAN) Notes. Frequently Forgotten SQL Codes. Visit http:/ www.seawind-network.com. View my complete profile.

4

Rommel's Notes: LARGE ROLLBACK Segments

http://rommelpascual-notes.blogspot.com/2005/08/large-rollback-segments.html

Thursday, August 25, 2005. Using a LARGE ROLLBACK SEGMENT Temporarily. Alter rollback segment LARGE RBS online;. Set transaction use rollback segment LARGE RBS;. Delete/insert, drop unused columns, etc. Alter rollback segment LARGE RBS offline;. Posted by Rommel Pascual at 10:31 PM. Recovery Manager (RMAN) Notes. Frequently Forgotten SQL Codes. Visit http:/ www.seawind-network.com. View my complete profile.

5

Rommel's Notes: August 2005

http://rommelpascual-notes.blogspot.com/2005_08_01_archive.html

Monday, August 29, 2005. To avoid producing gaps in sequences when flushing the shared pool, it is recommended to keep/pin the sequences before flushing the SGA. V sqlstmt varchar2(500);. For c1 in (select object name from user objects. Where object type='SEQUENCE') loop. SYSDBMS SHARED POOL.KEEP(c1.object name,'Q');. Execute immediate 'alter system flush shared pool';. Posted by Rommel Pascual at 5:19 PM. Thursday, August 25, 2005. Detecting Broken DBMS JOBS. BROKEN JOBS DETECTED EXCEPTION;. Where desti...

UPGRADE TO PREMIUM TO VIEW 5 MORE

TOTAL PAGES IN THIS WEBSITE

10

OTHER SITES

rommeloutdoors.com

Rommel Outdoors - Your source for everything Paddle Sports! | Outdoors Store MD

I approve this message. Indicates a required field. Cambridge, MD 21613. Join Our Email List. For Email Marketing you can trust.

rommelpaborada.tumblr.com

cadbury

My CRUSH. hahaha. Posted 3 years ago. After seeing his blog site, I missed writing, and this. :). Posted 3 years ago. Found on - LINK. Reblogged 3 years ago from leilockheart. Reblogged 4 years ago from leilockheart ( Originally from leilockheart. How did you know? Reblogged 4 years ago from leilockheart ( Originally from leilockheart. REBLOG if you miss your EX. Posted 4 years ago. Reblogged 4 years ago from shinsawada ( Originally from hollipoppp. Http:/ www.youtube.com/watch? Posted 4 years ago.

rommelparadijs.nl

't Rommelparadijs

rommelparas.com

Rommel Paras

Theme by safe as milk. Global Filipino. Travel junkie. Tech worker. Married to a divorce attorney. Round the World in 2 weeks for under $400. Some people crave luxurious travel experiences. I like them too - flying first class, staying at exclusive hotels and resorts, eating Michelin-star restaurants, booking high-end tours, etc. We care about the road not taken, about travel hacks no one else would do. Last year, my husband and I traveled over 100,000 miles combined. We circumnavigated the world...We&rs...

rommelpascual-journals.blogspot.com

Rommel Pascual Journals

Visit http:/ www.seawind-network.com. View my complete profile. Tuptim Highlights - King and I (2007). My First Trip To New Zealand. Topol in Fiddler on the Roof. Palenke - Mid 60s. The Tumalads in Sydney 2005. Sunday, March 02, 2008. Posted by Rommel Pascual 11:47 AM. Sunday, December 23, 2007. Well, not exactly, these posts will remain in this site but any further blogs will be in the new home at http:/ www.seawind-network.com. Posted by Rommel Pascual 3:51 AM. Sunday, September 23, 2007. In this scene...

rommelpascual-notes.blogspot.com

Rommel's Notes

Monday, August 29, 2005. To avoid producing gaps in sequences when flushing the shared pool, it is recommended to keep/pin the sequences before flushing the SGA. V sqlstmt varchar2(500);. For c1 in (select object name from user objects. Where object type='SEQUENCE') loop. SYSDBMS SHARED POOL.KEEP(c1.object name,'Q');. Execute immediate 'alter system flush shared pool';. Posted by Rommel Pascual at 5:19 PM. Thursday, August 25, 2005. Detecting Broken DBMS JOBS. BROKEN JOBS DETECTED EXCEPTION;. Where desti...

rommelpatton.deviantart.com

RommelPatton - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 5 Years. This deviant's full pageview. Last Visit: 11 weeks ago. This is the place where you can personalize your profile! Window&#...

rommelpecson.com

Rommel Pecson Photography

rommelpenz.skyrock.com

RommelPenz's blog - She say my dickhead need a crown on it. - Skyrock.com

She say my dickhead need a crown on it. 22/09/2013 at 12:44 PM. 23/09/2013 at 12:51 PM. Subscribe to my blog! I wish i could fvck every girl in thr world. ;). Don't forget that insults, racism, etc. are forbidden by Skyrock's 'General Terms of Use' and that you can be identified by your IP address (66.160.134.62) if someone makes a complaint. Please enter the sequence of characters in the field below. Posted on Sunday, 22 September 2013 at 1:30 PM. Damn, Bitch u ugly. Post to my blog. Here you are free.

rommelperico.com

Work with Mel

I appreciate you stopping by dito sa web page ko. My name is Rommel P. Perico and they use to call me “ djmhel “ I am OFW residing recently in the united arab emirates, city of Al Ain and I am working at the Hilton Hotel as an artist/musician at the same time a dj…. I know that you are excited to know more about the opportunity that I am promoting. So please have time to watch the 30 minutest video presentation below. DECIDE TO SPEND YOUR 30minutes for this ONCE IN LIFETIME OPPORTUNITY! Add me on Facebook.

rommelphoto.com

Rommel-Photo