DZone
Performance Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Performance Zone > The Best of the Week (May 23): SQL Zone

The Best of the Week (May 23): SQL Zone

Alec Noller user avatar by
Alec Noller
·
Jun. 01, 14 · Performance Zone · Interview
Like (0)
Save
Tweet
4.54K Views

Join the DZone community and get the full member experience.

Join For Free

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (May 23 to May 29). Here they are, in order of popularity:

1. PostgreSQL 9.4 Beta 1 Released

Beta 1 of PostgreSQL 9.4 has been released. If you're interested in previewing the new features (and there are quite a few) of PostgreSQL 9.4, take a look.

2. Better Exceptions

I had the idea when I stumbled upon JUnit GitHub issue #706, which is about a new method proposal

3. Spring/Hibernate Improved SQL Logging with log4jdbc

Hibernate provides SQL logging out of the box, but such logging only shows prepared statements, and not the actual SQL queries sent to the database. This blog post will go over how to setup Hibernate query logging, and then compare it to the logging that can be obtained with log4jdbc .

4. Performance Tuning of Spring/Hibernate Applications

For most Spring/Hibernate enterprise applications, the performance depends almost entirely on that of its persistence layer. This post will go over how to confirm we are in the presence of a 'database-bound' application, and then walk through 7 frequently used 'quick-win' tips to help improve performance.

5. Oracle Tip: v$sql Table or View Does Not Exist

If we want to analyze execution plans on the SQL console, we probably need to find a SQL_ID first, which we can then pass to the DBMS_XPLAN.DISPLAY_CURSOR function. One way to find this SQL_ID is by querying the v$sql table first.

sql

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Product Owner Anti-Patterns
  • Stupid Things Orgs Do That Kill Productivity w/ Netflix, FloSports & Refactoring.club
  • JUnit 5 Tutorial: Nice and Easy [Video]
  • How To Integrate Event Streaming Into Your Applications

Comments

Performance Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo