Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

October 2013

Popularity vs Productivity vs Performance

Submitted by khailey on Tue, 2013-10-01 23:50

 

 

 

 

 

skyscraper

Enkitec is an Anagram for Necktie

Submitted by Kerry Osborne on Tue, 2013-10-01 20:48

 

Screen shot 2013-10-01 at 3.08.30 PM

 

Performance Reports in SQL Developer 4 EA2

Submitted by oraclebase on Tue, 2013-10-01 10:27

SQL Developer 4 EA2 includes a performance node in the DBA tree.

sqldev-performance

 

You can use this to view ADDM, AWR and ASH reports directly from SQL Developer. I know I can get these from Cloud Control, but previously I tended to pull these out from the command line on the server. This is a much better approach IMHO.

SQL Developer 4 EA2 Connecting to SQL Server

Submitted by oraclebase on Tue, 2013-10-01 10:11

I wrote a blog post some time ago about using SQL Developer 3.x to connect to SQL Server. I tried the same thing today from SQL Developer 4 EA2 and it works just fine.

You have to download the 3rd party JDBC driver and point SQL Developer to it. You can read how to do it here.

Cheers

Tim…

Update: My colleague just told me this.

“If you at any point decide to use Windows authentication to connect (like I just did), you might hit this error:

Status : Failure -I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.