Michael McLaughlin's Friends

  • Prasanna Sahu
  • Darryle Pfauntsch
  • Lisa McClain
  • hume
  • Amitanshu Nayak
  • John Harper
  • Robert G. Freeman
  • Mike Bowers
  • Krishna Nujella
  • Newton Fletcher
  • Cindy Conlin
  • Christopher Jones
  • Kuassi Mensah
  • Shiva
  • Alan Shook
 

Michael McLaughlin's Page

Latest Activity

Michael McLaughlin left a comment for John Harper
"You're already a member. Or, did you forget?"
Oct 12, 2011
Michael McLaughlin posted a blog post

Finished a book on Oracle and MySQL

Looking forward to meeting old and new friends at OOW11. If you want to stop by, I'm in the bookstore at Moscone North on Monday and Wednesday at 9 a.m. for a book signing.See More
Oct 1, 2011
Michael McLaughlin received a gift from Eddie Awad
Nov 18, 2009
Michael McLaughlin and Prasanna Sahu are now friends
Jul 18, 2009
Michael McLaughlin posted a blog post

Curiousity on Latent LOB Columns

I was doing some testing tonight, and discovered something curious on Oracle 11.1.0.7.0. Basically, if you add a CLOB column through an alter statement, drop the table, recreate the table, and try to alter the table again to add the CLOB column it's still there. It is like the table was never dropped, but DBMS_METADATA.GET_DDL and the DBA_LOB and DBA_SEGMENT views don't find it before you try to re-add the column. When you re-create it, you get an ORA-01430. After the error is thrown,…See More
Jul 16, 2009
Michael McLaughlin left a comment for mohit
"Sure, I sent you an email. :-)"
Mar 24, 2009
Michael McLaughlin posted blog posts
Mar 22, 2009
Michael McLaughlin left a comment for mohit
"Mohit, I apologize for the delay in replying, but you got great advice. I think Laurent's is the best starting point - download and play with it. After experimenting with the install, SQL, PL/SQL, RMAN, and OEM, I'd recommend you pick the…"
Mar 22, 2009

Profile Information

About Me:
I teach database technology at BYU – Idaho in the Computer Information Technology Department. I worked at Oracle Corporation for over eight years. While at Oracle, I worked in consulting, development, and support. I created the ATOMS transaction architecture during my doctoral studies (US Patents #7,206,805 and #7,290,056). The patents are assigned to Oracle Corporation. Prior to Oracle, I worked as an Oracle developer, systems and business analyst and DBA beginning with Oracle 6. I'm the author of Oracle Database 11g PL/SQL Programming, Oracle Database 10g Express Edition PHP Web Programming, and co-author of Oracle Database AJAX & PHP Web Application Development, Oracle Database 10g PL/SQL Programming and Expert Oracle PL/SQL.
My Blog:
http://blog.mclaughlinsoftware.com
My Website:
http://www.techtinker.com

Michael McLaughlin's Blog

Finished a book on Oracle and MySQL

Looking forward to meeting old and new friends at OOW11. If you want to stop by, I'm in the bookstore at Moscone North on Monday and Wednesday at 9 a.m. for a book signing.

Posted on October 1, 2011 at 7:42pm

Curiousity on Latent LOB Columns

I was doing some testing tonight, and discovered something curious on Oracle 11.1.0.7.0. Basically, if you add a CLOB column through an alter statement, drop the table, recreate the table, and try to alter the table again to add the CLOB column it's still there. It is like the table was never dropped, but DBMS_METADATA.GET_DDL and the DBA_LOB and DBA_SEGMENT views don't find it before you try to re-add the column. When you re-create it, you get an ORA-01430. After the error is thrown,… Continue

Posted on July 16, 2009 at 11:57pm

Blog'n courtesy - provide print.css

This is just a thought about making our information more accessible. I've adopted a print.css on my main blog to expand all content on an entry and strip unnecessary header, footer, and sidebar information.



Aside from the striping the useless page stuff, a print.css let me unfold all my entries. This was important since I adopted JQuery folding on the pages based on feedback from readers. The folding forces me to reflect a bit more before I post something and hopefully avoids… Continue

Posted on March 22, 2009 at 8:06am

Pipelined Table Functions Examples

When I presented the concept at the Utah Oracle User’s Group (UTOUG) Training Days 3/12-3/13/2009 it became clear the community could benefit from more detail about table and pipelined table functions. I updated my old entry, more or less rewrote it entirely, now there's a 16 page post. Hope you enjoy it.



Also, about a month or so ago I began tweeting. You can find me at MacLochlainn… Continue

Posted on March 22, 2009 at 7:47am

My blog address has changed

I've moved to my own domain for reasons set out in the last blog post on the old site and first directly on the new site. If you've got an iPhone give it a hit and then reflect on using the iPhone plugin on your own blog. I've migrated all the content to the new site and eventually things should forward but I wanted to give you a heads up if you've set an RSS feed to the old site. The new site is… Continue

Posted on November 1, 2008 at 6:33pm

Comment Wall (1 comment)

You need to be a member of Oracle Community to add comments!

Join Oracle Community

At 8:28pm on November 18, 2009, Eddie Awad gave Michael McLaughlin a gift
Gift
Congratulations for your Oracle ACE award. Very well deserved.
 
 
 

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Database hang and Row Cache Lock concurrency troubleshooting

This post will help to analyze Oracle database instance slowdown that can happen due to considerable row cache lock (enqueue) wait events. It’s is based on a real case of a database hang that I worked on recently. I must admit this type of situation does not appear often but it’s very dangerous since it can considerably slow down a database instance or even freeze it for a short period of time. In most cases SQL against ASH view and Systemstate dumps can help to nail down the problem unless…

Continue

Posted by Kirill Loifman on April 15, 2014 at 12:53am

Creating standby database fast and easy

1.PURPOSE AND SCOPE

With 11gR2 rman duplication its really easy to create standby database.

2.PRACTICE

Information

Primary Database SID: PRIM

Primary Database Domain/IP: ABSO

Standby Database SID: PRIM_SBY

Standby Database Domain/IP: CROO…

Continue

Posted by Bugra Canbakal on April 3, 2014 at 10:30pm

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service