anotherdavewebster.wordpress.com anotherdavewebster.wordpress.com

anotherdavewebster.wordpress.com

Dave Webster's Blog

Tinkering with Oracle

http://anotherdavewebster.wordpress.com/

WEBSITE DETAILS
SEO
PAGES
SIMILAR SITES

TRAFFIC RANK FOR ANOTHERDAVEWEBSTER.WORDPRESS.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

CUSTOMER REVIEWS

Average Rating: 3.4 out of 5 with 9 reviews
5 star
2
4 star
2
3 star
4
2 star
0
1 star
1

Hey there! Start your review of anotherdavewebster.wordpress.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

Desktop Preview Tablet Preview Mobile Preview

LOAD TIME

5 seconds

FAVICON PREVIEW

  • anotherdavewebster.wordpress.com

    16x16

  • anotherdavewebster.wordpress.com

    32x32

CONTACTS AT ANOTHERDAVEWEBSTER.WORDPRESS.COM

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

SCORE

6.2

PAGE TITLE
Dave Webster's Blog | anotherdavewebster.wordpress.com Reviews
<META>
DESCRIPTION
Tinkering with Oracle
<META>
KEYWORDS
1 tinkering with oracle
2 recent posts
3 categories
4 patterns
5 performance
6 tips and tricks
7 uncategorized
8 archives
9 useful links
10 run stats
CONTENT
Page content here
KEYWORDS ON
PAGE
tinkering with oracle,recent posts,categories,patterns,performance,tips and tricks,uncategorized,archives,useful links,run stats,blogroll,james morle,jonathan lewis,martin widlake,nigel noble,email subscription,rss posts,rss comments,2 comments,delete
SERVER
nginx
CONTENT-TYPE
utf-8
GOOGLE PREVIEW

Dave Webster's Blog | anotherdavewebster.wordpress.com Reviews

https://anotherdavewebster.wordpress.com

Tinkering with Oracle

INTERNAL PAGES

anotherdavewebster.wordpress.com anotherdavewebster.wordpress.com
1

Wakey Wakey Mr Webster « Dave Webster's Blog

https://anotherdavewebster.wordpress.com/2013/08/01/wakey-wakey-mr-webster

Dave Webster's Blog. Who is the real Dave Webster? SUBPROGRAM IDs for private procedures. UK OUG TECH 2013. Do you really need another index? How best to get data from Oracle into our Java code? Wakey Wakey Mr Webster. Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 9 other followers. Laquo; Conditional joins: Part 2. How best to get data from Oracle into our Java code? Wakey Wakey Mr Webster. On August 1, 2013. Feed You can leave a response. You a...

2

2013 August « Dave Webster's Blog

https://anotherdavewebster.wordpress.com/2013/08

Dave Webster's Blog. Who is the real Dave Webster? SUBPROGRAM IDs for private procedures. UK OUG TECH 2013. Do you really need another index? How best to get data from Oracle into our Java code? Wakey Wakey Mr Webster. Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 9 other followers. Archive for August, 2013. Do you really need another index? On August 19, 2013. I would like to retain three years of data in my transaction table. I’m sure you...

3

Do you really need another index? « Dave Webster's Blog

https://anotherdavewebster.wordpress.com/2013/08/19/do-you-really-need-another-index

Dave Webster's Blog. Who is the real Dave Webster? SUBPROGRAM IDs for private procedures. UK OUG TECH 2013. Do you really need another index? How best to get data from Oracle into our Java code? Wakey Wakey Mr Webster. Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 9 other followers. Laquo; How best to get data from Oracle into our Java code? UK OUG TECH 2013. Do you really need another index? On August 19, 2013. They would run this in a loop, com...

4

SUBPROGRAM IDs for private procedures « Dave Webster's Blog

https://anotherdavewebster.wordpress.com/2014/12/22/subprogram-ids-for-private-procedures

