Oracle SQL Developer - Solid for Oracle Database Implementations.
September 18, 2019
Oracle SQL Developer - Solid for Oracle Database Implementations.
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle SQL Developer
Oracle SQL Developer is being used by our development team to provide introspection to the performance of our production baseline. Additionally, it's used during development to pilot capabilities, integrations and for rapid proof of concept implementation.
- Seamless database management integration
- Process stack analysis
- Modeling and visualizations
- Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.
- Detailed analysis of models can be clunky for complex relational models.
- Increases development velocity as analysis can be performed on top of operational environment.
- Allows for rapid module testing across multiple database instances.
- Provides debugging extensions which allow for thread pinning.
I've used data modeling tools and in the past with varying levels of integration with the Oracle Database. SQL Developer is the most seamless and has great native extensions for DDL and SQL profiling.