<?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.post5642770847335457101..comments</id><updated>2011-02-17T08:15:14.618Z</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: Performance Benefits of ReUse Statement Flag in Ap...</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://blog.psftdba.com/feeds/5642770847335457101/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2009/02/performance-benefits-of-reuse-statement_27.html'/><author><name>David Kurtz</name><uri>http://www.blogger.com/profile/08139761793598085235</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='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-25740336.post-1982327683727647652</id><published>2011-02-17T08:15:14.618Z</published><updated>2011-02-17T08:15:14.618Z</updated><title type='text'>These are batch timings.  They are enabled by sett...</title><content type='html'>These are batch timings.  They are enabled by setting the &lt;i&gt;TraceAE&lt;/i&gt; flag 128 to write them to file, and 1024 to the database.</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default/1982327683727647652'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default/1982327683727647652'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2009/02/performance-benefits-of-reuse-statement_27.html?showComment=1297930514618#c1982327683727647652' 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/2009/02/performance-benefits-of-reuse-statement_27.html' ref='tag:blogger.com,1999:blog-25740336.post-5642770847335457101' source='http://www.blogger.com/feeds/25740336/posts/default/5642770847335457101' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-332347483'/></entry><entry><id>tag:blogger.com,1999:blog-25740336.post-3610129923301379175</id><published>2011-02-07T20:26:08.791Z</published><updated>2011-02-07T20:26:08.791Z</updated><title type='text'>Whats the trace value you would set to derive such...</title><content type='html'>Whats the trace value you would set to derive such timings</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default/3610129923301379175'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default/3610129923301379175'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2009/02/performance-benefits-of-reuse-statement_27.html?showComment=1297110368791#c3610129923301379175' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://blog.psftdba.com/2009/02/performance-benefits-of-reuse-statement_27.html' ref='tag:blogger.com,1999:blog-25740336.post-5642770847335457101' source='http://www.blogger.com/feeds/25740336/posts/default/5642770847335457101' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-246263238'/></entry><entry><id>tag:blogger.com,1999:blog-25740336.post-6270973806497336790</id><published>2009-03-03T04:36:00.000Z</published><updated>2009-03-03T04:36:00.000Z</updated><title type='text'>Hi David,&lt;br&gt;&lt;br&gt;I was trying to fine tune my AE, ...</title><content type='html'>Hi David,&lt;BR/&gt;&lt;BR/&gt;I was trying to fine tune my AE, using the tips you have talked about, and I've seen phenomenal improvement in the processing times for my AE. I was initially writing to a file about a million rows in 30 mins, some tweaking and ReUseCursor for CreateSQL got the time down to 3 minutes. I'm now able to successfully write about 11 million rows in a single file in just under 30 mins.&lt;BR/&gt;&lt;BR/&gt;&lt;BR/&gt;Thanks to you.&lt;BR/&gt;&lt;BR/&gt;Cheers!!&lt;BR/&gt;Prashant</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default/6270973806497336790'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default/6270973806497336790'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2009/02/performance-benefits-of-reuse-statement_27.html?showComment=1236054960000#c6270973806497336790' title=''/><author><name>Ciphersbak</name><uri>http://www.blogger.com/profile/01586158446874473262</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='32' height='19' src='http://bp3.blogger.com/_us1mHob_dps/SB9X-oWAiLI/AAAAAAAAAsc/03Zt108NYoA/S220/2068438.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://blog.psftdba.com/2009/02/performance-benefits-of-reuse-statement_27.html' ref='tag:blogger.com,1999:blog-25740336.post-5642770847335457101' source='http://www.blogger.com/feeds/25740336/posts/default/5642770847335457101' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1627236035'/></entry><entry><id>tag:blogger.com,1999:blog-25740336.post-7304278946490177609</id><published>2009-02-28T13:26:00.000Z</published><updated>2009-02-28T13:26:00.000Z</updated><title type='text'>Hi David,&lt;br&gt;&lt;br&gt;This is a great example to show t...</title><content type='html'>Hi David,&lt;BR/&gt;&lt;BR/&gt;This is a great example to show the ReUse feature of App Engines. Really appreciate your article on it ... &lt;BR/&gt;&lt;BR/&gt;Thank You very much&lt;BR/&gt;&lt;BR/&gt;Cheers&lt;BR/&gt;Thanks!&lt;BR/&gt;Prashant</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default/7304278946490177609'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/5642770847335457101/comments/default/7304278946490177609'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2009/02/performance-benefits-of-reuse-statement_27.html?showComment=1235827560000#c7304278946490177609' title=''/><author><name>Ciphersbak</name><uri>http://www.blogger.com/profile/01586158446874473262</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='32' height='19' src='http://bp3.blogger.com/_us1mHob_dps/SB9X-oWAiLI/AAAAAAAAAsc/03Zt108NYoA/S220/2068438.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://blog.psftdba.com/2009/02/performance-benefits-of-reuse-statement_27.html' ref='tag:blogger.com,1999:blog-25740336.post-5642770847335457101' source='http://www.blogger.com/feeds/25740336/posts/default/5642770847335457101' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1627236035'/></entry></feed>
