You can drag the file to the worksheet, or you can send it directly from the Mr Trace extension. SQL Developer Quick Tip: Viewing Trace Files in the Worksheet Once you’re ready to analyze the trace files, you can open it natively in SQL Developer, or you can spend some money and buy another 3rd party tool, some of which are available on the Extensions Exchange. This plugin requires a few server side objects (that your DBA can create for you), and then makes it a seamless process to access the files afterwards. ‘Before, getting trace files was hard.’ Yeah, if you’re not the UNIX admin or DBA, getting the trace files off the database server is a pain.
Trace is another extension that automatically starts a trace and retrieves the file(s) down to SQL Developer so you can analyze the performance of your queries. They have another couple of screens that I enjoy using to click through active sessions and wait events. They have an advanced version with much more functionality if you have a few spare dollars to spend.
PL SQL DEVELOPER PLUGIN FREE
The above image is SQL Developer running a free 3rd party extension from Fourth Elephant. Think You Know What SQL Developer Looks Like? Oracle Database Monitoring with 4th Elephant Extension
PL SQL DEVELOPER PLUGIN ANDROID
Jealous of those Android and iOS developers making mad money? Build an extension and share it with your fellow Oracle comrades! These 3rd party extensions range from $0 in price to just a bit more than free.
Don’t have TIME to build your own software? No problem, other smart people are making their extensions available to you. Don’t know Java? No problem, you can get started with just SQL and XML. While SQL Developer is NOT an open-source project, it does provide a framework that allows for other developers to build their own plug-ins. We do our best to give you everything you need to be successful in your job, but also recognize that we can’t do EVERYTHING. Oracle SQL Developer is made available to you for free, and is chock-full of features for the developer, DBA, or data-junkie.
0 kommentar(er)
