Where did all these files come from?

thatjeffsmith SQL Developer 2 Comments

A friend, let’s call her ‘Helen’ for the sake of this post, texted me the other day, wondering why she had all these dozens/hundreds (?) of files in her Windows home directory. She was confused. Where did they come from? Were they safe to delete? I asked her what they were called, and the filename sounded VERY MUCH like what …

SQL Developer 4.2 Oracle Execution Plans – More Columns Available

thatjeffsmith SQL Developer 19 Comments

Someone on the Forums (yes, we read and respond!) noticed they couldn’t add Bytes or Time to their plan displays in Oracle SQL Developer. So we just made all of the columns available now, even if a few them might not make sense, i.e. TEMP_SPACE, OTHER. Preferences – Database – Autotrace/Explain Plan New things highlighted/boxed… So let’s look at a …

Password Resets No Longer Require a Thick Connection (Oracle Client) in SQL Developer

thatjeffsmith SQL Developer 9 Comments

Thanks to an update in a 12c JDBC driver for Oracle Database, we can now update a password natively, without being connected to the database. Previous to version 4.2 EA2 – users would either have to be connected already OR have an Oracle Client available. A post I did up explaining this is one of the most read articles on …

Top 10 Posts of 2016

thatjeffsmith SQL Developer 0 Comments

Happy 2017! Here are your 10 favorite posts from last year. 1. Exporting Multiple Tables to Multiple Excel Spreadsheets Want 6 tables’ worth of data to go to single Excel file? Or one table per file? Here’s how to do that. 2. Oracle SQL Tuning Advisor and SQL Developer Own the Tuning Pack? Have SQL Developer? You should be using …