Database Generic Information
Missing Icons - ie "Load Editor" icon missing - change location of workspace, eclipse uses the icon layout saved in the workspace
When changing workspace, you can add your old SQL Project to the new workspace by
NOTE: Auto Commit is on by default, ie DML commits after every statement unless turned off
Turn off with
"Window->Preferences->SQL Development->SQL Execution-> uncheck your platform(s)
Data Source Explorer
SYSTEM objects are filtered out by default.
Refreshing the cache
The datasource explorer caches definitions for table, view, user etc. The definitions are used to proof read SQL and mark missing objects. If a new object has been created, outside of DB Optimizer, since it's been running, then it will be missing from the cache and flagged as non-existent in the SQL Editor. This can be fixed by refreshing the cache:
Window -> Preferences -> SQL Development - > Data source Indexing -> Start Indexing
You can manually refresh a node in the data source explorer (for example to refresh tables only)
Right click on the table node in data source explorer , choose "refresh"
You can clear Data Cache to improve performance after running a long time and there is alot of cache from multiple datasources.
Can only profile one data source at at time, though tuning can be run concurrently. (though you can start up a second DB Optimizer using a different workspace and profile a second data source)
dboptimizer.exe profile ds:<data source> duration:< minutes> tofile:<file.oar> <overwrite>
dboptimizer.exe tune ds:<data source> sqlfile:<path to sql file> tofile:<tuning job save file.tun> <overwrite>
licenses are kept in C:\Documents and Settings\All Users\Application Data\Embarcadero
DBO Optimizer Versions