Hot news

Why Oracle DB?

Oracle is the most suitable DB for storing data in high- security mode, arranging BigData , implementing any idea in many applications . ...

Showing posts with label TOAD. Show all posts
Showing posts with label TOAD. Show all posts

2018-02-04

Be Admin

To be or not to be an Oracle DB admin? Be! It's easy as there are many helpful applications:
* DBSAT
Oracle Database Security Assessment Tool is provided at no additional cost and enables customers to quickly find:
- Security configuration issues, and how to remediate them
- Users and their entitlements
- Location, type, and quantity of sensitive data
* TOAD for Oracle (including some DBA tools) empowers you to:
- Implement consistent and repeatable processes, supporting agile DB development.
- Accelerate application delivery, while minimizing risks associated with database changes.
- Ensure functional accuracy and scalability with automated testing.
- Quickly pinpoint and resolve database performance inefficiencies.
- Automate SQL optimization.
- Automate and schedule complex or routine database tasks.
* DBA tools in SQLDetective:
- Session Navigator,
- Storage Manager,
- Database Examiner,
- Top Session Locator,
- Database Monitor,
- DBs Comparer,
- Tablespace, User, Role, Directory, Context, Profile, Edition, Rollback Segment, Restore Point, Resource Consumer Group, Sched.Job Class, Sched.Window, Sched.Group, Sched.Destination wizards, RAC and Exadata supporting.
* Security Audit Report in ClearDB Documenter detects database vulnerabilities, captures the deficiencies in security measures and processes, and identifies shortcomings in their implementation.

Or ask other professionals in community.

2018-01-23

Code Review automation

Benefits of Code Review was good listed in the "Getting to Working Software: Code Reviews – Benefits" article from Gil Zilberfeld.
Code Review automation may be done by one value - Maintainability Index "MI" (see "Качество кода одним числом". The most of applications for developers (SQLDetective or TOAD for Oracle developers) count MI even never institutes approved the minimum value - 65 with code comments or 85 for languages without necessity of comments.
As Code Review is a part of white-box testing then I should recommend you the following topics:
Easy "white-box" testing
Документор кода или псевдокод
Call Tree диаграммы в ClearSQL 
CRUD matrices in Conquest products