A company doing a code review asked for credentials to an Oracle database server. They logged in but soon came back asking where SQL Developer was located, stating that they couldn't find it in the "usual location". My DBA told them we never install client tools on the DB server and that they needed to install it on their own client. Which is best practice?
Is it best practice to install client tools (like Oracle SQL Developer) on the database server or another machine
best practicesoracle-12coracle-sql-developer
Related Question
- DB2 LUW: Should temporary tablespaces share bufferpools with other tablespaces
- Oracle SQL Developer – Make It Act Like PL/SQL Developer
- Oracle Database Migration using Oracle SQL Developer
- Sql-server – How to we manage cross-database dependencies across environments
- Oracle SQL Developer – Using ‘All Source Lines’ in ‘Find Database Object’
- Find SQL Developer Database examples (scripts) to add data to practice
Best Answer
Best practice would be to install and use it from client machines, since every tool running on the server is consuming some resources which will not be available to the Oracle server
Installing it on the server -- probably no penalty as pointed out in the comments