Database | Linux and Photography Blog

Archive of posts filed under the Database category.

Oracle Select the top 5 queries

27 February 2012, 11:34 am

Here are one sql script that I found some time back. This will be listing the top 5 SQL queries in Oracle. SET linesize 300 SET PAGESIZE 200 select * from (select sql_text, sql_id, elapsed_time, cpu_time, user_io_wait_time from sys.v_$sqlarea order by 5 desc) where rownum < 6; quit; Related articles SQL Fiddle (thinkvitamin.com) New Oracle [...]

Filed under Database. Tagged Database, Languages, Microsoft SQL Server, mysql, oracle, Oracle Database, programming, sql

Comment

Tora installation on Fedora 16 with rpm

9 February 2012, 11:17 am

Last article I talked about tora installation from the sources, but if that is too much for you then you can use this one liner: rpm -ivh “http://amit-agarwal.co.in/mystuff/tora-2.1.3-1.fc16.i686.rpm” But if you like the hard way out, then you can always try this. Related articles Unrar in Fedora… (gryphon143.wordpress.com) Fedora Utils just got easier (funsurf.wordpress.com) rpmorphan [...]

Filed under Database, Fedora. Tagged amit agarwal, Archive, Data Formats, Fedora, Linux, Linux distribution, Operating system, Projects, rpm, RPM Package Manager, ubuntu, Unrar, Wikipedia

2 Comments

tora on Fedora 16 for mysql and Oracle.

6 February 2012, 11:00 am

Sometime back I had posted a article on Tora on Fedora. But that was a while back and things have progressed and we already have Fedora 16 (aka Verne). So, awhile back I installed Tora on my Fedora 16 and here are the steps to do so: First get the Tora sources from sourceforge.net . [...]