TUNAs360 v1606 (2016-04-24) by Mauro Pagano
TUNAs360 is a "free to use" tool to perform an initial assessment of an Oracle database.
It collects several information about the database workload. It also helps to document any findings.
TUNAs360 installs nothing and doesn't rely on any Oracle licensed option (i.e. Diagnostic Pack).
For better results execute connected as SYS or DBA.
It takes a few minutes to execute. Output ZIP file can be large (several MBs), so
you may want to execute TUNAs360 from a system directory with at least 1 GB of free
space.
Steps
~~~~~
1. Unzip tunas360-master.zip, navigate to the root tunas360 directory, and connect as SYS,
DBA, or any User with Data Dictionary access:
$ unzip tunas360-master.zip
$ cd tunas360-master
$ sqlplus dba_user/dba_pwd
2. Execute tunas360.sql passing no parameters. TUNAs360 will observe the workload for a few minutes
and it will then report on such workload
SQL> @tunas360.sql
3. Unzip output tunas360_<dbname>_<host>_YYYYMMDD_HH24MI.zip into a directory on your PC
4. Review main html file 0001_tunas360_<dbname>_index.html
****************************************************************************************
TUNAs360 - (TUN)ing with (A)ctive (s)essions
Copyright (C) 2015 Mauro Pagano
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.