<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/'><id>tag:blogger.com,1999:blog-25740336.post114484062921683607..comments</id><updated>2008-01-15T21:05:53.742Z</updated><category term='varchar'/><category term='Fine-Grained Auditing'/><category term='enq: RO - fast object reuse'/><category term='re-posting'/><category term='PeopleTools 8.48'/><category term='scalar queries'/><category term='clob'/><category term='Global Unique Identifier'/><category term='row cache lock'/><category term='Instrumentation'/><category term='Dead Connect Detection'/><category term='Append'/><category term='Recyclebin'/><category term='row source alias'/><category term='Application Server'/><category term='PeopleTools 8.49'/><category term='PSPMSESSIONS_VW'/><category term='QB_NAME'/><category term='unicode'/><category term='performance'/><category term='posting'/><category term='Truncate'/><category term='Stored Statements'/><category term='Application Engine'/><category term='Batch Timings'/><category term='scalability'/><category term='Hints'/><category term='Report Reposiory'/><category term='Restartability'/><category term='local write wait'/><category term='Stored Outlines'/><category term='SQL Server 2005'/><category term='global temporary tables'/><category term='SQR'/><category term='ASSM'/><category term='Database Links'/><category term='Temporary Records'/><category term='DDL trigger'/><category term='Materialized View'/><category term='Privileges'/><category term='Network Latency'/><category term='Oracle Enterprise Manager'/><category term='8.48'/><category term='COBOL'/><category term='v$session_longops'/><category term='Freelist'/><category term='%CurrentDateIn'/><category term='view'/><category term='column default values'/><category term='Optimizer Dynamic Sampling'/><category term='redo logging'/><category term='nvision'/><category term='Flashback Query'/><category term='PeopleSoft Temporary Records'/><category term='Grid Control'/><category term='Unix Process Limits Memory Application Engine'/><category term='Cache'/><category term='Component Processor'/><category term='Oracle 10g'/><category term='DataGuard'/><category term='SQL*Net'/><category term='Multi-versioning'/><category term='Partitions'/><category term='trace &quot;external table&quot; directory'/><category term='Parse'/><category term='ASH'/><category term='ReUse Statement'/><category term='Plan Stability'/><category term='Global Payroll'/><category term='Statistics Retention'/><category term='PeopeTools Tables'/><category term='PeopleTools 8.50'/><category term='Descending Indexs'/><category term='Dirty Reads'/><category term='Conference'/><category term='clone database'/><category term='DBMS_STATS'/><category term='Record Locator Dialogue'/><category term='Isolation Level'/><category term='Tuxedo'/><category term='Terminated Connection Timeout'/><category term='Oracle SQL Trace Trigger'/><category term='long'/><category term='PeopleTools 8.1x'/><category term='Dynamic Code'/><category term='GetNextNumberWithGapsCommit'/><category term='Performance Metrics'/><category term='PS/Query'/><category term='Performance Monitor'/><category term='Load Balancing'/><category term='serialisation'/><category term='SQL Tuning'/><category term='Null'/><category term='sequences'/><category term='Analyze'/><category term='DDL'/><category term='Lookup Exclusion'/><category term='Locking'/><category term='Read Consistency'/><category term='SQL*Plus login prompt'/><category term='Process Scheduler'/><category term='Search Record'/><category term='%UpdateStats'/><category term='DBMS_APPLICATION_INFO'/><category term='sparse index'/><category term='Scheduled Queries'/><category term='Redo'/><category term='DDL Model'/><category term='MetaSQL'/><category term='Run Control'/><category term='XML Reporting'/><category term='Deferred Segment Creation'/><category term='Descending Key'/><title type='text'>Comments on The PeopleSoft DBA Blog: %CurrentDateIn MetaSQL prevents Oracle CBO from co...</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://blog.psftdba.com/feeds/114484062921683607/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/114484062921683607/comments/default'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2006/04/currentdatein-metasql-prevents-oracle.html'/><author><name>David Kurtz</name><uri>http://www.blogger.com/profile/00468908370233805717</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://2.bp.blogspot.com/-r3gw1fMhCYA/Ts1X4_XLfVI/AAAAAAAAAAQ/6zxhePc05OY/s220/psftdba_medium.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>1</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-25740336.post-4555674313512553716</id><published>2008-01-15T21:05:00.000Z</published><updated>2008-01-15T21:05:00.000Z</updated><title type='text'>The problem with &lt;i&gt;%CurrentDateIn&lt;/i&gt; described i...</title><content type='html'>The problem with &lt;I&gt;%CurrentDateIn&lt;/I&gt; described in this posting applies to Oracle 9&lt;I&gt;i&lt;/I&gt;, but is no longer a problem in 10&lt;I&gt;g&lt;/I&gt;.  There has been a change to the way Oracle costs predicates containing expressions (see &lt;A HREF="http://blog.psftdba.com/2007/12/changes-in-calculation-of-predicate.html" REL="nofollow"&gt;http://blog.psftdba.com/2007/12/changes-in-calculation-of-predicate.html&lt;/A&gt;).</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/114484062921683607/comments/default/4555674313512553716'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/114484062921683607/comments/default/4555674313512553716'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2006/04/currentdatein-metasql-prevents-oracle.html?showComment=1200431100000#c4555674313512553716' title=''/><author><name>David Kurtz</name><uri>http://www.blogger.com/profile/00924323960047469300</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://www.go-faster.co.uk/images/psftdba.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://blog.psftdba.com/2006/04/currentdatein-metasql-prevents-oracle.html' ref='tag:blogger.com,1999:blog-25740336.post-114484062921683607' source='http://www.blogger.com/feeds/25740336/posts/default/114484062921683607' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-332347483'/></entry></feed>
