ThatJeffSmith

Tag: monitor

Tailing the Alert Log with SQLcl

Hopefully you’ve heard about the new SQL*Plus we’re building. And hopefully you’ve heard about the new REPEAT command we put into it yesterday. Here’s a quick example of how to build a little ‘monitor’ in just 2 commands, a total of 5 lines of code. The SQL SELECT To_Char(Originating_Timestamp, ‘DD-MON-YYYY HH24:MI:SSxFF’) Time_Entry, substr(message_text, 0, 75) […]

Similar Posts by Subject Areas: , , , ,

How To Add Custom Actions To Your User Reports

I’ve shown you and more than a few customers how to customize your Monitor Sessions page/report. If you need a refresher, that’s here. But basically it comes down to this: Copy the report from the Database Administration section of the Reports panel Paste it to the User Defined Reports section Edit to your heart’s delight […]

Similar Posts by Subject Areas: , , , ,

Watching Paint Dry or V$SQLTEXT_WITH_NEWLINES

How much time to do you spend debugging database application problems? Probably more time than you want. How much of that time is spent capturing the SQL that is being submitted by your application to the database? I’m going to guess that it’s a significant amount. Asssuming you have access to production (or a test […]

Similar Posts by Subject Areas: , , ,

SQL Server VS Oracle: Index Monitoring

Jealousy is not an emotion I generally feel for the SQL Server technology stack. I covet their Twitter camaraderie, but I ‘know’ that Oracle can counter just about anything thrown at it. People that Helped Me with this Post I was reminded that even old dogs can be taught new tricks while monitoring the #SQLSaturday […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , , ,