offs

[Former Member]

Hi,

my DB has the following specifities :

Auto Log Off

Command Monitor Off

Resource Monitor Off

OMS Memory Analysis

Database Trace Off

Database Analyzer Off

Data Area Extension On

Automatic Statistics Update Off

Are they the parameteres ?

How can I change them ?

[Former Member]

thank you.

[Former Member]

Hi,

Yes, they are DB parameters and you can change the by dbmcli or database manager

Best regards,

Orkun Gedik

[Former Member]

realy thank you.

Be kind and please tell me how in database manager I can do it or dbmcli commande line ?

Might it be :

dbmcli u2013d <db_name> -u <dbm_user>,<password> -u -c sql_execute SET PARAMETER1=ON

??

Regards.

[Former Member]

Hi,

At the command prompt type "dbmcli help". You will see the parameter names in the list. So, you can execute the statements, with the command below;

dbmcli.exe -d <DBNAME> -u SUPERDBA,xxx -c <command> <parameter>

Best regards,

Orkun Gedik

[Former Member]

Thanks.

Sorry but :

>dbmcli.exe -d MAXDB1 -u DBADMIN,PWD -c sql_execute SET PARAMETER "Data Area Extension"=ON

ERR

-24988,ERR_SQL: SQL error

-5016,Missing delimiter: =

>dbmcli.exe -d MAXDB1 -u DBADMIN,PWD -c sql_execute SET PARAMETER "Data Area Extension=ON"

ERR

-24988,ERR_SQL: SQL error

-5016,Missing delimiter: =

>dbmcli.exe -d MAXDB1 -u DBADMIN,PWD -c sql_execute SET "Data Area Extension"=ON

ERR

-24988,ERR_SQL: SQL error

-5015,Missing keyword:ROLE,PARAMETER,WRITE,TIMEOUT,SESSION,NOLOG,NLS_SORT,LOG,LANGUAGE,ISOLATION,FORMAT,CURRENT_SCHEMA

[Former Member]

Hi,

Type "dbmcli help" at the command prompt. You will see the list of commands here

Find the example command, below;

dbmcli.exe -d <DBNAME> -u <DBUSER>,xxx -c auto_extend <mode> [<percentage>]

The easiest way to change make an operation, such as changing database state or adding an extend, is to use DBMGUI. So, you can find the way, below;

Open Database Manager GUI -> Connect to the database -> Instance -> Then, select the operation that you need, for example Data Area Extension

Additionally, you can find and change the instance parameters under Configuration -> Parameters tab

I hope that it is clear.

Best regards,

Orkun Gedik

[steffen_schildberg]

Hi BIG136,

nope.

Use

dbmcli help param

to get all possible dbmcli commands for viewing/changing parameters. To change one use

param_put

with the corresponding parameter name and options.

BTW - have you ever thought about reading the docs?

Regards,

Steffen