tag:blogger.com,1999:blog-5215551487816981140.post7676659684640468576..comments2024-03-28T22:27:48.595-07:00Comments on ORA-00001: Unique constraint violated: Adventures with Apex, part one: Boosting performance when using DBMS_EPGMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5215551487816981140.post-57752806072623255492010-08-17T05:36:09.961-07:002010-08-17T05:36:09.961-07:00"alter system register" will make those ..."alter system register" will make those xdbconfig.xml settings active, without the need to restart.Marco Gralikehttps://www.blogger.com/profile/12810709424310804316noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-21348102724141183182009-08-24T03:17:25.308-07:002009-08-24T03:17:25.308-07:00I got the same performance issue ( see http://foru...I got the same performance issue ( see http://forums.oracle.com/forums/thread.jspa?threadID=947071&tstart=30 )<br />and I try your solution but now I am not on my business lan.<br />It's seems to work on my laptop so my problem seems to be on the use of database link between the server where is ApEx and the production server.<br />Can you help me to localize my problem ?<br />Thanks<br />JM Plancade<br />plancade@mls.ncAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-83176154665297918222008-06-27T03:36:00.000-07:002008-06-27T03:36:00.000-07:00Shouldn't that statement include SCOPE=BOTH, as in...Shouldn't that statement include SCOPE=BOTH, as in:<BR/><BR/>ALTER SYSTEM SET SHARED_SERVERS=5 SCOPE=BOTH<BR/><BR/>This way, the setting will persist.<BR/><BR/>JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.com