Last week Oracle SQL Developer 3.0 got released and its making news in all Blogs.
Below is the feature list and the cool additions to SQL developer.
Just downloaded and started working, its cool & good J
Eye Catching :::
DBA Functionality
DB Configuration | Ability to review and tune db config and edit initation parameters |
Resource Manager | Create and prioritize consumer groups and manage resource plans |
Security | Define audit settings and manage profiles, roles and users |
Storage | Define and manage archive logs, control files, datafiles, redo logs, rollback segments and tablespaces |
Schema Browser
Easier navigation between object types and schemas for a specific connection |
Support fast client-side name based filtering for narrowing the list of objects displayed |
Tuning
SQL Tuning Advisor | Analyzes submitted high-volume SQL statement and offers tuning recommendations |
Diff Tool for Explain Plans | Compare selected Explain Plan or Autotrace results for any SQL statements. |
Management Pack Licensing Preferences | Preferences option to track which Oracle database features are claimed to be licensed on a connection-by-connection basis |
Setting TNS_ADMIN for SQL developer :
We can set the tns_admin from sql developer , see the user Document :
"You can specify the tnsnames.ora location in the Database: Advanced preferences.By default, tnsnames.ora is located in the $ORACLE_HOME/network/admin directory, but it can also be in the directory specified by the TNS_ADMIN environment variable or registry value or (on Linux systems) the global configuration directory. On Windows systems, if the tnsnames.ora file exists but its connections are not being used by SQL Developer, define TNS_ADMIN as a system environment variable. For information about the tnsnames.ora file, see the "Local Naming Parameters (tnsnames.ora)" chapter in Oracle Database Net Services Reference."
Link ::
New Feature : http://www.oracle.com/
No comments:
Post a Comment