Tag: Database – SQL

Sample Visio – High Level Architecture of the Apache Web Server

The high level architecture of the Apache web server is not very different from the high level conceptual architecture, in the sense that we still find the same splitting of functionality between the core and the modules. In addition to the Apache core and the modules we can identify some new small modules. Two of… Continue reading Sample Visio – High Level Architecture of the Apache Web Server

Sample – Oracle SLA / OLA Server Response Time Monitoring Considerations

The following SLA / OLA Oracle Server Counters are supported by Oracle version 10g or higher: Number of active connections Buffer Cache Hit Ratio CPU Usage Per Second CPU Usage Per Transaction Current Logons Count Current Open Cursors Count Current OS Load Cursor Cache Hit Ratio Database CPU Time Ratio Host CPU Utilization (Percentage) Disk… Continue reading Sample – Oracle SLA / OLA Server Response Time Monitoring Considerations

Sample – Useful Interbase queries

Interbase is a high performance, multiplatform and scalable relational database. Below are some common queries you can use. SELECT TMP$ATTACHMENTS FROM TMP$DATABASE Number of active connections (SMALLINT)  SELECT TMP$STATEMENTS FROM TMP$DATABASE Number of compiled statements (INTEGER)  SELECT TMP$ALLOCATED_PAGES FROM TMP$DATABASE Pages allocated to all database files (INTEGER)  SELECT TMP$POOLS FROM TMP$DATABASE Number of memory pools… Continue reading Sample – Useful Interbase queries

Sample Excel – Vulnerability Management Spreadsheet

Free – Excel document download Vulnerability Management

Sample Word – RedHat Enterprise Server Standard

Free Word document download  Server security requirements are increasing OpenEdge security depends on the OS security system Administrator requirements are few, and there always willing to accept risk and Alternative methods RedHat Enterprise Server Standard

Sample Excel – Network Log Management Spreadsheet

Free – Excel document download Network Log Management

Sample Excel – Firewall Log Management Spreadsheet

Free – Excel document download Firewall Log Management

Sample Excel – Microsoft Application Compatibility Matrix Spreadsheet

Free – Document download Microsoft Application Compatibility Matrix Spreadsheet www.bestitdocuments.com

Sample Visio – Configuring Firewalls When Managing Oracle Application Server

If you are using Grid Control to manage instances of Oracle Application Server, there may be other ports that you need to access through a firewall, depending upon your configurations. For example, when you are monitoring the performance of your Oracle Application Server instance from the Grid Control Console, you can click Administer on the… Continue reading Sample Visio – Configuring Firewalls When Managing Oracle Application Server

Sample Word – Enterprise Manager Grid Control Server

The topology viewer is supported only on Internet Explorer Grid Control offers you several tools to help diagnose service problems and determine the potential causes. Performing configuration management for: Configuration Information Startup Backup Shutdown Jobs  Job Activity Configuration Comparison Policy Management Compliance Monitor Free – Document download Enterprise Manager Grid Control Server

Data Value Lifecycle Management

Overview: Data Archiving which is the disciplined process by which data is migrated or copied and migrated for long term retention under a chain of custody control to media at designated archive location/s where retention, security, retrieval, rendering, and authentication are all specified by formalized archiving policy The value of data changes over time… Spend… Continue reading Data Value Lifecycle Management

Sample Excel – Brocade, Barracuda, F5 and Citrix Load Balancing Load Balancing Request Form

Free – Excel document download Load Balancing Load Balancing Request Form www.bestitdocuments.com

Fair and Accurate Credit Transactions Act (FACT) and related global regulatory requirements

Fair and Accurate Credit Transactions Act (FACT) and related global regulatory requirements TREAD Act NASD 3110 IASB/FASB Computer Fraud and Abuse Act SEC Rules 17a-3 and 17a-4 Computer Security Act Canada’s PIPEDA Foreign Corrupt Practices Act Customs C-TPAT EPA Basel II FDA 21 CFR 11 CA SB 1386, 1950 FISMA E.U. Data Protection Directive U.K… Continue reading Fair and Accurate Credit Transactions Act (FACT) and related global regulatory requirements

Suggestion – Securing Oracle Environments

Suggested Oracle Standard Corporate’s business functions rely upon the integrity, confidentiality, and availability of its computer systems and the information assets stored within them. Responsibilities and procedures for the management, operation and security of all information processing facilities must be established. This standard supports the stated objectives. Requirements and Implementations Authentication Default account’s passwords of… Continue reading Suggestion – Securing Oracle Environments

Oracle Server Performance Monitoring Considerations

The following Oracle Server 10g or higher counters that can be monitored as part an SLA: Number of active connections Buffer Cache Hit Ratio CPU Usage Per Second CPU Usage Per Transaction Current Logons Count Current Open Cursors Count Current OS Load Cursor Cache Hit Ratio. Database CPU Time Ratio Host CPU Utilization (Percentage) Disk… Continue reading Oracle Server Performance Monitoring Considerations