Dave Webster's Blog. Who is the real Dave Webster? SUBPROGRAM IDs for private procedures. UK OUG TECH 2013. Do you really need another index? How best to get data from Oracle into our Java code? Wakey Wakey Mr Webster. Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 9 other followers. Laquo; UK OUG TECH 2013. SUBPROGRAM IDs for private procedures. On December 22, 2014. Select * from dba objects where object id = PLSQL ENTRY OBJECT ID. My problem ca...

5

2013 September « Dave Webster's Blog

https://anotherdavewebster.wordpress.com/2013/09

Dave Webster's Blog. Who is the real Dave Webster? SUBPROGRAM IDs for private procedures. UK OUG TECH 2013. Do you really need another index? How best to get data from Oracle into our Java code? Wakey Wakey Mr Webster. Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 9 other followers. Archive for September, 2013. UK OUG TECH 2013. On September 30, 2013. And Polling for new data: Part 2. Come and see me here. Build a website with WordPress.com.

UPGRADE TO PREMIUM TO VIEW 9 MORE

TOTAL PAGES IN THIS WEBSITE

14

LINKS TO THIS WEBSITE

nigelnoble.wordpress.com nigelnoble.wordpress.com

11.2.0.3 v$sqlstats.last_active_time stops changing and breaks AWR | Nigel Noble's Oracle Blog

https://nigelnoble.wordpress.com/2013/03/28/11-2-0-3-vsqlstats-last_active_time-stops-changing-and-breaks-awr

Nigel Noble's Oracle Blog. 11203 v$sqlstats.last active time stops changing and breaks AWR. 8212; Nigel Noble @ 3:18 pm. 8221;…. I thought! Well, I recently discovered that any time a sql statement drops off the 3rd party monitoring tool…… IT STOPS BEING MONITORED IN AWR’s DBA HIST SQLSTAT table as well. Let’s start at the very beginning…. V$sqlstats.last active time can stop changing with multiple child cursors. I wrote the following script to compare v$sqlstats to v$sql. Output looks like this:. I foun...

nigelnoble.wordpress.com nigelnoble.wordpress.com

“enq: TX – contention” on SELECT with a large buffer cache and 2PC | Nigel Noble's Oracle Blog

https://nigelnoble.wordpress.com/2013/07/12/enq-tx-contention-on-select-with-a-large-buffer-cache-and-2pc

Nigel Noble's Oracle Blog. Enq: TX contention on SELECT with a large buffer cache and 2PC. 8212; Nigel Noble @ 12:08 pm. Note: The following is based on testing with 11.2.0.3 (I believe same issue exists within other Oracle versions). A new variation of “enq: TX – contention”. Our application had the following profile on TWO separate databases:. The Batch Job on DB1. UK DB 1: Starts a transaction. UK DB 1: Updates lot of data in local tables. UK DB 2: returns control back to DB1. UK DB 2: running a criti...

nigelnoble.wordpress.com nigelnoble.wordpress.com

10.2.0.5 dbms_sql leaks memory AND performance degrades | Nigel Noble's Oracle Blog

https://nigelnoble.wordpress.com/2011/01/11/10-2-0-5-dbms_sql-leaks-memory-and-performance-degrades

Nigel Noble's Oracle Blog. 10205 dbms sql leaks memory AND performance degrades. 8212; Nigel Noble @ 11:24 am. We applied the patch for 10269717 and the PGA memory leak was resolved but more importantly the performance remained constant. I just checked the 10.2.0.5 known issues document and this does now list the bug, but it still only references the leak and not the performance implications. 4 Comments ». Thank You for sharing such vital information. This is really useful to me. Comment by Vega Lin.

nigelnoble.wordpress.com nigelnoble.wordpress.com

Nigel Noble's Oracle Blog | Oracle Performance Blog | Page 2

https://nigelnoble.wordpress.com/page/2

Nigel Noble's Oracle Blog. 8212; Nigel Noble @ 4:19 pm. The company where I work run a large web infrastructure with many different Java based applications and servers. Most of these application servers connect to the database using a connection pool to manage database connections and reduce the cost of starting/destroying database sessions. Over the years we have spent a lot of time trying to get the right balance to keep session usage as smooth as possible. Maximum connections in the pool set too low?

