The Droid will be available this Friday from Verizon. Many of Verizon Wireless Stores will open early Friday (Nov. 6) to give customers the earliest opportunity to purchase the DROID by Motorola on its first day of sale. Some stores will open at 7 a.m. and others at 8 a.m.Customers should check local stores for their opening hours. (Mall stores will not open early.)
Customers visiting Verizon Wireless Communications Stores on or after Friday, Nov. 6, will not only be able to purchase the world’s first smartphone with Android™ 2.0, they can also learn about its variety of advanced features and functions. Verizon Wireless will host demonstrations at select locations to helpcustomers get the most from their new DROID by Motorola devices.
Also on Friday, Verizon Wireless will create a first-of-its-kind interactive experience in New York City called, “DROID Does Times Square.” This experience will let callers control two of Times Square’s largest digital billboards – the NASDAQ and Reuters signs – using only voice commands.
DROID by Motorola will be available in the United States exclusively at Verizon Wireless Communications Stores and online on Friday, Nov. 6, for $199.99 with a new two-year customer agreement after a $100 mail-in rebate. Customers will receive the rebate in the form of a debit card; upon receipt, customers may use the card as cash anywhere debit cards are accepted.
The DROID by Motorola features high-speed Web browsing, voice-activated search, a customizable large screen, access to thousands of Android applications and hundreds of widgets, and the largest 3G mobile network in the country.
Isis King and Clark Gilmer will be on the Tyra Banks Show for episode:
“Isis” on Tuesday, November 18th
Check out the PREVIEW and when it’s on for you.
You loved her in Cycle 11, now first transgender “Top Model” contestant, Isis, is back for a surprise you won’t believe! Plus, “ANTM” contestant Clark shows up to address her hot conflict with Isis on the show. Then, Tyra gets a surprise from a former guest who wants to reveal a big secret.
From US Magazine: Tyra Surprises Contestant with Sex Change Operation (1 minute clip shown there as well)
I just came from a really great conversation with journalist/friend John Boyanoski, a writer for the Upstate’s Community Journals (covering Greenville, Anderson and Spartanburg, S.C.). With it being Election Day and all, the conversation took on a political tone.
But what I found so invigorating about my talk with John, was how we were able to talk to each other with respect and tolerance towards each other’s views (something I can’t do even in my own family – it turns into a shouting match every time). It was so nice to be able to listen to John’s opinions and be able to talk about mine without feeling persecuted or like I was in the wrong for my ideas.
But what really got me thinking was our conversation about the media bias that has (or hasn’t, depending on your opinion) taken place during this presidential election year. I watched a story on Inside Edition last night (I know, not hard core news, but I still enjoy it) about how ‘entertainment news shows’ like The Ellen DeGeneres Show, The View, CBS Late Show with David Letterman and The Tonight Show with Jay Leno, were all skewed to support Barack Obama versus John McCain.
Inside Edition aired clips of the two Ellen shows where both presidential candidates appeared. In the Obama episode, he danced and was able to show his more personal side. When McCain appeared, Ellen grilled him about his opposing views on gay marriage (even though both candidates have openly opposed the idea).
Likewise on The View, Barbara Walters openly flirted with Obama asking if she could call him, “sexy,” while McCain’s appearance turned into a full-on grill-fest from Whoopie Goldberg. And statistics show the late night entertainment shows zinged McCain and party 475 times this year, while Obama only received 69 negative jokes.
Obviously there’s a very real bias there. But since those shows don’t claim to be, and have never been, hard news programs, are they held accountable to the same fair and objective coverage of the other news organizations? Should they be held responsible for using the airtime to subliminally support one presidential candidate over another, knowing the weight it might hold with the viewer?
I’ll admit when I’m watching Ellen, I’m not really watching it to catch up on my news. I watch it for the entertainment value. Are we, as the general U.S. voting population, astute enough to see through the subliminal messages and still make an educated vote based on our own moral convictions? It’s easy to go along with people like Ellen because you feel like you know them.
Regardless of who you voted for today (and you DID vote, didn’t you? Hey, I’m nine months pregnant and stood in line for two hours to do it - so no excuses for you!), it’s important that we, as Americans, take the time to do our homework, research the candidates and make a decision that best fits our lifestyle and opinions.
But how far should these types of shows be allowed to carry their opinion to the viewing public? And how can people see through that to make sure they’re making an educated opinion?
I look forward to camping out in my living room tonight watching election returns and enjoying our American democratic process. And don’t forget to vote today!
Well, in the first place he is incredibly arrogant, haughty, full-of-himself, and entitled. He appears to have almost no empathy for other people. On the other hand, he is very good at using people as long as he wants something from them, and then throwing them under the bus when he no longer needs them. For starters, just ask Rev. Wright, Rev., Pfleger, the members of Trinity United Church of Christ, “former” advisors Samantha Power and Austen Goolsbee, Jim Johnson (former VP committe member), whoever created the “Great Possum Seal,” the “progressive” bloggers who supported him unstintingly for months, and his own grandmother. In fact Obama has added a new cliche to the American vernacular, “He (or she) wasn’t the person I once knew.”
A number of Conflucians have noted in comments that Obama is highly narcissistic. I’d say that’s an understatement. In fact, I would argue that he suffers from Narcissistic Personality Disorder (NPD). Personality disorders are enduring patterns in the way a someone perceives the world, relates to other people, and reacts to events. These behaviors are dysfunctional and affect a person’s functioning in many aspects of life.
NOTE: Approximately 75% of people diagnosed with NPD are men. Therefore, for the sake of convenience, I will refer to the narcissist as “he” and the narcissist’s partner as “she.”
Although people with NPD act haughty and entitled, on an unconscious level, they may actually have doubts about their own abilities, competence, and loveability. Because of this unconscious lack of self-esteem, they constantly need to see their own uniqueness and greatness reflected in the eyes of other people. They expect the people in their lives to provide them with what Sam Vankin calls “narcissistic supply,” meaning unstinting attention, admiration, and praise. People with NPD are often highly sensitive to criticism and they hate to lose. They may become enraged when they don’t get the admiration they expect or when they fail to live up to the high opinion they have of themselves. Because they envy people who are more successful than they are, they frequently believe that people are just as envious of them.
People with NPD can be superficially charming, and they seem to have a special radar that attracts people who are needy and dysfunctional and will gladly provide “narcissistic supply” in return for basking in the narcissist’s reflected glory. For most people, the veneer of the narcissist soon grows thin, and his arrogant, entitled behavior soon becomes annoying and drives them away. And if the narcissist’s significant other begins taking an interest in her own well being instead of focusing on meeting the narcissist’s needs for attention and approval, the narcissist will dump her with no compunctions or regrets.
According to the Diagnostic and Statistical Manual of the American Psychiatric Association (DSM IV-TR), NPD is characterized by
A pervasive pattern of grandiosity (in fantasy or behavior), need for admiration, and lack of empathy, beginning by early adulthood and present in a variety of contexts, as indicated by five (or more) of the following:
1. has a grandiose sense of self-importance (e.g., exaggerates achievements and talents, expects to be recognized as superior without commensurate achievements)
2. is preoccupied with fantasies of unlimited success, power, brilliance, beauty, or ideal love
3. believes that he or she is “special” and unique and can only be understood by, or should associate with, other special or high-status people (or institutions)
4. requires excessive admiration
5. has a sense of entitlement, i.e., unreasonable expectations of especially favorable treatment or automatic compliance with his or her expectations
6. is interpersonally exploitative, i.e., takes advantage of others to achieve his or her own ends
7. lacks empathy: is unwilling to recognize or identify with the feelings and needs of others
8. is often envious of others or believes that others are envious of him
9. shows arrogant, haughty behaviors or attitudes
Honestly, couldn’t a psychiatrist examining Barack Obama check off every item on the list? Let’s look at just a few examples.
1. has a grandiose sense of self-importance (e.g., exaggerates achievements and talents, expects to be recognized as superior without commensurate achievements)
To check off this item, a shrink would only have to look at the fact that Obama chose to run for POTUS with almost no relevevant qualifications or experience and with such a thin resume that he has barely ever held a full-time job (h/t Katiebird). He has based his presidential campaign on the fact that he was a “community organizer” in the 1980s (even though he had no tangible accomplishments), was president of the Harvard Law Review in the 1990s (although he wrote no articles for publication), his undistinguished tenure as a state senator in IL, and an anti-war speech in 1992 that wasn’t even audio- or video-taped and didn’t rate even a mention in the local papers. Oh, and he wrote two autobiographical books by his mid-40s. He claims to have been a “civil rights attorney” (although he has argued no cases in court) and a consitutional law professor” (although he was really a part-time adjunct instructor who never published a single peer reviewed article).
2. is preoccupied with fantasies of unlimited success, power, brilliance, beauty, or ideal love
From a press release from Hillary Clinton’s campaign, 12/2/07:
“Iis Darmawan, 63, Senator Obama’s kindergarten teacher, remembers him as an exceptionally tall and curly haired child who quickly picked up the local language and had sharp math skills. He wrote an essay titled, ‘I Want To Become President,’ the teacher said.” [AP, 1/25/07 ]
His third grade teacher: Fermina Katarina Sinaga “asked her class to write an essay titled ‘My dream: What I want to be in the future.’ Senator Obama wrote ‘I want to be a President,’ she said.” [The Los Angeles Times, 3/15/07]
In addition, Obama told his brother
‘I think I’d like to teach at some point in time, and maybe run for public office,’ recalls Robinson, who assumed Senator Obama meant he’d like to run for city alderman. “He said no — at some point he’d like to run for the U.S. Senate. And then he said, ‘Possibly even run for President at some point.’ And I was like, ‘Okay, but don’t say that to my Aunt Gracie.’ I was protecting him from saying something that might embarrass him.”
His Harvard law classmates also report that Obama frequently talked about becoming President.
3. believes that he or she is “special” and unique and can only be understood by, or should associate with, other special or high-status people (or institutions)
For this one the shink need look no further than Obama’s denigration of working class people as “bitter,” gun-toting religious nuts who are too stupid to see his wonderfulness. And of course he made these remarks in front of group of wealthy elitist snobs in San Franciso’s most hoity-toity neighborhood.
4. requires excessive admiration
Obama’s appearances before huge audiences, his desire to speak in front of the Brandenburg Gate in Germany like Ronald Reagan did as President, his encouragement of a rabid, cult-like following all demonstrate this need in Obama.
5. has a sense of entitlement, i.e., unreasonable expectations of especially favorable treatment or automatic compliance with his or her expectations
This one is easy. Obama acted like he had won the nomination after his win in the Iowa caucuses; after he lost in the New Hampshire primary, he still encouraged his followers to call on Hillary Clinton to drop out of the race. After Super Tuesday, he assumed that the nomination was his and urged his followers and the compliant media to demand that that Clinton must quit because she was hurting his chances in November. Meanwhile, Hillary won Ohio, Rhode Island, Texas, Pennsylvania, West Virginia, Kentucky, Puerto Rico, and South Dakota, while Obama was on a downhill slide. Now that Obama is the “presumptive nominee,” he is acting as if he is already President and expecting to be treated as such by foreign leaders and the media.
6. is interpersonally exploitative, i.e., takes advantage of others to achieve his or her own ends
See above references to numerous people who were supportive of Obama for many years and then were thrown under the bus without a second thought.
7. lacks empathy: is unwilling to recognize or identify with the feelings and needs of others
Evidence for this one: Obama’s treatment of the voters of Florida and Michigan as well as his dismissal of working class voters in Pennsylvana, Ohio, West Virginia, and Kentucky.
8. is often envious of others or believes that others are envious of him
This one is harder to support with clear evidence, but in my opinion, Obama is very envious of the Clintons, because they are able to outshine him. One example of this was Obama’s angry resentment after Hillary crushed him in the Pennsylvania debate. He just couldn’t resist denigrating her, brushing her off his shoulders and shoes, and giving her the finger. Because he envies the Clintons, Obama imagines that they are equally resentful of his success. He just can’t imagine that Bill and Hillary might be unselfishly working for the good of their party and their country, despite Hillary’s “loss” in the primaries.
Obama is now treating John McCain like he treated the Clintons, denigrating him, accusing him of racism and pushing false and unfair smears against Obama. For example, in his announcement in Minneapolis that he was the nominee of the Democratic Party, he complained:
I honor [John McCain's] service, and I respect his many accomplishments, even if he chooses to deny mine.
Huh? Exactly what accomplishments are those, Barack? And when did McCain “deny” them?
(9) shows arrogant, haughty behaviors or attitudes
For this one, I would recommend that Obama’s shrink read this blog post on Obama’s body language and watch two videos recommended by the body language expert. These videos also demonstrate Obama’s narcissistic rage and resentment toward Hillary Clinton.
NOTE: The body language article and the videos were recently cited by Confluence commenter bmc. Thank you for identifying yourself in the comments. I tried searching the comments where I got the links, but just couldn’t find it.
I’m sure you brilliant Conflucians can think of plenty of other examples that demonstrate Barack Obama’s malignant narcissism. Please feel free to share them in the comments.
from dockera.com via art or porn
Pleasurists is your round-up of the adult product reviews that came out in the last seven days from bloggers all around the sex blogosphere. Did you miss Pleasurists #33? Read it all here. Do you have a review for Pleasurists #35? Submit it here before Sunday June 28th at 11:59pm PDT. Please re-post this list on your own blog if listed.
Note: Monday the 29th is the editor’s birthday, Pleasurists #35 may be delayed next week.
Want to win some free swag? All you’ve got to do is enter.
- Christmas in July Deadline: June 24th at noon EST
- Vibrator Horror Story Contest Deadline: June 26th
- Name That Sex Toy! Deadline: 11:59 PST June 26th
- Summer Lust Contest! Deadline: June 28th, 2009 at 11:59 p.m. PST
- Cheebras Pin-Up Contest! Deadline: Entries MUST be received by midnight on July 4, 2009
- Hello Kitty Vibe photo contest Deadline: September 1, 2009
Madame Editrix
On to the reviews…
Editor’s Pick
- Dream Massager G by Sleeping Dreamer
I love this vibrator for it’s power. Yes, these vibrations carry throughout the entirety of my vaginal canal and even vibrate down into my ass. I can feel the vibrator through the mattress, yea, that good. The Dream Massage G is to my vagina what the Hitachi is to my clitoris.
Vibrators
- Acuvibe Mini by Scarlet Lotus St. Syr
- Oui by Sommer Marsden
- Joanna Angel’s Bad Ass G Bullet by Baby Sinead
- Handy Massager Review by Pumpkin Lady
- I Rub My Duckie by Ginger Leigh
- Trinity Vibes Vibrating Silver Bullet by Mistress Says
- Hello Kitty Vibe by True Pleasures
- Slimline G by HotMoviesForHer Sex Toy Crew
- Ben’s G-Spot Smoothie by Beautiful Dreamer
- Rock Chick by Sleeping Dreamer
- Galaxy G-Kit by Ansley Agnello
- Bgee by Ansley Agnello
- Waterproof Slender Probe by Epiphora
- Impulse Hyper Sonic Wand by Domina Doll
Dildos
- Belladonna’s Magic Hand by Scarlet Lotus St. Syr
- Tantus G-Force Wand by Marla Singer St. Syr
- Sunshine Helix Real Tip Rocket by Carrie Ann
- Leo by Ansley Agnello
- Martian Night Spiral Curved e-Glass Dildo by Mistree Says
- DonWand Glass BubbleWand by Erotic Amusements
- Sugar Drop by Beautiful Dreamer
- Raspberry Chunk Juicer by Red
- Curve by Epiphora
- Milkmaid Dildo by Domina Doll on Viviane’s Sex Carnival
Anal Toys
Toys for Cocks
Lube, Massage Oil, Bath Stuff, & etc.
- Sensation Erotic Massage Oil by Sarah
- Spectra 360 Electrode Gel by Red
- Yes Water Based Lube by Red
- Yes Oil Based Lube by Red
- Climax Bursts Toy Cleaner by Carrie Ann
- Fizz Lubricant by Carrie Ann
- Keep It Clean Toy Wash by Adriana
- Energizing Massage Balm by Intimate Organics by HotMoviesForHer Sex Toy Crew
- Shunga Massage Candle, Bath Gel, and Sweet Snow Powder by Carrie Ann
- Wet Originals by Domina Doll
- Wet Together by Red
- The Sensuous Soak Kit by The Countess
- Inttimo Kitty Shave Kreme by Adriana
- Oil of Love – Tangerines and Cream by Domina Doll
BDSM/Fetish
Adult Books/Games
- Supersex by Tracey Cox by Amorous Rocker
- Opening Up: A Guide to Creating and Sustaining Open Relationships by Domina Doll on Viviane’s Sex Carnival
Adult Movies/Porn
- Champion by Scarlet Lotus St. Syr
- Catherine by Backseat Boohoo
- The Joanna Angel Magical Threesome Adventure Experience by Beautiful Dreamer
- Carnal Sensations by J.D. Bauchery
- Sisters by FrzKey
- Sometime Sweet Susan by The Porn Librarian
- by J.D. Bauchery
- Sex Warrior Pudding Collector’s Complete Edition by FrzKey
- Penny Flame’s Expert Guide to Rough Sex by Epiphora
Storage
Miscellaneous
- Fetish Fantasy Inflatable Position Master by Dragon Mage
- Babegloss by Adriana
- The ShockSpot fucking machine by KamaSutronics
Let’s just try speaking a little truth to power… Not in this for what they say or think, really could care less. But its just crazy, the world stops for MJ… In California they pull 3000 police officers to duty so they can do crowd control for 600 people (why didn’t they just deputize the crowd??? Would have saved themselves a ton of money). In the meantime, of MJ’s 500 million half goes to pay off debts, and the rest is split between his mother, kids, and charity… While in court Hank Greenburg former CEO over at AIG walks away with a cool 4.5 billion… (that 4,500 million or about 8 times the ENTIRE Michael Jackson estate ) Sooooo lets just all double down on stupid…. Cause that’s just the way we roll now days. I’m sure now we are not about the money but having Smoky Robertson and Mariah Carey on the same stage live, its not going to hurt your rating card and besides you have the media trumping its own horn… Brooke Shields and the Queen Latifah giving their own emotional send off.
Michael Jackson’s Memorial: Hollywood’s A-List Celebs Brooke Shields, Jennifer Hudson, John Mayer, Al Sharpton – ABC News
At his public memorial service today in Los Angeles, the King of Pop, Michael Jackson finally got his wish: to be treated like royalty.
Pop star sings the Jackson 5’s 1970s hit.Celebrities from around the world descended on Los Angeles’ Staples Center to pay tribute to Jackson. Kobe Bryant, Wesley Snipes, Spike Lee and Smokey Robinson were among the first stars to arrive. Robinson started off the ceremony by reading condolences from friends including former South African president Nelson Mandela, Kobe Bryant, Wesley Snipes, Spike Lee and Smokey Robinson and soul legend Diana Ross.
Seriously if the people in control over at AIG wanted to save the company, it might make sense to put the man who built the company (Hank Greenburg) back at the helm (Worked with Steve Jobs Apple doing better than ever)… Instead they had rather sue Hank and gives themselves another hundred million dollars in bonuses, (talk about your rocket scientist)… So let’s see what these geniuses have done (besides buying off congress and sticking to Joe taxpayer) Maybe losing a multi-billion lawsuit and trying to sue their former founder or maybe just driving the company a hundred billion dollars into debt, or perhaps the idea of selling some of the most prime prized real estate in the world at near or at record low levels (Wonder how these guys do it!) … Wow we really need to hang on to talent like that. But seriously they are not in it to save the company, why? Of course they are too big to fail… Only people who gets screwed in this deal is the American TAXPAYER. So why not give them those big bonus checks… Let’s all just double down on stupid, makes perfect sense in this Wacko Jacko world in which everything is upside down and backwards so it must be right. Michael was not really nuts just the perfect reflection of “We are the World” weird as ever.
Still there is no accounting for any of how these billions of dollars in monies are spent. There is an extremely difficult effort in the works to make some of this information available to the general public at large on how public officials soak the public coffers.
Sunshine for Senate | GoUpstate.com | Spartanburg Herald-Journal | Spartanburg SC
If you want to see how our congressional representatives and senators are handling their budgets for staff salaries, travel and office expenses, you can. It’s public knowledge. All you have to do is travel to Washington, D.C., go to a Capitol office building and peruse one of the printed volumes of expenses, or order one of the tomes for yourself.
The information is public, it’s just not accessible, and for most of us that means it’s not truly available at all.
That’s wrong and, hopefully, changing.
Last month, House Speaker Nancy Pelosi ordered the House’s chief administrative officer to post House members’ expense reports online as soon as possible. The information is currently expected to be released on the Internet no later than Aug. 31.
Now, the Senate is also planning to begin posting the information online. The change is being pushed by Sen. Tom Coburn, R-Okla., who said taxpayers should be able to see how lawmakers allocate their budgets, and hold their feet to the fire when appropriate.
Still this is just a small step in addition to what is truly needed is an overhaul of the entire mess… The Psychic News cam across this letter from, perhaps, one of the most important congressional districts in the country. Florida’s 18th Congressional District is not only important because of its wealth but its poised upon the critical issues of our time, climate change, our national parks (our national treasures) and the health care future of the large immigration population areas of our nation … When Rep.Ileana Ros-Lehtinen writes a letter you better believe I listen and think you should too
With Power Comes Responsibility, Why We Must Audit the Fed
Dear Friends:
I have joined a majority of the House, 245 of 435 members in co-sponsoring the Federal Reserve Transparency Act. It directs the independent Comptroller General to complete, before the end of 2010, an audit of the Federal Reserve System and of the federal reserve banks, followed by a detailed report to Congress.
Over the last year, the Federal Reserve has taken on the major role in dealing with our nation’s unusual and overwhelming financial squeeze. For the first time in over 50 years, the Federal Reserve expanded its lending to non-bank financial firms. As a result of the Fed’s new lending its balance sheet increased significantly, from $874 billion on August 1, 2007, a date shortly before the financial system first experienced turmoil, to $2.312 billion at its peak on December 17, 2008, an increase of 165%.
Among this new lending was the Fed’s $29 billion loan to have JP Morgan buy the assets of Bear Stearns, a $120 billion bailout of the American Insurance Group, a guarantee of $306 billion in assets of Citigroup, and a similar guarantee on $118 billion in Bank of America assets. In all of these agreements, the Fed and the American taxpayer has been exposed to a greatly increased financial risk if the assets purchased or guaranteed fall in value.
This incredible $1.5 trillion increase in lending by the Federal Reserve is backed by you the American taxpayer. This huge amount of spending gives the Fed, an unelected appointed institution, a tremendous amount of power to influence your family, job and financial security far beyond what most had ever thought possible. With this power must come more responsibility, accountability and transparency by the Fed to you and the other taxpayers.
If the Fed is going to print over one trillion dollars that the US taxpayer can’t afford, I think we have a right to know exactly who they are giving this money to and how much. It’s time for the Fed to open up its books to an independent audit conducted by Congress’s budget watchdog, the Comptroller General.
Sincerely,
Ileana Ros-Lehtinen
Member of Congress
Amen Give them hell Ileana or at least let them know what to expect when they get there! Still what lies ahead is not easy… We have a long road to recovery but we can make it if we try. Came across this clip the other day, it captures something of the human spirit that is incredibly powerful…
In a bit of a side note in memory of a local hero
Articles
Lymphoma claims giant in Spartanburg cycling
Founder of Assault on Mt. Mitchell stayed humble, helped others reach goals
John Bryan brought thousands of people to Spartanburg by organizing and promoting the Assault on Mt. Mitchell.By Dudley Brown
dudley.brown@shj.comThe patriarch of Spartanburg’s cycling community has died.
More Photos:* Bike pioneer John Bryan
John Bryan, founder of the annual Assault on Mt. Mitchell, died Saturday after a seven year bout with lymphoma. He was 74.
“He was a gentle man and cared about all cyclists and all aspects of cycling,” said Marly Divver, a cyclist and friend of Bryan’s family.
Thousands of people have come to Spartanburg over the past 30 years to ride what cycling magazines consider one of the 10 toughest rides in the United States. People from the Philippines, Great Britain and locations around the globe have ridden 102 miles en route to, at 6,684 feet, the highest peak east of the Mississippi River.
Jeff Scurran ▪ Head Coach / OC Santa Rita High School Tucson, AZ
Coach Jeff Scurran’s current record as a high school and college coach is
231-75. In 2007 he was selected by the Arizona Republic as the state’s Large
School Coach of the Year for taking the Santa Rita Eagles from 0-10 to 11-2,
the biggest turnaround in state history. Coach Scurran has been State Coach of the
Year four times and 14 times at the district or local level. Scurran is arguably most famous in his hometown of Tucson and throughout much of Arizona for his career as the highly successful head football coach of the Sabino Sabercats at Sabino High School from 1988 through 1999. Scurran turned what was once a failing program into one of national stature. He won three state titles in 12 years at Sabino, dominating Arizona’s 4A football division for almost a decade.
John Storey ▪ Assistant Head Coach / Defensive Line Villa Angela St. Joseph Cleveland, OH
John Storey is head coach for football and wrestling at Villa-Angela Saint Joseph High in Cleveland, Ohio. Before returning to his alma mater, he coached football and wrestling for 30 years at Saint Joseph High. Storey has coached 23 players who reached the NFL such as, Desmond Howard, Heisman Trophy winner and Super Bowl MVP and Bob Golic, Cleveland Browns. Storey was inducted into the Ohio High School Wrestling Hall of Fame on March 1, 2008.
Greg Patrick ▪ Defensive Coordinator / Linebackers Valley Christian Chandler, OH
Greg Patrick, a former professional football player, has six years experience as defensive coordinator for Valley Christian High School in Chandler, Ohio. During this tenure, Patrick and his team have been very successful, reaching the state semi-finals three times and won the Arizona State Championship in 2005. The team has set the state record twice for YPG allowed, PPG allowed, turnovers forced, and defensive scoring. Patrick was AIA Defensive Coach of the Year in 2005 and coached the North / South All-Star game in 2006.
Kevin Amidan ▪ Offensive Line Santa Rita High School Tucson, AZ
As a four-year varsity player under head coach Jeff Scurran, Kevin started three consecutive state championship football games in Arizona, winning one and then went on to play for Coach Scurran at Pima Community College. He coached the offensive line at Pima Community College as the team finished fifth in the nation and was victorious in the Pilgrims Pride Bowl in Texas. At Santa Rita High School, he and coach Scurran took over a 0-10 program and finished the year 11-2 playing in the state semi finals.
Mike Rogers ▪ Defensive Backs Graves County Fern Creek, KY
Coach Rogers’ record as a high school coach is 30-17. Rogers has had more than 50 players go on to the collegiate level and in excess of 200 academic all state players. In 2005 and 2006 the Kentucky High School Football Associated named Rogers Assistant Coach of the Year while at Nelson County High School with a career record of 73-25. In 2002, Rogers was named Assistant Coach of the Year by the Greater Louisville Football Coaches Association.
Tom Sullivan ▪ Receivers Marion County Lebanon, KY
After graduating from the University of Evansville, where he was a four-year letterman at tight end and punter, Sullivan began his coaching career at Monroe County High School, KY, helping to guide the school back to the State playoffs in 1997. In March of 1998, Sullivan coached DJ Burchett to a USA Powerlifting High School National Championship, setting 3 national records. As Head Coach at Marion County he lead the team to best record in 8 years in 2002 then moved on to Campbellsville University in 2003 where he coached running backs. After the 2003 season he went to Anderson County High School to turn around a losing program.
Don Holl ▪ Running Backs Cathedral Prep Erie, PA
Don Holl has led Cathedral Prep to an overall record of 29-9 in his three seasons at the helm, including three consecutive District 10 titles and appearances in the Pennsylvania State AAAA quarter-finals. At Tunkhannock Area High School, he took a winless team to an Eastern Conference playoff berth in three seasons and to the championship in four. As Offensive Coordinator at Division 2 Gannon University, Holl’s offenses set more than 100 school records and were ranked in the top 20 nationally for three consecutive years, including leading the nation in rushing in 2001. Holl has served as an assistant in the Pennsylvania East-West Game and is a noted regional and national coaches clinic speaker.
Jose Duran ▪ Equipment Manager Santa Rita High School Tucson, AZ
Jose has an associate degree from Pima Community College and is pursuing his Bachelors in Business Administration and Marketing from North Arizona University and Bachelors in Psychology from Ashford University. Since 2007 he has been the head equipment manager for football at Santa Rita High School in Tucson, Arizona.
Since 2006 he has been the Director/Coach for the Arizona Girls Wrestling Team for USA Wrestling and an assistant coach for Sunnyside High School in Tucson, Arizona. Jose belongs to the Athletic Equipment Managers Association and has been an assistant coach for football and wrestling since 1985.
Susan Wilson ▪ Athletic Trainer
Susan Wilson received a BS Physical Education degree from Simpson College, Indianola, Iowa. In 2001, she received a Masters of Arts in Exercise Physiology from Minnesota State University. In 2002, while she was athletic trainer at Mankato West High School, the football team became 2002 4A State Football Champions. She is currently Athletic Trainer for Johnston High School, and this past 2007 season the volleyball team became the 4A State Volleyball Champions. Wilson is also licensed by National Academy Sports Medicine Performance Enhancement Specialist.
Patrick Steenberge ▪ Team Manager Global Football Granbury, TX
A native of Erie, PA, Patrick Steenberge played quarterback and lettered two seasons under Coach Ara Parseghian at Notre Dame, while earning his marketing degree. He boasts more than 35 years of business background, having specialized in communications, special events production, and marketing. Under his leadership, Global Football Inc created and managed the NFL Global Junior Championship at Super Bowls from 1997 to 2007, the Aztec Bowl in Mexico since 1997, the Volcano Bowl at the NFL Pro Bowl from 1998 to 2000, and the Global Youth Jamboree in 2004. He has also orchestrated football tours to England, France, Norway, Sweden, Finland, Russia, Germany, Austria, Ireland, France, Spain, Italy, Canada, Panama and Mexico. In 2003 he introduced the Notre Dame Football Fantasy camp, providing dreamers with the chance to live their fantasy of actually playing football at Notre Dame. A similar fantasy camp was established at Penn State in 2006. Patrick helped coordinate the Notre Dame Alumni Football Team Tour and Game in Hamburg, Germany in July 2000. He has developed working relationships with the top football organizations in the world, including: American Football Coaches Association (AFCA), NFL International, USA Football, Pop Warner Little Scholars, Inc., European Federation of American Football (EFAF), Mexican Federation of American Football (FMFA), American Football Federation of Japan (AFAJ), National Football Federation of Canada (NFFC).
Michael Preston ▪ Media Relations Preston Consulting Norwood, MA
A native of Birmingham, England, Michael Preston has more than 20 years of experience in the world of public relations and journalism. Having been a newspaper sports editor and a press officer for several UK sports clubs, he was the Assistant Director of Public Relations for NFL Europe from 1997 to 2002. Under his leadership, Massachusetts-based Preston Consulting has built a client base that includes the National Football League, Arena Football League, Soccer United Marketing and Fathead. He specializes in promoting youth sports events and has undertaken projects in 10 countries, on three continents and at nine Super Bowls.
Player bios
2 ▪ Marquese Wheaton RB / CB Mountain Pointe Maricopa, AZ
Marquese was invited to the 2006 Army Bowl Combine as one of the best in the country in his junior year. He was the MVP for cornerbacks at the Nike Combine Invitational in Denver Colorado. In 2007 he was a participant at the USA Track & Field medaling in the 200, 400, 800, 4×100, 4×400 and 4×800 meters. He led Mountain Pointe High School in interceptions, rushing, and scoring for the last two seasons. Marquese is listed as one of the best players in Arizona football on both sides of the ball.
3 ▪ Mike Snively FB / FS Santa Rita High Tucson, AZ
Mike has played football for 11 years. For the past two years the teams he has played on made it to the State Finals and the State Semi Finals. This past season he was awarded All Purpose Player of the Year for his region and an honor mention for all of Southern Arizona.
5 ▪ Joe Chiusano FB / DE Santa Rita High Tucson, AZ
In 2007 season, Joseph Chiusano, a three year varsity starter of Santa Rita High School, recorded 68 tackles, 8 sacks, 2 forced fumbles, and 3 fumble recoveries. He is 6 feet tall weighing 218 pounds. He has been named two time all region and all city selection. Chiusano will be playing Division three football next fall.
7 ▪ Daniel Nicholas QB Canyon Del Oro Tucson, AZ
In the 2007 season, quarterback Daniel Nicholas of Tucson, Arizona, led his Canyon Del Oro High School football team to their first state championship game in thirty years. He threw 2,084 yards for 26 touchdowns and ran 700 yards for 10 touchdowns. Nicholas was named Southern Arizona Player of the year.
8 ▪ David Thompson RB / LB Sheyboyan North Sheyboygan, WI
Senior David Thompson was a three year starter at Sheboygan North High School in Sheboygan, Wisconsin. His versatile play as running back and defensive back was rewarded by receiving the title of team MVP. He was also named to the Sheboygan County Dirty Dozen All Area Team.
10 ▪ Michael DiGiangi PK / DB Highland High Gilbert, AZ
Michael was brought up from the age of only a few months old with a bat in his hands and a ball at his feet and did not expect to give up give up baseball and soccer for football. His soccer skills transferred to football, making him a kicker in his sophomore year. As a junior, he was All-Region with 22 touchbacks and a longest field goal of 47yards. He has kicked field goals of 57 yards and 60 yards in practice and pre-game. He enjoys working out, along with sports, cars, music, other hobbies, staying active, going out with friends and meeting new people.
11 ▪ Mike Parsons FB / LB / SS Erie Cathedral Prep Erie, PA
Mike Parsons, a three year varsity athlete of Cathedral Preparatory School in Erie, Pennsylvania, recorded 212 tackles, 15 sacks, 6 forced fumbles, and 5 fumble recoveries in two seasons of play. His junior year, he had 120 tackles making him Fourth in school history for tackles in a season. Junior and Senior year he was named All-State, First Team All-District and All-Region, and became a member of Keystone Club for having over 100 tackles. Senior year he was named member of the All Nike Combine team and was awarded the Pat Czytuck award.
14 ▪ Taylor Ward WR / CB Seven Lakes Katy, TX
Taylor plans to attend Texas A & M University and major in Geography and Geology. He plays high school soccer and basketball, plays the guitar, led the Fellowship of Christian Athlete huddle at school, and played in the Max Emfinger All-American Bowl Game in Jackson, Mississippi January 5, 2008. His favorite soccer club is Liverpool of England. His favorite players are Steven Garrard of Liverpool and Shunsuke Nakamura of Celtic. He also enjoys playing Guitar Hero! He was a finalist for the Houston Touchdown Club Scholar Athlete Award.
15 ▪ Chris Miller RB / LB / SS Salpointe Catholic Tucson, AZ
Chris Miller, an AP scholar and three-year varsity athlete, led his Salpointe Catholic High school to become D. 5A-1 Southern Arizona Champions and was named Arizona Star player of the game. The three-sport athlete, ice hockey and track and field star is also an active volunteer for community services including Red Cross, Gospel Outreach, Nogales Blanket Drive, and Recycle Club.
20 ▪ Scotty Smith P / WR Davis County Owensboro, KY
In the 2007 season, Scotty Smith had 87 receptions for 1341 yards and 12 touchdowns. He was top 3 in the state of Kentucky for receptions and total yards received. He received multiple awards for his performances including; All Big 8 wide receiver, Messenger-Inquirer Offensive Player of the year, First team Owensboro Messenger Inquirer wide receiver, Associated Press Second team All State wide receiver. While attending Davis County High School in Owensboro, Kentucky he was a four-year varsity letter athlete breaking the school record for most receptions and yards received in a season.
21 ▪ Clint Smith DB Santa Rita High Tucson, AZ
Clint received a scholar athlete award all four years of his high school career at Santa Rita with a GPA of 3.83. He also received an honorable mention for the 4A Gila Region as a strong linebacker. He enjoys spending time with friends, going to movies, and playing football.
22 ▪ Troy Smith RB / LB Santa Rita High Tucson, AZ
Smith was the Special Teams Captain for a Santa Rita Eagles team that went from 0-10 to 11-2 in 2007. He is the State Vice President for Arizona DECA. He also received the scholar athlete award during every year of high school and is currently maintaining a 3.9 GPA. In his junior year he received an honorable mention as a running back.
23 ▪ Tyler Lincoln RB / OL Juda High Juda, WI
In the 2007 season, senior captain Tyler Lincoln, a four-year varsity player of Juda High School, rushed for 1,486 yards and 15 touchdowns helping his team reach the fourth round of the WIAA playoffs. He averaged 9.12 yards per carry on 163 attempts. He made Rock Valley first team all-conference as a running back and Wisconsin State Journal second team all-conference.
24 ▪ Troy Roffi RB / SS Valley Christian Tempe, AZ
Troy was an Arizona-All Region and All State selection in the 2006 and 2007 seasons. He was the Valley Christian team captain in 2007. He has 1,888 career rushing yards and 30 career touchdowns in addition to 8 career interceptions. He helped his school to the Arizona 2A State championship in 2005 and was the 2A State runner-up in 2006.
25 ▪ Akeem Satterfield RB / SS Erie Cathedral Prep Erie, PA
In his senior season, Satterfield was the senior captain of the Cathedral Prep team and had 1.816 rushing yards, 27 rushing touchdowns on 221 carries, 279 receiving yards from 21 receptions and 2 receiving touchdowns. He also returned 8 kickoff returns for 190 yards. Akeem made First team All-State as a running back in Pennsylvania, First Team All District Ten, and was selected to play in the Pennsylvania East-West All-Star Game. His strengths are speed, power, cutting ability and vision.
29 ▪ Nick Viola RB / LB Villa Angela St. Joseph Wickliffe, OH
Nick is a three-year letter winner from Villa Angela-St. Joseph High School in Cleveland, Ohio. As a junior he was nominated Team Captain and MVP. His senior year he was also named Captain, and ended the season with awards for First Team All-State and Northeast Ohio Inland Defensive Player of the Year. His second sport is wrestling, in which he is also a three-year letter winner. In his spare time Nick enjoys training in martial arts and working with animals.
31 ▪ Jake Thompson FB / DE Marion County Lebanon, KY
Senior Jake Thompson, a four year starter, played fullback and defensive end at Marion County High School in Lebanon, Kentucky. He has played almost all defensive positions, and was awarded the Freshman MVP, Defensive JV award his sophomore year, and most sacks in his senior year. His senior year performance was honored by being chosen to play in the state East-West game.
32 ▪ AuBura Taylor RB / DB Santa Rita High Tucson, AZ
Senior AuBura Taylor, a four-year athlete, helped the Santa Rita Eagles team improve from a 0-10 record to 11-2 in 2007 season. His senior year he was named All-state and All-City player. He can bench press max of 275 pounds, squat press at 405 pounds, and can do the 40-yard dash in 4.3 seconds. Taylor loves the game of football, and always is looking to play the best team at that time. Taylor also played four years of basketball.
33 ▪ Darius Petraitis OG / DL Villa Angela St. Joseph Cleveland, OH
Born and raised in Cleveland, Ohio, Darius originally grew up as a soccer player before migrating to football in grade school. He played all four years in high school, and also wrestled as well. He lettered in football and wrestling. Darius was selected second team North Coast League as a senior and also earned a defensive-line award. His hobbies are attending sporting events, hunting, fishing, and reading, particularly unsolved mysteries, and history of other countries.
35 ▪ Joe Zambito RB / LB / DB Notre Dame Prep Detriot, MI
Joe was an All League Award and All Catholic Award, Intersectional I 2005 and an All League Award and All Catholic Award, Intersectional I 2006. Joe received an All County Honorable Mention in both 2005 and 2006 when as a junior and senior had 13 games of more than 100 yards, averaged 6.8 yards a carry, and 26 touchdowns. He averaged 34.5 yards per kick return. Defensively, Joe recorded four interceptions at outside linebacker, returning one for a touchdown. He was the team captain his senior season in 2006 when Notre Dame Prep finished with an 8-2 record.
36 ▪ Tony Martin RB / SS Somerset High Somerset, WI
Tony Martin was all-conference in three different positions, at running back, inside linebacker and punter, and was all-region as a running back and linebacker. He was also an honorable mention all-state player at both those positions. He is a state qualifier for wrestling and likes to weight-lift all the time. Tony likes to be very motivated, to be the best he can be and loves a challenge.
41 ▪ John Pokorny RB / LB Villa Angela St. Joseph Euclid, OH
A three-year varsity letter winner in football, John received the following awards as a senior: the Vogel Award for the highest GPA of all fall sport participants, a nomination to represent his school for the Wendy’s High School Heisman award for scholarship, athletics and citizenship, and was named to the honorable mention list of the North Coast Football League. He received the following football-related scholarships; the Clark, Blaine, Clark Memorial Scholarship for exhibiting Viking loyalty, character, team commitment, personal leadership and outstanding athletic ability. The Tom L. Fink ’87 Memorial Scholarship was awarded to John for demonstrating outstanding zeal, enthusiasm and commitment to student life, as well as a passion and commitment to study, work and sports. He is also a four-year varsity letter winner in wrestling, having won more than a hundred varsity victories. A member of the National Honor Society.
42 ▪ Matt Groudle OG / DT Villa Angela St. Joseph Euclid, OH
Matt was the MVP of the wrestling team in his junior year at Villa Angela St Joseph. He was also one of the school’s few junior captains on the team. Despite his smaller stature for a lineman at 5-9 tall, he and the St. Joes Vikings always play with heart which is where their game thrives.
43 ▪ Jordan Ralph TE / LB Gibson Southern Haubstadt, IN
In 2007 season, senior captain Jordan Ralph of Gibson Southern High School in Indiana led his team to a 7-3 record. He was named All-County, All-Conference honorable mention, and Academic All-State. During his junior year, he received the Iron Man Award and was defensive captain.
45 ▪ Riley Bushman LB Sabino High Tucson, AZ
In the 2007 season, senior Riley Bushman helped his Sabino High School football team to a 10-1 record and had 22 tackles, three sacks, and one interception. One of the best games of the season for him was against Amphitheater where led his team to a victory with 8 tackles and one sack. Bushman also was a factor offensively for the team. He had 4 receptions totaling 104 yards.
52 ▪ Brandon Young DE DuPont Manual Louisville, KY
A two-time All-district defensive end and three year starter, Brandon was picked for pre-season tremendous 26 for the State of Kentucky. He was named defensive MVP his senior year as he led the DuPont team that finished 10-2 and made it to the second round of the state 6-A playoffs. A fierce rusher with speed and agility, he is able to disrupt the pass or run. Brandon has committed to North Carolina A&T University and is projected to compete for time in the defensive rotation.
55 ▪ Davis Jayroe LB Christ School Georgetown, SC
In 2007 season, Senior Davis Jayroe of Georgetown, South Carolina led Christ School, Asheville, North Carolina, to the semi-final round of the state playoffs. Jayroe was senior head of special teams and inside linebacker. Jayroe, a two-sport athlete, was also head captain of his wrestling team. He plans to attend Coastal Carolina University.
56 ▪ Will Cassidy DL The Bolles School Jacksonville, FL
Will finished his senior year at The Bolles School under Florida’s all-time winning high school coach and winner of six state championship Corky Rogers. He returned after helping Bolles earn the Florida 2A State Championship in 2006. The Bolles football team ended the 2007 season 11-1. Will possesses good height and weight as a defensive tackle, and is extremely quick off the ball. In Will’s junior and senior years he racked up 134 tackles, 7 sacks, 12 quarterback pressures, 4 knock downs, 1 forced fumble and 1 fumble recovery. Will ended his senior year as a three year varsity starter and a four year football letterman at Bolles. Will won two state championships and regional championships and four district champions and has also lettered in wrestling, and lacrosse. Will is been involved in both church and community initiatives.
57 ▪ Jon Harms C / NG Graves County Mayfield, KY
Senior Jonathan Harms started four years of varsity football at Graves County High School in Mayfield, Kentucky. From 2005 to 2007, Harms was named First team All Western Kentucky Conference. He was also named to the first ever Pepsi Mid-America All-Star Team.
58 ▪ John Earl C / DT Evangel Christian Shreveport, LA
John Earl, a senior at Evangel Christian High School, played left tackle on offense and defense. In the 2007 season, he led his team to the semi-finals. The same season he received all-district and all-state honors for his performances at offensive left tackle. John also made the academic all-state team.
65 ▪ Rob Moran OL / DL Sacred Heart Prep Portola Valley, CA
Senior captain Rob Moran led Sacred Heart Prep to its first-ever Northern California playoff berth. His performances in his junior and senior year were recognized by him being named First Team All-Bay Football League. His senior year, starting as offensive and defensive tackle, he was named MVP lineman, First team All-Peninsula, First Team All-County.
66 ▪ James Hanson C / DT Catalina Foothills Tucson, AZ
James weighs in at 185 pounds and stands 6-2 tall. In addition to playing at center on the offensive side of the ball and at defensive tackle, he also performs long-snapping duties. He has been selected as a Kino Region Honorable Mention Offensive lineman.
70 ▪ Billy Deane OG / DE Adams Friendship Adams, WI
In the 2007 season, Senior Billy Deane, a four-year starter at Adams Friendship High School, received First Team All-Conference Offensive Lineman and Defensive outside Linebacker, All-region award for Offensive Lineman, and school award of Outstanding Lineman. His junior year, Deane received First Team All-Conference Offensive Lineman and second team All-Conference Defensive-Lineman. Deane also played four years of basketball. He volunteers at a local aging center, coaches middle school children, and joined the Knights of Columbus.
71 ▪ Burt Geurkink OL / DE Somerset High Somerset, WI
Burt enjoys playing several sports, including football, and will attend Eau Claire next year and play football. He was the conference player of the year at Somerset High School, named all-conference both on the offensive line and defensive line, and was all-region and all-state playing both ways. Burt likes to work hard and weight-lift and plays basketball, baseball, and runs track.
72 ▪ Adam Rogers C Santa Rita High Tucson, AZ
Adam was born in Tucson, Arizona but moved to Texas while young. He played football in Texas for three years and in Indiana for four years. In Indiana he was also a member of the Noblesville Middle School swim Team and excelled in the butterfly. He returned to Tucson in 2006 and made Gila Region Honorable Mention for the offensive line in 2006 and 2007. Currently he is on the Santa Rita High School track team throwing discus and shot-put. He plans to attend the University of Arizona, majoring in Electrical Engineering. Adam enjoys weightlifting, racquetball, video games, and tinkering with his car.
73 ▪ Alex McGillivray OL Salpointe Catholic Tucson, AZ
Alex is a lineman who stands 6′4 and weighs in at 295lbs. He plays as a defensive tackle and nose guard for Salpointe Catholic High School. He has played two years of varsity football and next year will be going to Adam’s State University in Alamosa, Colorado to major in wildlife biology and coaching.
74 ▪ John Kredit OL / DL Valley Christian Phoenix, AZ
John was an all-region selection both his junior and senior year and was selected first team all-state as a senior. His Valley Christian team won the state title once and was runner up twice, in addition to a semifinal loss, during his four years playing football. John played in the Sonoran Bowl against an all-star team from Mexico in January. He also participates in track and won a state title in shot put and discus his junior year and hopes to defend both titles this year.
75 ▪ Paul Perez OL / DL Santa Rita High Tucson, AZ
In the 2007 season Paul Perez, offensive and defensive line captain of Santa Rita High School, led his team to the regional championship with an overall record of 11-2, the best record in school history. Perez was named All Region Offensive-Line, honorable Mention Defensive-line, and second team All Southern Arizona Offensive-Line. With a 3.96 GPA, he also participates in other extra-curricular activities, such as; National Honor Society, DECA Chapter President, wrestling, and track. Perez was also the recipient of the National Football Foundation and College Hall of Fame Scholar Athlete award.
77 ▪ Blaine Russ OL / LG / LT Evangel Christian Shreveport, LA
Senior Blaine Russ was a two-year starter at Evangel Christian High School in Daytona Beach, Florida. Russ has led the very successful football team to three consecutive state championship wins. Russ won his freshman, sophomore, and junior years. Russ has also received the honors of all-district, all-city, and all-state.
84 ▪ Jon Hobbs TE / DE Daytona Mainland Daytona Beach, FL
Jonathan began playing football at the age of 14 as an eighth grade junior varsity quarterback at Coral Springs Christian Academy. He transferred to JP Taravella high were he spent two seasons playing defensive end and tight end for the Trojans. Jon was relocated to Hollywood, FL were he won a state championship with the Chaminade Madonna Lions. Finishing his high school career, he transferred to Mainland high school, where he played defensive line and offensive line on an undefeated district championship team. In his final season Jonathan was awarded with the Brian Brokaw animal award, the Ironman award, the Honor Roll award, and was selected to play as a first team All-County offensive lineman in the Volusia County All-Star game. He aims to play for a division one school.
One of my customers had this requirement – producing a SQL statement dynamically whose text length is over 300KB(Do not blame me for this).
Their first PL/SQL code was like following.
(Let me tell you this is a very simplified version of their code)
UKJA@ukja1021> create or replace function make_long_sql(p_idx in number) 2 return clob 3 is 4 v_clob clob; 5 begin 6 v_clob := 'select '; 7 for idx in 1 .. p_idx loop 8 v_clob := v_clob||to_char(p_idx)||', '||to_char(p_idx+1)||','||to_char(p_idx+2)||','; 9 end loop; 10 v_clob := v_clob || '1 from dual'; 11 12 return v_clob; 13 end; 14 /Function created.
No special things. The code is just concatenating CLOB variable with a couple of strings.
But the performance was very disappointing. Following code takes 46sec.
UKJA@ukja1021> exec :c := make_long_sql(10000);PL/SQL procedure successfully completed.Elapsed: 00:00:46.00
Their actual PL/SQL code took over 5 minutes to make 150KB of SQL text. So they called me for help.
My prescription was to use temporary VARCHAR2 variable instead of direct CLOB concatenation, like following.
UKJA@ukja1021> create or replace function make_long_sql2(p_idx in number) 2 return clob 3 is 4 v_clob clob; 5 v_varchar varchar2(1000); -- Note this 6 begin 7 v_clob := 'select '; 8 for idx in 1 .. p_idx loop 9 v_varchar := to_char(p_idx)||', '||to_char(p_idx+1)||','||to_char(p_idx+2)||','; -- Use temporary VARCHAR2 10 v_clob := v_clob||v_varchar; 11 end loop; 12 v_clob := v_clob || '1 from dual'; 13 14 return v_clob; 15 end; 16 /Function created.
Here I have a dramatic result. The elapsed time got reduced from 42 sec to 0.5 sec.
UKJA@ukja1021> exec :c := make_long_sql2(10000);PL/SQL procedure successfully completed.Elapsed: 00:00:00.50
Their actual PL/SQL code now takes 5 sec instead of 5 min.
What makes this big difference? V$SESTAT view and V$LATCH view show some hints for this performance variation.
NAME VALUE1 VALUE2 DIFF---------------------------------------- ------------ ------------ ------------session logical reads 17,376,991 133,035 -17,243,956db block gets from cache 15,764,933 102,971 -15,661,962db block gets 15,764,933 102,971 -15,661,962consistent changes 6,024,802 17,697 -6,007,105db block changes 6,024,814 17,710 -6,007,104consistent gets from cache 1,612,058 30,064 -1,581,994consistent gets 1,612,058 30,064 -1,581,994free buffer requested 1,432,143 49 -1,432,094calls to get snapshot scn: kcmgss 480,030 40,019 -440,011lob writes 120,008 10,004 -110,004lob writes unaligned 119,962 10,004 -109,958lob reads 60,001 10,001 -50,000...LATCH_NAME D_GETS D_MISSES D_SLEEPS D_IM_GETS------------------------------ ---------- ---------- ---------- ----------cache buffers chains -45091211 0 0 -1399062object queue header operation -2864253 0 0 0cache buffers lru chain -2864138 0 0 0simulator hash latch -164417 0 0 0simulator lru latch -112459 0 0 -51952...
Do you see the difference between logical reads, LOB reads and LOB writes? Also of the latch acquistion?
Jonathan Lewis has already given a good explanation here.
http://jonathanlewis.wordpress.com/2009/07/09/concatenating-lobs/
There are a couple of things you should keep in mind when using CLOB for producing a big SQL statement, and this post is just abount one of them. I would cover other stuffs in detail next time.
