 |
|
|
|
|
Benefits of DBAip DBAct
|
 |
DBAip DBAct enables deep drill down diagnostics into issues
immediately impacting database performance.
Sample areas
are:
Latching Investigation
Detailed Transactional locking investigation
Internal DDL Locking and contention
Identification of Top CPU Consuming sessions/machines
Internal Buffer busy waits contention/blocking sessions
Fragmentation of Shared Pool and Shared Pool Free
Space
Waits on Segments/Data Blocks
Resource manager performance and contention |
|
DBAip DBAct enables deep real time performance sampling
on most important database dynamics.
Sample areas for dynamic performance snapshot are:
Real time snapshot of most frequently executing SQL
Real time snapshot of most frequently parsing SQL
Real time snapshot of SQL consuming most Buffer Gets (CPU consumption)
Real time snapshot of top machines waiting on provided wait event
Real time snapshot of top machines increasing count of provided statistic
Real time snapshot of Top File System I/O performance
Real time snapshot of Top Datafile I/O performance
|
| DBAip
Act enables low level tracing.
Sample tracing areas
are:
10046 level 12 per Machine tracing
10046 level 12 per OS Process Id/Session id
10046 level 12 per Module/Program
tracing
10046 level 12 per SQL Tracing
Internal Oracle systemstate/library_cache/heapdump/hanganalyze
tracing
|
|
|
DBAip DBAct enables deep drill down into
performance view information and saves DBA from constantly
typing SQL during the problem investigation and
resolution, when TTR is critical.
Sample areas are:
Finding SQL in Shared Pool by pattern
Currently executed
SQL
Finding SQL by provided hash value/SQL id
Finding SQL executed by provided
OS process id
Creating SQL Plan from provided hash value/SQL id
Creating SQL Plan
from provided file
Viewing contents of buffer cache per object
Machines Drill Down Information
-Connection Per machine
-Active SQL Per machine
-Open Cursors and Open Cursors per connection
ratio
-...
Information about newly parsed sql in shared pool
Information
about running parallel queries/parallel slaves
PGA/SGA drill down
Information
Buffer Pools information |
|
|
DBAip DBAct enables deep drill down into
dictionary information and relives DBA from constantly typing
SQL accessing catalog tables during the
problem investigation and resolution, when TTR is critical.
Sample areas are:
Fast report on table/index/column level CBO statistics
Fast report on newly
created object in the database
Fast report on invalid objects
Detailed information on database users
Detailed information on tablespace,
datafiles, used and free space
Detailed information on used space in
temp tablespaces per user
Detailed information on Table/Index partitions
Detailed information
on table indexes/columns
Detailed information on segment distribution
across file systems
Fast access to definition/code of Views/Triggers/PLSQL
objects
Fast access to definition/code of internal Oracle x$ Views
Fast access
to definition/values of internal Oracle _parameters |
|
|
DBAip DBAct provided utility functions
that greatly help DBA in problem investigation and resolution.
Sample utility functions are:
Display OS process id for the given session id
Display session id for the
given OS process id
Display Machine for the given process id
Display Client process id for
the given OS process id/Session id
Decode DBA number into file number,
block number, file name and segment name
Convert “dd/mm/yyyy hh24:
mi: ss” to redo log dump redo
time |
|
|
|
|
|
Privacy Policy
| Legal © DBA InfoPower, Inc.
| 408.732.4885
| Contact Us
| Feedback
| Support
| Site Map
|
|
|
| Community
|
|
|
Download Act
Download PEi
Free Downloads
db22 DB2 DBA Tool
SQL Review -
SQL Formatter
|
|
DBAip Support
Send Suggestions
DBAip Careers
|
Contact Us - 408.732.4885
|
| News |
| July 2nd, 2007 |
| New version of Performance Explorer-i released |
| New 4.0.2 Version of Performance Explorer-i - DBA InfoPower’s root cause analysis product has been released | | |
| March 4th, 2007 |
| New version of Performance Explorer-i released |
| New 4.0.1 Version of Performance Explorer-i - DBA InfoPower’s root cause analysis product has been released | | |
| January 14th, 2007 |
| New version of DBA Act released |
| New 2.2.1 Version of DBA Act - DBA InfoPower’s real-time problem remediation and performance analysis product has been released | | |
| November 13th, 2006 |
| SUN Partnership |
| DBA InfoPower Inc. is becoming approved SUN partner | | |
| |
|
