Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Current Affairs
General Knowledge
Chemical Engineering
UPSEE
BSNL
ISRO
BITSAT
Amazon
ORACLE
Verbal Ability
→
Ibm Informix Tutorial
→
Ibm Informix Interview Questions in Ibm Informix Tutorial
→
And Why Are These Important ?
1.
And Why Are These Important ?
Answer»
Monitor impact on system’s CPU:
Instance sys vcpu + Instance user vcpu
Locks requests / waits
Active locks
Monitor impact on system’s storage (IO) / memory:
Buffer reads / writes / waits
Page reads / writes /
Disk reads / writes
LOGICAL
contention:
lock requests / waits
deadlocks
EVENTUALLY
rollbacks
Monitor instance health & status
Dbspaces
TOTAL
/ used / free
SPACE
Checkpoint intervals & duration
Sequential scans number
Number of not yet backup-ed logical logs
Number of active sessions
And of course the instance
ONLINE
log.
Show Answer
Discussion
No Comment Found
Post Comment
Related InterviewSolutions
What Is A Chunk In Informix ?
What Are The Database Server Operating Modes Available For Informix? Explain Each.
What Is An Extent In Informix?
What Is An Informix Instance?
Explain About Light Scans In Informix ?
What Is A Binary Large Object ?
What Are The Options/commands Used Which Dbspace A Database Resides?
What Can Be Used To Capture An Isam Error From An Informix Odbc Program On Unix ?
Why Do Foreground Writes Decrease Performance ?
Explain The Concept Of Fragment Elimination In Informix ?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies