mauropagano/sqld360

SQLd360 repository

sqld360's Issues

Can it support launching from other work path?

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

Getting ORA-13618 error under STA link on main index page

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.

Running on windows

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

'rm' is not recognized as an internal or external command, operable program or batch file.

'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

Too many binds

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