Category: side note
By admin on Aug 30, 2009 in Oracle, side note | Comments Off on Oracle: Verify PGA and SGA
For current PGA size of each session, use: SELECT s.sid, n.name, s.value FROM v$sesstat s, v$statname nWHERE s.statistic# = n.statistic#AND n.name = ‘session pga memory’; For maximum PGA size each session has reached so far, use: SELECT s.sid, n.name, s.value FROM v$sesstat s, v$statname nWHERE s.statistic# = n.statistic#AND n.name = ‘session pga memory max’;
By admin on Aug 28, 2009 in Oracle, side note | Comments Off on Oracle: Detect Server Uptime
1: SELECT to_char(startup_time,’DD-MON-YYYY HH24:MI:SS’) “DB Startup Time” 2: FROM sys.v_$instance; 1: select 2: ‘Hostname : ‘ || host_name 3: ,’Instance Name : ‘ || instance_name 4: ,’Started At : ‘ || to_char(startup_time,’DD-MON-YYYY HH24:MI:SS’) stime 5: ,’Uptime : ‘ || floor(sysdate – startup_time) || ‘ days(s) ‘ || 6: trunc( 24*((sysdate-startup_time) – 7: trunc(sysdate-startup_time))) || ‘ […]
By admin on Feb 16, 2009 in side note | 2 Comments
Note from BEA website, which is no longer available Gathering Core information from: SOLARIS Do file <full path>/core to verify if the core file is from the Java VM. Get a stack trace using dbx or gdb as follows. With gdb you may get more useful information. Sun Support recommends the use of dbx(1) for […]
By admin on Feb 10, 2009 in freebies, side note | Comments Off on Create PhotoBook
Transform your digital camera photos into professionally-made photo books
By admin on Feb 3, 2009 in side note | Comments Off on HP-UX Socket Connection Limit
System wide limited by “tcp_conn_request_max” # ndd -get tcp_conn_request_max…to show the value# ndd -h tcp_conn_request_max…to show the ranges allowed# ndd -set tcp_conn_request_max >value>…to set the value Limit by maxfiles per process. ulimit -n is a soft limit set by the kernel parameter maxfiles. You may change this with the standard HP-UX POSIX shell with ulimit: […]
By admin on Nov 22, 2008 in Programming, side note | Comments Off on Programming Tips from Pragmatic Programmer
This is a summary from the Pragmatic Programmer book. Care About Your CraftWhy spend your life developing software unless you care about doing it well? Think! About Your WorkTurn off the autopilot and take control. Constantly critique and appraise your work. Provide Options, Don’t Make Lame ExcusesInstead of excuses, provide options. Don’t say it can’t […]
By admin on Nov 16, 2008 in open source, side note | Comments Off on Open Source IT Monitoring
GroundWork Monitor is an open source IT monitoring solution for companies with heterogeneous operating systems, application and hardware environments who want to reduce ongoing monitoring costs, consolidate views and reports and improve staff productivity.
By admin on Oct 12, 2008 in side note | Comments Off on SQL Visualization Tool
QueryScope is a visualization tool that transforms multi-page SQL statements into colorful bubble diagrams that show the most important characteristics of the queries so that they can be understood and tuned.
By admin on Sep 23, 2008 in side note | Comments Off on Open Source Workflow Engine from Apache
2 open source workflow engines from Apache which are either in incubation or sandbox Apache Workflow – XML scripted workflow engine Apache Agila – lightweight BPM engine and auxiliary services.
By admin on Aug 25, 2008 in side note | Comments Off on Google AJAX Search API
The Google AJAX Search API lets you put Google Search in your web pages with JavaScript. You can embed a simple, dynamic search box and display search results in your own web pages or use the results in innovative, programmatic ways. Using it, you can Integrate Web Search, News Search, and Blog Search into your […]
By admin on Aug 25, 2008 in .NET, side note | Comments Off on ASP.NET Project at CodePlex
The project hosted at http://www.codeplex.com/aspnet gives you access to the code for upcoming releases that the Microsoft ASP.NET team is working on. The project gives you a look at the design and lets you have a voice in it.
By admin on Aug 24, 2008 in side note | Comments Off on Google Talk Gadget
The Google Talk Gadget is a browser-based instant messaging client for the Google Talk network. It’s compatible with all platforms, and is supported by the following browsers: IE 5.5+ (Windows) Firefox 0.8+ (Windows, Mac, Linux) Safari 1.2.4+ (Mac) Netscape 7.1+ (Windows, Mac, Linux) Mozilla 1.4+ (Windows, Mac, Linux) Opera 8+ (Windows, Mac, Linux) The gadget […]
By admin on Aug 20, 2008 in side note | Comments Off on DjVu versus Pdf
As quoted from Wikipedia, DjVu is a computer file format designed primarily to store scanned images, especially those containing text and line drawings. It uses technologies such as image layer separation of text and background/images, progressive loading, arithmetic coding, and lossy compression for bitonal (monochrome) images. This allows for high quality, readable images to be […]
By admin on Aug 18, 2008 in side note | Comments Off on Sharing Search Results with OpenSearch
OpenSearch is a collection of simple formats for the sharing of search results. The OpenSearch description document format can be used to describe a search engine so that it can be used by search client applications. The OpenSearch response elements can be used to extend existing syndication formats, such as RSS and Atom, with the […]
By admin on Aug 18, 2008 in open source, php, side note | Comments Off on Ajax based Web Database Explorer
TurboDbAdmin is a single-page solution for exploring and editing databases from a browser. Edit data just like you would in a desktop application, without submit buttons or page refreshes.
By admin on Aug 15, 2008 in freebies, side note | Comments Off on Free PDF Tools
doPDF is a free PDF converter for both personal and commercial use. Using doPDF you can create PDF files by selecting the “Print” command from virtually any application. With one click you can convert your Microsoft Excel, Word or PowerPoint documents or your emails and favorite web sites to PDF files. CutePDF Writer (formerly CutePDF […]
By admin on Aug 11, 2008 in side note | Comments Off on CVS: Remove a Tag or Branch
You may not want to do this but this is the command cvs rtag -d -B <tag/branch name> <module name> -a Clear tag from removed files that would not otherwise be tagged. -b Make the tag a “branch” tag, allowing concurrent development. -B Allows -F and -d to disturb branch tags. Use with extreme […]
By admin on Aug 10, 2008 in Oracle, side note | Comments Off on Oracle SQLPlus Note
@ and @@ The @ (at symbol) is equivalent to the START command and is used to run SQL*Plus command scripts. A single @ symbol runs a script in the current directory (or one specified with a full or relative path, or one that is found in you SQLPATH or ORACLE_PATH). @@ will start a […]
By admin on Aug 9, 2008 in Java, Programming, side note | Comments Off on Make Use of Eclipse Code Template
By defining your own Eclipse code template, you can greatly simplify your daily programming work E.g. go to Windows->Preferences->Java->Editor->Templates, and add a template called “log” with the following pattern private static final Log log = LogFactory.getLog( ${enclosing_type}.class ); Then in our editor, just type “log” and then press “Ctrl-Space”, then statement will be generated automatically. […]
By admin on Aug 7, 2008 in Java, open source, side note | Comments Off on Eclipse Ganymede Packages
You can download Eclipse Ganymede packages at http://www.eclipse.org/ganymede/ Eclipse Ganymede is the annual release of Eclipse projects; Year 2008 including 23 projects. Some highlights of the release include the new p2 provisioning platform, new Equinox security features, new Ecore modeling tools, support for SOA and much more.