<?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.post2182764211144298689..comments</id><updated>2008-09-28T19:48:14.820+01:00</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: Sequence Number Allocation in PeopleSoft</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://blog.psftdba.com/feeds/2182764211144298689/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/2182764211144298689/comments/default'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2008/07/sequence-number-allocation-in.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>2</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-25740336.post-5819267608760384630</id><published>2008-09-28T19:48:00.000+01:00</published><updated>2008-09-28T19:48:00.000+01:00</updated><title type='text'>You could try disabling the second session by sett...</title><content type='html'>You could try disabling the second session by setting DBFlags.&lt;BR/&gt;&lt;BR/&gt;;-------------------------------------------------------------------------&lt;BR/&gt;; DbFlags Bitfield&lt;BR/&gt;;&lt;BR/&gt;; Bit       Flag&lt;BR/&gt;; ---       ----&lt;BR/&gt;; 4         - Disable Second DB Connection&lt;BR/&gt;; 8         - Disable Persistent Secondary DB Connection&lt;BR/&gt;DbFlags=4</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/2182764211144298689/comments/default/5819267608760384630'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/2182764211144298689/comments/default/5819267608760384630'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2008/07/sequence-number-allocation-in.html?showComment=1222627680000#c5819267608760384630' 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/2008/07/sequence-number-allocation-in.html' ref='tag:blogger.com,1999:blog-25740336.post-2182764211144298689' source='http://www.blogger.com/feeds/25740336/posts/default/2182764211144298689' 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-8209751551244372206</id><published>2008-09-21T23:10:00.000+01:00</published><updated>2008-09-21T23:10:00.000+01:00</updated><title type='text'>Nice article..&lt;br&gt;I am facing the same scenario..d...</title><content type='html'>Nice article..&lt;BR/&gt;I am facing the same scenario..during my conversion using Component interface and peoplecode, the process does not progress and kind of stucks..Our DBA figured out that there are two sessions that are locking the same table...and we are on Informix-UNIX..i.e. the secondary connection will be established even if I use PSAE...I am confused how to resolve this issue...</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/2182764211144298689/comments/default/8209751551244372206'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/25740336/2182764211144298689/comments/default/8209751551244372206'/><link rel='alternate' type='text/html' href='http://blog.psftdba.com/2008/07/sequence-number-allocation-in.html?showComment=1222035000000#c8209751551244372206' title=''/><author><name>Aniruddha</name><uri>http://www.blogger.com/profile/07900784424424936522</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><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://blog.psftdba.com/2008/07/sequence-number-allocation-in.html' ref='tag:blogger.com,1999:blog-25740336.post-2182764211144298689' source='http://www.blogger.com/feeds/25740336/posts/default/2182764211144298689' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-306211233'/></entry></feed>