nigelnoble.wordpress.com nigelnoble.wordpress.com

dbms_scheduler.drop_job “leaks” PGA memory | Nigel Noble's Oracle Blog

https://nigelnoble.wordpress.com/2010/08/25/dbms_scheduler-drop_job-leaks-pga-memory

Nigel Noble's Oracle Blog. Dbms scheduler.drop job “leaks” PGA memory. 8212; Nigel Noble @ 1:00 pm. I thought I would post a very short note about a recent PGA memory “leak” issue we found in one of our applications that appears to exist in Oracle versions 10gR2 through to 11gR2. I would not expect the problem to actually affect many sites so I am not going to spend a huge amount of time showing the test case but thought I would make people aware of the potential issue. Leave a Comment ». This is a perso...

jarneil.wordpress.com jarneil.wordpress.com

Oracle ASM 12c: New Features | jarneil

https://jarneil.wordpress.com/2014/04/07/oracle-asm-12c-new-features

The thoughts of Jason Arneil. Oracle ASM 12c: New Features. Last week I was lucky enough to be presenting at the UKOUG AIM SIG. There was a decent enough crowd in attendance and there were some really interesting talks and some really good speakers. In particularly I found Chris Lawless speaking on replication a particularly engaging speaker, and Dave Webster. Really held the audiences attention late in day. For clearest understanding, you probably want to download the ppt. April 7, 2014. Oracle 12.1...

nigelnoble.wordpress.com nigelnoble.wordpress.com

10.2.0.5, KEEP pool / Serial Direct Read | Nigel Noble's Oracle Blog

https://nigelnoble.wordpress.com/2010/07/05/10-2-0-5-keep-pool-serial-direct-read

Nigel Noble's Oracle Blog. 10205, KEEP pool / Serial Direct Read. Filed under: 10.2.0.5. 8212; Nigel Noble @ 11:36 am. Jonathan Lewis made reference to a 11g bug related to using a KEEP POOL in his note Not KEEPing. Oracle 11g introduced a new feature called adaptive serial direct path reads. The 10.2.0.5 patchset has also back-ported. The same direct read feature which is new to 11g although I don’t know if the rules are the same as 11g. The site where I work makes significant use of KEEP pool...I want ...

orastory.wordpress.com orastory.wordpress.com

SQL Plan Management Choices | OraStory

https://orastory.wordpress.com/2015/08/11/sql-plan-management-choices

Dominic Brooks on Oracle Performance, Tuning, Data Quality and Sensible Design … (Now with added Sets Appeal). Quick Cross-Period AWR Comparison →. SQL Plan Management Choices. August 11, 2015. My thoughts on SQL plan management decision points:. Are also available, primarily to avoid a specific problem not to enforce a particular plan, and are not covered in the above flowchart. SQL Plan Management Choices. August 11, 2015 at 1:22 pm. Very nice job Dom. Leave a Reply Cancel reply. Enter your comment here.

nigelnoble.wordpress.com nigelnoble.wordpress.com

10gR2 – 11gR2, ASSM Space Management “Bug” | Nigel Noble's Oracle Blog

https://nigelnoble.wordpress.com/2010/07/23/10gr2-11gr2-assm-space-management-bug

Nigel Noble's Oracle Blog. 10gR2 – 11gR2, ASSM Space Management “Bug”. 8212; Nigel Noble @ 10:59 am. ASSM (Automatic Segment Space Management) has an issue when trying to re-use “deleted” space created by another session. There is a very specific set of circumstances. Which must occur for this issue to show itself, but will result in tables (and I suspect indexes) growing significantly larger. The conditions required to cause the issue. What we found was the INSERT statement could not. 5 Comments ».

UPGRADE TO PREMIUM TO VIEW 6 MORE

TOTAL LINKS TO THIS WEBSITE

15

OTHER SITES

