TOAD Compare Oracle Parameters

With TOAD (with DB admin module), I want to compare Oracle Parameters between 2 databases. I think we can use the Compare / Database menu.

In Object Type we need Oracle Parameters, so when checked, TOAD will compare parameters between 2 databases.

The result will be like :

ALTER SYSTEM SET SGA_TARGET = 0 SCOPE=BOTH;

ALTER SYSTEM SET CURSOR_SHARING = FORCE SCOPE=SPFILE;

Etc…

Perhaps, is there this functionality elsewhere in TOAD ?

Hi thierry.mara,

You can use Database browser to compare Oracle parameters.

- open DB browser

- make connections

- select DBs in the left-hand-side list

- go to Parameters tab

Thanks. It’s fine.