08.28.10
Posted in Tips at 12:18 am by elephant
You probably know by now that Insider fires about a hundred alerts to let you know something is wrong with your server or database. Just about every possible problem condition has already been included into this rich set of alerts and it won’t require you to do anything – it comes out of the box. But what if you need to add a custom alert? Something specific to your environment or application? Well, you can do it with Insider. Nothing can be easier.
All you have to do is to send a message to ‘INSIDER’ pipe, using Oracle DBMS_PIPE package. Here is how:
DECLARE
RES INTEGER;
BEGIN
DBMS_PIPE.PACK_MESSAGE('My custom alert');
DBMS_PIPE.PACK_MESSAGE('ON');
DBMS_PIPE.PACK_MESSAGE(50);
RES:=DBMS_PIPE.SEND_MESSAGE('INSIDER');
END;
And here is what you’ll get:
that was easy, wasn’t it? Read the f the Insider User Guide’s “User-defined alerts” section for more info
Permalink
08.11.10
Posted in Tips at 5:13 pm by elephant
Have you ever wondered – who is thrashing my little server? Whose session is bogging down the database? Are you ready to pack up the way Arnie used to when he was a boy and go find the villain? And don’t forget those huge army metal shears – you’ll need it later. So, there is nothing simpler:
Check out the Session view and sort by Activity column – the one atop, spinning like mad – he is your primary target. Go get’im. Find his network cable. You know what to do.
Oh, yes and:
I’LL BE BACK
Permalink
08.02.10
Posted in Tips at 11:19 pm by elephant
Despite our best efforts we found out that not everybody knows how to use all of the features of Insider, which is not surprising – there are too many of them. So we thought a tip of the day (week?) can be a little help. So here is the first one. I want to know what table/index is taking up all the space in my tablespace. Yes, I know, DBA_EXTENTS and all that stuff. Save yourself a minute. Open the Storage tab and check out the Objects subview. Click on the Size column to sort in descending order. Voila, here is your bad boy
Oh, yes, and while we are at that, here is a random thought of the day: Insider is the best monitoring/performance tuning tool for Oracle, period. And if anyone knows where I put my glasses, please, don’t hesitate to comment
Permalink
07.14.10
Posted in Business at 2:50 pm by elephant
Insider 3.1 is out. It features an auto-switching mode (sort of a slide show across all open servers), a new Oracle buffer pool contents view and Scheduler jobs view. A new bind variables tab shows the actual bind variable values for a selected session’s SQL. A new alert has been added when a number of active sessions goes above a set threshold. A number of improvements has been made to Insider tables, including:
- Search. You can now search inside a table. Just click within the column you want to search and start typing
- Expand/collapse all if a table includes a tree-like structure (such as sessions)
- Row count has been added
Permalink
11.02.09
Posted in Business at 5:05 pm by elephant
Just minor improvements and bug fixes. Come and get it
Permalink
03.11.09
Posted in Business at 3:05 am by elephant
The much awaited version 3.0 of Insider has been released. Support for Oracle Real Application Clusters now includes:
- RAC View. RAC View shows all Oracle RAC instances along with cluster-specific information such as interconnect statistics and cluster-specific alerts on a single view
- A new Enterprise View item allows the user to create and monitor an Oracle RAC database as a single server
Other enhancement include a user-configurable timeout option and advanced session filter. If a query exceeds a specified timeout it is canceled and an alert is triggered. Advanced session filter can help find only the sessions the users interested in or speed up session information retrieval.
Permalink
06.10.08
Posted in Business at 7:04 pm by elephant
Insider 2.2 for SQLDeveloper has been released. This version is compatible with SQLDeveloper 1.5
Permalink
04.24.08
Posted in Business at 6:01 am by elephant
Insider 2.2 has been released. What’s new:
- Version 2.2 adds supports for grouping. Groups of servers such as Development and Production, or Europe and US can be created
and servers can be assigned to a group. Enterprise view items (servers) can be added (drag and dropped or created within) to
a group or removed from the group. Groups can be
nested (a group within another group). Groups show how many servers they include (total, including all subgroups), how many
paused and how many are down. A group shows alerts from all its servers, the server name is shown on the alert.
Monitoring of all servers within a group can be paused/resumed with a single command. All critical alerts can be acknowledged
by selecting Acknowledge on the group item
- Multiple alert profiles can be created and assigned on a per server basis.
- Multiple notification profiles can be created and assigned on a per server basis.
- Multiple schedules and administrators can be created.
- Alerts acknowledgment history dialog.
- Support for MySQL and Oracle as an internal database
and other enhancements and bug-fixes
Permalink
04.11.08
Posted in Business at 4:37 pm by elephant
Digger 2.2 has been released. This version fixes some of the issues found in 2.0 and 2.1
Permalink
01.18.08
Posted in Business at 11:29 pm by elephant
Digger 2.0 has been released. You can now enter a SQL or create a SQL script and profile it in one click. Digger will
- Open an Oracle session
- Enable trace
- Run the SQL or script
- Stop tracing
- Close session
- Identify the directory and trace file on the server
- Copy the file over to the client machine
- Open and analyze it
All in one click!
Or you can open a list of currently connected sessions, pick one and start profiling without leaving Digger. Download and enjoy!
Permalink
« Previous entries Next Page » Next Page »