Lighty 1.5 released soon with new exciting features, and few bug fixes making Lighty For Oracle, the ideal partner for the database administrator. For more information on this update, read more …
The last month, Orachrome announcing Lighty 1.4.3. Today his successor appeared with more features !
The new version 1.4.4 will save you time.
Now you can import and / or export your connections between Lighty software. The export can be done in CSV. You can also kill a session from the interface.
In addition you will have more detailed information about your databases. A new button « on / off » will allow easier access to tracks of a session. Furthermore, you can launch a snap Statspack / AWR and L-ASH / ASH from the interface. It will allow you to have an account customizable schedule your sessions.
Have you got questions ? Contact us at email@example.com or +33 4 84 25 11 28.
Engagement, quick win and win-win relationchip, are the values that Orachrome try to build with customers.
Lighty, have for target to give the best delay of Return On Investment (R.O.I.) for partners (customers, suppliers, partners,…).
March 2016, the new version (1.4.3) including news fonctions than improved Lihgty in a mobility situation.
Severals buggs, particulary ID Hardware problems are fixed, and many new functions are available.
DOWNLOAD IT NOW ! Try the best tool to pilot the Oracle Database !
Most of the time, when we have to make a real-time analysis, the first thing we look at, is the database activity from ASH (Active Session History). In many cases, this is enough to have à good explanation of what happens.
Lighty allows you to view the ASH activity through the « Activity Viewer » tab as well as special reports (Current activity (ASH)). You can also install L-ASH if you are not licensed for ASH
But sometimes we need to have an overall view of the current activity and quickly have answers to questions as:
- Are the I/Os efficient ?
- What are the top events ?
- Are there blocking sessions ?
- Is the server overloaded ?
- What are the on going operations ?
- Who is using the temporary space ? PGA ?
- What are the active sqls ?
Some days ago, a customer encountered an application hang in its production database.
A little version upgrade was in progress. The upgrade was done online during the day because of the small ddl changes.
There were 4 ddls to execute. The first 3 were ok but the problem occurred when the last one started.
It’s just a column update to allow null values.
Normally, the sql runs in a few milliseconds as it modifies only the dictionary.
alter table TABLE_NAME modify COLUMN null;
But this time, the sql took nearly 25 minutes to run with a lock in the library cache, preventing access to the table and causing the application hang.
The entire table was read and all blocks have been modified. The table contains more than 100 million rows.
So, why ?
If you don’t have the diagnostic and tuning packs licensed or if you use a standard edition, features like AWR and ASH are not available. These features are essential to analyze the activity of your databases.
ASH (Active Session History) is certainly the most improvement in recent years in terms of monitoring activity.
It has radically changed our approach to performance problems. This feature has now become essential and many articles have been written about its usage.
An alternative solution exists that allows you to have all the necessary elements to make your analysis :