Search

Top 60 Oracle Blogs

Recent comments

Charles Hooper

TypePostAuthorRepliesLast updated
feedpageThe CURSOR_SHARING Parameter is a Silver Bullet – What is Wrong with this Quote? Charles Hooper08 years 15 weeks ago
feedpageFinding Rows with Common Attributes – Roman to Find a Solution in Something New Charles Hooper08 years 15 weeks ago
feedpageWHERE MOD(ROWNUM,100) = 0 Charles Hooper08 years 16 weeks ago
feedpageFind Objects with the Greatest Wait Time – What is Wrong with this Quote? Charles Hooper08 years 16 weeks ago
feedpageGive Me a Hint – How were These Autotrace Execution Statistics Achieved? Charles Hooper08 years 17 weeks ago
feedpageAddressing TM Enqueue Contention – What is Wrong with this Quote? Charles Hooper08 years 17 weeks ago
feedpageCalculate the Distance Between Two Latitude/Longitude Points using Plain SQL Charles Hooper08 years 18 weeks ago
feedpageRow Lock is Synonymous with TX Lock, and is a Lock on a Single Row of a Table – Verify the Documentation Challenge Charles Hooper08 years 18 weeks ago
feedpageNOLOGGING Option and log file sync Waits – What is Wrong with this Quote? Charles Hooper08 years 18 weeks ago
feedpageV$SESSION’s ROW_WAIT_OBJ# Column Shows the DATA_OBJECT_ID – Verify the Documentation Challenge Charles Hooper08 years 19 weeks ago
feedpageUnique Index Result Error with Ref Cursor on Oracle 11g but Not on 10g Charles Hooper08 years 20 weeks ago
feedpageInsert Error on Oracle 11g but Not on 10g Charles Hooper08 years 20 weeks ago
feedpageReading Material On Order 2 Charles Hooper08 years 20 weeks ago
feedpageRow Values to Comma Separated Lists, an Overly Complicated Use Case Example Charles Hooper08 years 20 weeks ago
feedpageOn the Topic of Technology… 3 Charles Hooper08 years 21 weeks ago
feedpageLarge Page Support or Not – ORA_LPENABLE, Granule Size Charles Hooper08 years 22 weeks ago
feedpageHow to Eliminate Wait Events in Oracle Database? Charles Hooper08 years 22 weeks ago
feedpageHow to Collect Statistics Charles Hooper08 years 23 weeks ago
feedpageAdding Features to PowerPoint Based Oracle Presentation Files Charles Hooper08 years 23 weeks ago
feedpageWhat to Do When Performance Problems Appear Charles Hooper08 years 23 weeks ago
feedpageBrain Teaser: 10046 Extended SQL Trace Shows “EXEC #435118472:c=15600,e=510″, How is that Possible? Charles Hooper08 years 24 weeks ago
feedpageOn the Topic of Technology… 2 Charles Hooper08 years 24 weeks ago
feedpageUsing ROWNUM in the Where Clause Causes Problems Charles Hooper08 years 25 weeks ago
feedpageInvestigating Enqueues Burns CPU Cycles Charles Hooper08 years 25 weeks ago
feedpageSequence Driven Primary Keys – Which is Better: Call NextVal in the Insert Statement or in a Row Level Trigger? Charles Hooper08 years 26 weeks ago