| Home E-mail Us Oracle Articles New Oracle Articles
|
Oracle Business Network. TERMS OF TEMPORARY USE. Welcome to the Oracle Business Network ('Oracle SN'). Oracle provides electronic message setup and routing through Oracle BN subject to the following terms and conditions, which may be changed from time to time by Oracle, without notice to you. The Oracle Supplier Network (OSN) enables electronic document transformation and routing between companies through a single connection point that Oracle hosts and manages. The Network also allows Buying organizations to allow direct connectivity to their Oracle iSupplier Portal sites for supplier users to access. Only one ACL can be assigned to any host computer, domain, or IP subnet, and if specified, the TCP port range. When you assign a new access control list to a network target, Oracle Database unassigns the previous access control list that was assigned to the same target. However, Oracle Database does not drop the access control list.
Oracle Network & Wireless Cards Driver Download For Windows 10
Question: How do I use the AWR dba_hist tables to monitor Oracle network performance. What views contain network performance and how to I make scripts to monitor network performance in Oracle? Answer: Oracle only see the network via SQL*Net (Oracle*Net), but Oracle does provide some good network monitoring tables in AWR. Database Wait Events in the dba_hist Views Database wait event statistics show how much and how long Oracle processes had to wait for a particular type of database resource in order to process their work. These wait events are grouped by Oracle into several categories including Administrative, Application, Cluster, Commit, Concurrency, Configuration, Idle, Network, Other, Scheduler, System I/O, and User I/O. Wait event data can be used effectively if the wait events are ordered by wait time. This way, the most significant wait events are found first which makes them the lead candidates for further investigation. The output of the wt_events_int_10g.sql script displays the wait events ordered by wait times in seconds. col c1 heading 'end|time' format a10 end wait time From AWR, you can query the dba_hist_system_event table to see the amount of time Oracle has waited for network packets. As you recall, there are several system events that can show us network activity: SQL> select distinct event from dba_hist_system_event 2 where event like 'SQL%';EVENT ----------------------------------------------------------------SQL*Net break/reset to clientSQL*Net message from clientSQL*Net message from dblinkSQL*Net message to clientSQL*Net message to dblinkSQL*Net more data from clientSQL*Net more data to clientFrom this AWR table, we can select all of the significant events, the number of waits, and the average wait time in seconds. Remember, most networks such as TCP/IP send an acknowledgement when a packet has been received. Running the query against an Oracle database that is experiencing performance problems will give you very good insight into the causes of external event problems. set pages 999 set lines 90 column c1 heading 'Event|Name' format a30 column c2 heading 'Total|Waits' format 999,999,999 column c3 heading 'Seconds|Waiting' format 999,999 column c4 heading 'Total|Timeouts' format 999,999,999 column c5 heading 'Average|Wait|(in secs)' format 99.999 ttitle 'System-wide Wait Analysis|for current wait events' select event c1, total_waits c2, time_waited / 100 c3, total_timeouts c4, average_wait /100 c5 from sys.v_$system_event where event in ( 'SQL*Net break/reset to client', 'SQL*Net message from client', 'SQL*Net message to client', 'SQL*Net more data to client) and event not like '%done%' and event not like '%Idle%' order by c2 desc ; The v$system_wait_class view can be useful as the first source of information about where database spends the most time waiting. The wait_class_pct_ash.sql query can be used to take a quick look at system-wide wait activity and to quickly identify possible problem areas: column TOTAL_WAITS format 999,999,999 column PCT_WAITS format 99.99 column TIME_WAITED format 999,999,999 column PCT_TIME format 99.99 column WAIT_CLASS format A20 SELECT wait_class, total_waits, ROUND(100 * (total_waits / sum_waits),2) pct_waits, time_waited, ROUND(100 * (time_waited / sum_time),2) pct_time FROM (SELECT wait_class, total_waits, time_waited FROM WHERE (SELECT SUM(total_waits) sum_waits, SUM(time_waited) sum_time FROM v$system_wait_class WHERE wait_class != 'Idle') ORDER BY 5 DESC; The sample output of the above query is presented below: WAIT_CLASS TOTAL_WAITS PCT_WAITS TIME_WAITED PCT_TIME -------------------- ------------ --------- ------------ -------- Network 9,664,173 58.17 7, 623 .40 Here is a sample of the output from this report, showing the events and the wait times for each event. This is a great report for showing specific times when the network is overloaded with packet traffic. These AWR reports can often give the DBA an idea about potential network problems because Oracle captures the number of seconds that have been waited for each distributed event. Of course, Oracle can identify a latency problem, but we need to go out to the network to find the exact cause of the network problem.
|