mauropagano / sqld360 Goto Github PK
View Code? Open in Web Editor NEWSQLd360 repository
License: Other
SQLd360 repository
License: Other
SQLd360 v1801 (2018-01-13) by Mauro Pagano SQLd360 is a "free to use" tool to perform an in-depth investigation of a SQL statement. It collects detailed information around the SQL. It also helps to document any findings. SQLd360 installs nothing. 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 SQLd360 from a system directory with at least 1 GB of free space. Steps ~~~~~ 1. Unzip SQLd360.zip, navigate to the root sqld360 directory, and connect as SYS, DBA, or any User with Data Dictionary access: $ unzip sqld360.zip $ cd sqld360 $ sqlplus dba_user/dba_pwd 2. Execute sqld360.sql indicating two input parameters. The first one is to specify the SQL ID for the SQL you want to analyze. The second one is to specify if your database is licensed for the Oracle Tuning Pack, the Diagnostics Pack or None [ T | D | N ]. Example below specifies SQL ID 0vy6pt4krb3gm, Tuning Pack. Actual days of history used depends on retention period, SQLd360 uses 31 days by default. Edit sql/sqld360_00_config.sql in case a shorter/longer period is desired. SQL> @sqld360.sql 0vy6pt4krb3gm T 3. Unzip output sqld360_<dbname>_<sqlid>_<host>_YYYYMMDD_HH24MI.zip into a directory on your PC 4. Review main html file 0001_sqld360_<dbname>_index.html **************************************************************************************** SQLD360 - Enkitec's Oracle SQL 360-degree View 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/>.
Ciao Mauro,
I'm running sqld360 on a win2012r2 machine with a 12cR1 db, it fails to get bind variables:
14:12:36 col:2of5 "00086_sqld360_147264_0juzvshqdu9b7_2g_50_binds_list_from_memory.html" Error 45 initializing SQL*Plus Internal error
perhaps there are too many binds.
regards,
Fabrizio
Hi,
Since sqld360 only supports executing from the path where sqld360.sql is, sometimes the process need to be aborted, or missing the "zip" command in OS level, thus would leave some temp files.
What I expect is sqld360 to support lauching from other path, and then I can manually copy the "js" folder into that path to make sure the result pages are all fine.
Thank you
From the main index page, choose option 5H SQL Tuning Advisor txt.
The follow error messages repeat:
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('SYS_AUTO_SQL_TUNING_TASK','EXEC_36880')
ERROR:
ORA-13618: The specified value is not a valid value for procedure argument
TYPE.
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 8740
ORA-06512: at "SYS.DBMS_SQLTUNE", line 1052
ORA-06512: at line 1
The SELECT statement is properly generated but I've verified the error by running the SELECT via SYS user on the database in question.
Ciao Mauro,
It's not really an issue, anyway.. I'm trying sqld360 on a windows installation, obviously it cannot find env, cat, etc.
`
1a. Database Configuration
'cat' is not recognized as an internal or external command,
operable program or batch file.
'lsconf' is not recognized as an internal or external command,
operable program or batch file.
'psrinfo' is not recognized as an internal or external command,
operable program or batch file.
SP2-0223: No lines in SQL buffer.
'rm' is not recognized as an internal or external command,
operable program or batch file.
`
regards,
Fabrizio
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.