Adjusting Oracle Parameters in pure Java DB

[Former Member]

Hi people,

I´ve installed a java instance with oracle DB. In the post-installation steps, there are the oracle adjusting parameters. For to execute the script for view the several parameters in this database it´s only possible via sqlplus?

More thanks

[Former Member · Accepted solution]

Yes I think only via sqlplus.

Thanks

[Former Member · Accepted solution]

But I´ve executed the script in the sqlplus with the properties indicated in the note

SQLPLUS

To ensure an acceptable output with SQLPLUS, execute the following SQLPLUS commands in advance

set linesize 360

set pagesize 1000

COLUMN name FORMAT a40

COLUMN set FORMAT a8

COLUMN remark FORMAT a60

COLUMN recommendation FORMAT a120

COLUMN is_value FORMAT a50

COLUMN should_be_value FORMAT a50

But the output is cutted and I cannot see the previous parameters. I added more pagesize but doesn´t work

[Former Member · Accepted solution]

Hi,

Try saving the script with .sql extension on the filesystem and then set the linesize and page size as mentioned in the note.

Now, turn the spool off and execute the .sql script from SQLPLUS.

Open the output fiile in an excel format and you should get the recommended parameter values.

Hops this helps.

Regards,

Varun