<?xml version='1.0' encoding='UTF-8'?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-2121785753211096307</atom:id><lastBuildDate>Mon, 09 Sep 2024 05:52:51 +0000</lastBuildDate><category>tech</category><category>AIX</category><category>analyze</category><category>index</category><category>microsoft</category><category>optimize</category><category>session timeout</category><category>sql</category><title>Technology How Tos</title><description></description><link>http://mytechjottingz.blogspot.com/</link><managingEditor>noreply@blogger.com (C.G.)</managingEditor><generator>Blogger</generator><openSearch:totalResults>5</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><item><guid isPermaLink="false">tag:blogger.com,1999:blog-2121785753211096307.post-5616795408051792347</guid><pubDate>Thu, 17 Feb 2011 05:08:00 +0000</pubDate><atom:updated>2011-02-16T21:10:34.723-08:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">microsoft</category><title>Appdata</title><description>Just found out that App Data in Windows 7 can be accessed by typing %appdata% in the Run dialog box.</description><link>http://mytechjottingz.blogspot.com/2011/02/appdata.html</link><author>noreply@blogger.com (C.G.)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-2121785753211096307.post-7021172042875661063</guid><pubDate>Tue, 04 Nov 2008 16:03:00 +0000</pubDate><atom:updated>2008-11-04T08:05:58.694-08:00</atom:updated><title>How to use commit in a Trigger</title><description>&lt;p&gt;Say you have a procedure which inserts/updates records. &lt;/p&gt;  &lt;p&gt;And you want to do this after a row is updated in a table in oracle. &lt;/p&gt;  &lt;p&gt;Now you create a trigger and call this procedure. But it fails because Oracle throws an error saying &quot;Commit - not allowed in a trigger&quot;. &lt;/p&gt;  &lt;p&gt;The solution for this is to use the following :&lt;br /&gt;&lt;/p&gt;  &lt;p&gt; &lt;/p&gt;  &lt;p&gt;create or replace myprocedure is &lt;/p&gt;  &lt;p&gt;pragma AUTONOMOUS_TRANSACTION;&lt;/p&gt;  &lt;p&gt;begin&lt;/p&gt;  &lt;p&gt; ...&lt;/p&gt;  &lt;p&gt;do stuff&lt;/p&gt;  &lt;p&gt; ...&lt;/p&gt;  &lt;p&gt;end;&lt;/p&gt;  &lt;p&gt; &lt;/p&gt;  &lt;p&gt;And that should take care of it.&lt;/p&gt;  &lt;p&gt; &lt;/p&gt;  &lt;div class=&quot;wlWriterSmartContent&quot; id=&quot;scid:0767317B-992E-4b12-91E0-4F059A8CECA8:ea4818c7-c3f5-4545-be26-d3d335a65c19&quot; style=&quot;margin: 0px; padding: 0px; display: inline;&quot;&gt;Technorati Tags: &lt;a href=&quot;http://technorati.com/tags/Oracle&quot; rel=&quot;tag&quot;&gt;Oracle&lt;/a&gt;, &lt;a href=&quot;http://technorati.com/tags/PLS/SQL&quot; rel=&quot;tag&quot;&gt;PLS/SQL&lt;/a&gt;, &lt;a href=&quot;http://technorati.com/tags/Trigger&quot; rel=&quot;tag&quot;&gt;Trigger&lt;/a&gt;, &lt;a href=&quot;http://technorati.com/tags/Procedure&quot; rel=&quot;tag&quot;&gt;Procedure&lt;/a&gt;&lt;/div&gt;</description><link>http://mytechjottingz.blogspot.com/2008/11/how-to-use-commit-in-trigger.html</link><author>noreply@blogger.com (C.G.)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-2121785753211096307.post-6160187290167146538</guid><pubDate>Thu, 15 May 2008 18:56:00 +0000</pubDate><atom:updated>2008-05-15T12:06:38.521-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">AIX</category><category domain="http://www.blogger.com/atom/ns#">session timeout</category><title>How to set the timeout variable in AIX</title><description>Our working environment has changed from Linux to AIX.&lt;br /&gt;One  of the things we noticed was that the session timeout was at a very low threshold. You leave your desk for 5 mins and your session is gone. Talked to the SA and the line is that its a compliance thing.&lt;br /&gt;&lt;br /&gt;So what is the work around ?&lt;br /&gt;&lt;br /&gt;set up the TMOUT environment variable. A value of 0 is unlimited.&lt;br /&gt;&lt;br /&gt;System-wide, it could be added to /etc/profile; otherwise add it tousers $HOME/.profile&lt;br /&gt;&lt;br /&gt;export TMOUT=3600&lt;br /&gt;would terminate session if inactive for 1 hour</description><link>http://mytechjottingz.blogspot.com/2008/05/how-to-set-timeout-variable-in-aix.html</link><author>noreply@blogger.com (C.G.)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-2121785753211096307.post-3715676848043023293</guid><pubDate>Tue, 02 Oct 2007 16:06:00 +0000</pubDate><atom:updated>2007-10-02T09:26:36.033-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">analyze</category><category domain="http://www.blogger.com/atom/ns#">index</category><category domain="http://www.blogger.com/atom/ns#">optimize</category><category domain="http://www.blogger.com/atom/ns#">sql</category><category domain="http://www.blogger.com/atom/ns#">tech</category><title>How to Optimize Sql in Oracle</title><description>&lt;p&gt;So the scenario is you have your business users crying foul over how slow the system is. It could be anything a web application batch process, some stored procedures running forever, hell even some JDBC calls. &lt;/p&gt;&lt;p&gt;You go to the DBA and he throws some blah at you about how overworked he is and then will try to fit you in but you never know when he&#39;s gonna get to it. &lt;/p&gt;&lt;p&gt;&lt;br /&gt;So how do you know what to look for and do it yourself or get someone to get it done.We&#39;ll use oracle as an example. Some simple items to look out for :&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&gt;Check the tables in question:&lt;br /&gt;&lt;/p&gt;&lt;blockquote&gt;&lt;p&gt;&lt;em&gt;select table_name, last_analyzed&lt;/em&gt;&lt;/p&gt;&lt;p&gt;&lt;em&gt;from user_tables&lt;/em&gt;&lt;/p&gt;&lt;p&gt;&lt;em&gt;where table_name like &#39;%your tablename%&#39;&lt;/em&gt;&lt;/p&gt;&lt;/blockquote&gt;&lt;p&gt;&lt;br /&gt;More often then not the dates will be old which suggests you got to get these tables analyzed. &lt;/p&gt;&lt;p&gt;&lt;br /&gt;&gt; Simply Run analyze on the tables. This may take a while to run depending upon the size of the data in the table&lt;/p&gt;&lt;blockquote&gt;&lt;em&gt;Analyze Table your_tablename compute statistics&lt;/em&gt; &lt;/blockquote&gt;&lt;p&gt;&lt;br /&gt;Look at the indexes on each of the tables.&lt;/p&gt;&lt;p&gt;Often you will find they do not have indexes or they do but not on the columns that queries use.&lt;/p&gt;&lt;p&gt;So there you go create indexes on the most queried columns in the sql&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;em&gt;&lt;/p&gt;&lt;blockquote&gt;&lt;em&gt;Create index ID1 on your_table_name(Column_name)&lt;/em&gt;&lt;/blockquote&gt;&lt;p&gt;&lt;/em&gt;.&lt;br /&gt;Bham ! This should increase the efficiency 75% off the time. Now you have everything working at a threshold that is tolerable.For further fine tuning break down the code and optimize each query to get the output you desire. &lt;/p&gt;&lt;p&gt;&lt;br /&gt;By this time the DBA should be able to poke around and find the bottlenecks if any, in the system.&lt;/p&gt;</description><link>http://mytechjottingz.blogspot.com/2007/10/how-to-optimize-sql-in-oracle.html</link><author>noreply@blogger.com (C.G.)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-2121785753211096307.post-3183233743807177830</guid><pubDate>Tue, 02 Oct 2007 15:32:00 +0000</pubDate><atom:updated>2007-10-02T08:43:22.617-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">tech</category><title>All things Technical and then some</title><description>Being a techie I thought I would start writing about things that I work with and interest me and ofcourse technology seems to play a big role.&lt;br /&gt;&lt;br /&gt;Starting today I thought I would like to write simple How Tos on Techie Stuff.&lt;br /&gt;&lt;br /&gt;It&#39;s not going to be a tutorial, there are several Experts &amp;amp; Gurus out there for that. It&#39;s gonna be simple tricks for newbies who want to get something done when they are caught in a techy bind as they say.&lt;br /&gt;&lt;br /&gt;So welcome aboard and watch out for some geeky stuff :)</description><link>http://mytechjottingz.blogspot.com/2007/10/all-things-technical-and-then-some.html</link><author>noreply@blogger.com (C.G.)</author><thr:total>0</thr:total></item></channel></rss>