Showing posts from June, 2010

System Monitor SUSE Linux Enterprise Server 11

System Monitor can display System Load information and Process Tables information. You can also use System Monitor to monitor and modify system behavior.
System Load shows the information on:-
·CUP Load Percentage ·Load Average Time ·Physical Memory Usage ·Swap Memory Usage

Process Tables of System Monitor can show Processes information that is loaded in the system by its Name, User Name, CUP%, Memory Usage, Shared Memory and window title. You can also kill a process using System Monitor. Processes information can be shown as:-
·All Processes ·All Processes Tree ·System Process ·User Process ·

Free / Open Source Web Traffice Analysis Tools

TraceWatch is an open source Web traffic analysis program, to support real-time analysis, can provide the depth of analysis.
SlimStat is based on PHP-MySQL, the same time, like Google Analytics can be done by JavaScript or PHP script into site.
Piwik can generate real-time access to detailed site reports, based on PHP and MySQL, like Google Analytics can be integrated as the front end.
Open Web Analytics
Based on PHP, built on WordPress, Gallery, and MediaWiki's support.
W3Perl is a Web Log analysis tools.
CrawTrack is a good open source Google Analytics for supplies, the report offers a very unique, for example, CrawTrack can help you prevent a class, such as SQL injection attacks.
BBClone is a Web counter, can provide a very detailed report on the visit. BBClone is based on PHP.
Based on the GNU / GPL open source license, can provide very detailed, information about visitors to the report, and its GUI interface is very in…

Find Used Size in a table

This script contains the query to get the size (size) used by a table in MB 

   segment_name           table_name,   
   sum(bytes)/(1024*1024) table_size_meg
FROM  user_extents
WHERE segment_type='TABLE'
AND  segment_name = '&table_name'
GROUP BY segment_name

How to Show Used/Free Tablespace Space in Oracle DB

This script will list tablespace wise free space and used space (also total size) as well as total space. For running this query you must have SELECT privileges to SYS.DBA_FREE_SPACE, SYS.V_$DATAFILE, SYS.V_$TABLESPACE views.

SELECT "Tablespace Name",
       nvl(Free_space, 0) "Free Size(MB)",
       nvl(total_space-Free_space, 0) "Used Size(MB)", 
       total_space "Total Size(MB)"
  (select tablespace_name, sum(bytes/1024/1024) free_space
     from sys.dba_free_space
    group by tablespace_name
  ) Free,
  (select,  sum(bytes/1024/1024) total_space
     from sys.v_$datafile a, sys.v_$tablespace B
    where a.ts# = b.ts#
    group by
  ) Total
WHERE Free.Tablespace_name(+) =

Show Used/Free Space Datafile wise in Oracle DB

This script will list datafile wise Allocated size, Used Size and Free Size. For running this query you must have SELECT privileges to V$DATAFILE and DBA_FREE_SPACE views.
SELECT   SUBSTR (df.NAME, 1, 40) file_name, df.bytes / 1024 / 1024 "Allocated Size(MB)",          ((df.bytes / 1024 / 1024) - NVL (SUM (dfs.bytes) / 1024 / 1024, 0)) "Used Size (MB)",          NVL (SUM (dfs.bytes) / 1024 / 1024, 0) "Free Size(MB)"     FROM v$datafile df, dba_free_space dfs    WHERE df.file# = dfs.file_id(+) GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes ORDER BY file_name;

Find the Overall DB Size in oracle Database

The biggest portion of a database's size comes from the datafiles. To find out how many megabytes are allocated to all datafiles the query is given below. My Database is new and i have few tables in it that's way the size is too small:
select sum(bytes)/1024/1024 "Megabiytes" from dba_data_files;

To get the size of all TEMP files:
select nvl(sum(bytes),0)/1024/1024 "Megabiytes" from dba_temp_files;

To get the size of the on-line redo-logs:
select sum(bytes)/1024/1024 "Megabiytes" from sys.v_$log;

Putting it all together into a single query:
select a.data_size+b.temp_size+c.redo_size "total_size" from ( select sum(bytes) data_size from dba_data_files ) a, ( select nvl(sum(bytes),0) temp_size from dba_temp_files ) b, ( select sum(bytes) redo_size from sys.v_$log ) c /

Open Source Operating System - Linux Mint

Linux Mint, an Ubuntu-based distributions, in 2006 by the French born, live and work in Ireland IT experts Clement Lefebvre for the first time to create. Structures originally envisioned for the new Linux website is dedicated to Linux users for help, tips and other information documents, Clement Lefebvre saw the development of Linux to solve a number of drawbacks associated with the mainstream product with more practical alternative to the mainstream technology and product potential. After his site visitors to seek feedback, he proceeded to develop a sound Ubuntu today called the Mint.
Although Linux Mint can be downloaded free of charge, the project's income comes from donations, advertising and professional support. It does not have a fixed timetable or plan issued list of features, but can expect a stable version of each of the following Linux Ubuntu will be released within a few weeks a new version of Linux Mint.