anotherdatingdisaster.com anotherdatingdisaster.com

Coming Soon - Future home of something quite cool

Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.

anotherdatingsite.com anotherdatingsite.com

Dating, Singles & Personals - Find Singles in Your Area

Dating, Singles and Personals - Find Singles in Your Area. Search Dating - Find Singles in Your Area Dating by State. Key: (# of single men and women).

anotherdaughter.com anotherdaughter.com

Another Daughter TM | A senior care service for independent Seniors living in or around Raleigh, NC

Making your life easier. AnotherDaughter™ based in Raleigh, North Carolina, provides caregivers and adult children the help they need to find, coordinate and monitor non-medical services for the seniors they love. I have such a sense of relief plus accomplishment with the help of…. Independent Senior Living is Possible. With the Right Senior Care Services. Is it important to maintain control of your independent lifestyle? To arrange a free one-hour consultation. See more studies ». Service at a glance.

anotherdaughtertolove.blogspot.com anotherdaughtertolove.blogspot.com

Another daughter to love

Another daughter to love. Monday, March 28, 2011. Friday, February 11, 2011. Maybe she needs a liver ultrasound or scan? I was stressed, stunned, and crying a few days ago about this. Just start up treatment again soon and keep praying. Her thyroid came back high as well this lab. this level fluctuates between high and normal every other lab, normal, high, normal, high, etc. I got an appt for Julia March 9. Always something. Tuesday, January 25, 2011. Better than planning a party, and easier.

anotherdave.wordpress.com anotherdave.wordpress.com

Redundancy Redux

My wisdom and vanity have exceeded the bounds of WP.com…. You can now and in the future become enlightened at: (not that) Dave Foley (dot com). StorEvil 0.1 released. StorEvil 0.1 was “released” today… and by “released” I mean I zipped up the binaries and added some installation instructions. You can get it from the github download page. Changes since my last in-depth post about StorEvil. 8211; Added HTML reporting of spec results using the Spark View Engine. 8211; fixed a bunch of bugs (of course).

anotherdavewebster.wordpress.com anotherdavewebster.wordpress.com

Dave Webster's Blog

Dave Webster's Blog. Who is the real Dave Webster? SUBPROGRAM IDs for private procedures. UK OUG TECH 2013. Do you really need another index? How best to get data from Oracle into our Java code? Wakey Wakey Mr Webster. Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 9 other followers. SUBPROGRAM IDs for private procedures. On December 22, 2014. SPOILER ALERT : This Blog post ends with a question (it’s a story of failure) * *. My problem came when I...

anotherdavidhiggins.com anotherdavidhiggins.com

ANOTHER DAVID HIGGINS

This is not the site for the race car driver. Or the famed snooker champ. Or the photographer from Australia. This is the site for me. And, along with getting ready to replace this placeholder of a site by Monday March 12, I. Powered by InstantPage® from GoDaddy.com. Want one?

anotherdavidkim.com anotherdavidkim.com

l o o s e h e a d s e t

June 14, 2011. Middot; No Comments. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim. Continue Reading →. June 14, 2011. Middot; No Comments. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in. Continue Reading →. June 14, 2011 by. Continue Reading →. Use the form below to search the site:. Still not finding what you're looking for?

anotherdavidrichardson.tumblr.com anotherdavidrichardson.tumblr.com

Another David Richardson

Film Forever. http:/ instagram.com/davidaarichardson. Contact me at davidaarichardson@gmail.com. Let’s take a drive into the middle of nowhere with a packet of Marlboro lights and talk about our lives.”. The girl that was always a drag. I said, “Kiss me, you’re beautiful - These are truly the last days”. Akwetey of Dragons of Zynth.

anotherdavidsmith.com anotherdavidsmith.com

anotherdavidsmith.com

Skip to primary content. Skip to secondary content. October 26, 2011. Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! Proudly powered by WordPress.

anotherdawn.com anotherdawn.com

AnotherDawn.com

AnotherDawn.com is For Sale for $799!