ThatJeffSmith

Tag: DBA

A Quick Hit on Database Auditing Support

View – DBA – Security – Auditing A user asked how to use SQL Developer to audit user XYZ. And to be honest, it’s not really set up to work that way. You define operations or objects you want audited. Any user that does XYZ to object ABC will get logged. There’s an exception to […]

Similar Posts by Subject Areas: , ,

Videos: Oracle Open World 2014 SQL Developer Talks

For this year’s Open World, SQL Developer got lots and lots of love from the conference organizers and keynote speakers. I think SQL Devleoper was mentioned, demoed, or both in at least 3 of the executive keynotes. We had many successful, and FULL, hands on labs – led by the lovely Ashley Chen. And our […]

Similar Posts by Subject Areas: , , , , ,

Oracle SQL Developer for the DBA

Wait, I thought SQL Developer was for developers? Yes, but it also provides a ton of features and value for the DBA. So if you’re already in SQL Developer to browse a table or run a query, you can fire up the DBA features under the View menu (and maybe save yourself an alt-tab to […]

Similar Posts by Subject Areas: ,

Oracle SQL Developer and Database Auditing

Did you know Oracle SQL Developer allows you to configure Database Auditing and view your audit trails? Well, now you do! This is not new for version 4.0, but the screenshots in this post are from version 4.0. This feature is available under the DBA panel, which can be found on the View menu. I […]

Similar Posts by Subject Areas: , ,

SQL Developer 4 and the Oracle Diagnostics Pack

Oracle Database Enterprise Edition customers have the option of extending their functionality set via various optional ‘packs.’ One of the most popular packs is the Oracle Diagnostics Pack. Funny, most people call it the ‘Diagnostic’ Pack, but it’s technically known as the Diagnostics Pack. Anyways, the pack includes a LOT of features. You can see […]

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer v4EA2 Is Now Available

EA1 dropped in July. Now here we are a little more than a week before Oracle Open World and we are making Early Adopter 2 of Oracle SQL Developer version 4 available for you to download and provide feedback. There’s two big things you need to know about: About 500 bug fixes Support for ADDM/AWR/ASH […]

Similar Posts by Subject Areas: , , , , ,

Why are developers in Prod? (Again!?!)

I received a very interesting question from a reader the other day, which is awesome for two reasons. One, it gives me something to think about and play with. And ‘B’, it provides me with material for today’s blog post. So here’s the original question – We would like to capture inofmation like who, when […]

Similar Posts by Subject Areas: , ,

An Introduction to SQL Developer Extensions

Oracle SQL Developer is made available to you for free, and is chock-full of features for the developer, DBA, or data-junkie. 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. While SQL Developer is NOT an open-source project, it does […]

Similar Posts by Subject Areas: , , ,

Manage All of Your Jobs Using Toad

I mentioned the other day what a pain it was to manage a database that had both DBMS_JOBS and DBMS_SCHEDULER being utilized to run jobs. One of my peeps, @Boneist reminded me it was even harder for her because Toad deemed it necessary to purchase an optional ‘DB Admin module’ to work with the DBMS_SCHEDULER […]

Similar Posts by Subject Areas: , ,

Developers…In..Prooooooood!

Coming up with themes and titles for a blog post can be very challenging. You want something that will catch the eye, but not be so random or out of left field that no one catches your drift. This morning I had two themes battling inside my head for this post. Welcome to the Jungle […]

Similar Posts by Subject Areas: , , ,

Are you a real DBA?

I’m sorry, I didn’t realize there was such a thing as a ‘fake’ DBA Jeff! Ok, so labeling someone as a ‘real’ DBA is a bit insulting to DBAs everywhere. If you have children, that makes you a parent. If you are responsible for a database, then you are a DBA. So what exactly am […]

Similar Posts by Subject Areas: , ,

Must Have Scripts

My former boss, and current friend, bought an Android phone for himself and his wife last week and asked me for a list of my must-have apps. I’ll list them here for the morbidly curious, but that got me thinking – what are my must-have scripts for managing my Oracle database? I know we’re supposed […]

Similar Posts by Subject Areas: , , ,

DBAs Versus Developers

On Thursday, September 30, 10:30AM EST, Bert Scalzo and I will be doing a Quest sponsored Webcast – “DBAs Versus Developers.” Sign Up/Register for the Webcast That sounds awfully contentious, Jeff! When visiting customers I am often talking to a group of developers in the morning and DBAs in the afternoon. In the morning, I […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,