Debian GNU Linux

Debian GNU / Linux was first announced in 1993. Its founder is Ian Murdock, he had hundreds of ideas developed by volunteers in their spare time to create a completely non-commercial purposes release. Was far greater than the optimist's skeptics that this is doomed to failure and collapse, but in fact the opposite is true. Debian not only survived, after almost 10 years of vigorous development, it became the largest Linux distributions, it may be the largest collaborative software project to date.


Gentoo Linux

The concept of Gentoo Linux was suggested by Daniel Robbins in 2000; he was the former Stampede Linux and FreeBSD developer. In March 2002 when the released version 1.0 of the project, Gentoo's package management was considered a binary package management systems are a better choice, especially the widely used RPM.

Gentoo Linux operating system is specifically designed for advanced users. Initially, the installation of complicated, cumbersome, and even a few hours or one day use the command line to compile a complete Linux distribution, however, in 2006, developed a project to simplify the installation of Gentoo's live CD installation process as " a key to install "procedure. Gentoo's documentation has been repeatedly considered one of the best online documentation. 


Open Source Operating System - Slackware

Slackware Linux operating system created by the Patrick Volkerding in 1992, is the oldest surviving Linux distribution. From the SLS project has now been stopped, Slackware 1.0 start using the 24 floppy disks, and Linux kernel version 0.99pl11-α above. It quickly became the most popular Linux distributions, it was estimated that in 1995, even up to 80% of its market share of Linux installed. The sharp decline in popularity with Red Hat Linux and other more concerned with the issue of distribution, but Slackware Linux still remains a much-appreciated and the more business-oriented system administrators and desktop users of the system technology.

Slackware Linux is a highly technical, clean distribution, only a few very limited personal settings. It uses simple, text-based installation and compare the original package management system does not resolve software dependencies. Therefore, Slackware's is considered today the most pure and most stable release.


Open Source Operating System - PCLinuxOS

PCLinuxOS was first announced in 2003 Bill Reynolds, the well-known "Texstar". Before creating his own distribution, Texstar is already in the Mandrake Linux user community to create the most popular RPM package management, and is known for providing free downloads of a well-known developers. In 2003, he decided to build a new distribution, initially based on Mandrake Linux, but contains some important usability improvements.What is his objective? It should be for the beginner-friendly, with excellent proprietary kernel modules, browser plugins and media codecs, support, and can provide a simple and intuitive graphical installer in live CD.


Open Source Operating System - Mandriva

Mandriva Linux in July 1998, launched in Mandrake Linux. At first, this is just a re-optimized contains more friendly KDE desktop version of Red Hat Linux, but later versions added a more friendly experience, such as a new installer, improved hardware detection, and intuitive disk partitioning utility. As these improved results, Mandrake Linux flourishes. After the introduction of venture capital investment to commercial companies, the newly established MandrakeSoft company in early 2003 to 2005, the fate of large fluctuations on the verge of bankruptcy. Later after Brazil, Conectiva merger, the company changed its name to Mandriva.

Mandriva Linux mainly focus on the desktop version. The most advanced software features, first-class system management suite (DrakConf), excellent 64-bit version of the support, and extensive international support. Than many other popular distributions have an open development model, stable version is released before intensive and frequent beta test period…

Open Source Operating System - OpenSUSE Linux

OpenSUSE Linux is the first time beginning in 1992, four German Linux enthusiasts jointly launched SuSE Linux operating system under a project (Software and System Entwicklung) Initially, the young German company to sell containing the floppy disk version of Slackware Linux, but soon in May 1996 from the 4.2 version of SuSE Linux started as an independent release. In later years, developers using RPM package management and introduced YaST, an Easy to Use graphical systems management tools. OpenSUSE Linux release frequently, with excellent print a document, and SUSE Linux easily available in stores in Europe and North America. SUSE Linux is growing more and more popular. 


(OpenSUSE Linux with KDE)
(Plasma Desktop)
(OpenSUSE Linux with GNOME)

Open Source Operating System - CentOS

CentOS release in late 2003, CentOS is a re-compile to install Red Hat Enterprise Linux (RHEL) code, and to provide timely security updates to upgrade all software packages targeted at community projects. Technology between the two distributions only difference is the brand, CentOS replaces all Red Hat trademarks and logos for his own.

CentOS is often seen as a reliable server distribution. It inherits the test with a perfect and stable Linux kernel and software, and Red Hat Enterprise Linux the same basis. CentOS is also suitable for an enterprise desktop solution, especially in the stability, reliability and long-term support, is the latest software and features of the preferred.

Thus, both the desktop or used in the field of high-end enterprise Linux, open source system so that more users can create their favorite platform, not only to provide timely security updates, while providing extensive management more flexible, by Linux modules cut, remove some users do not need the module, …