I would still say to check that all the indices you expect exist and are valid on the server with the problem, something like:-
If it's not there, you can use DBA_OBJECTS instead and give it OBJECT_TYPE of INDEX
You could also recalculate the statistics that Oracle uses to pick how it uses the data/indices, with something like a REBUILD INDEX or COMPUTE STATISTICS etc.
Have you got an explain plan from the database to show you what it's doing when it is running a long transaction.
My favoured explanation is that it is either missing an index or not using one, consequently you end up reading the whole table (lots of IO) and performing the equivalent of a massive if in a loop to get the data you want. The explain plan is key. If you see something about a full table scan on a huge table, that is a very good bet.
Try to get a comparable one on the good side and see if there is a difference.
It's been ages since I had this sort of thing so I can't remember how you generate it. I think we might even have used a client tool (Toad or Oracle Discoverer perhaps?) to give us the information. There will be a DBA command line way too I'm sure. From memory (no pun intended) it might be to do with the view V$SQL_PLAN, but I no longer have access to systems like that any more.
how can i monitor usages of CPU, Memory, Hard disk etc. under SUN Solaries
through a c program or java program
i want to store that data into database so i can show it graphically
thanks in advance (2 Replies)
Hi
I would like to monitor CPU usage ( %) , memory utilization and such on an AIX 5.3 with snmp.
How would I do that ? :confused:
If I do "snmpwalk -c public -v1 hosttomonitor" I get nothing about the CPU.
I've done this on Linux ( not much trouble doing it on linux ) but I'm having a hard... (2 Replies)
Does anyone had an issue with AIX reporting huge CPU Usage Times for jobs? I am seeing process using ps that are reporting billions for the CPU Times. This only seems to happen once in awhile. (0 Replies)
I have written a script that will calculate CPU usage and Memory usage of a particular process on AIX Unix. I know the PID and I am using the command --
# for CPU Usage
MSG_CPU_USG=`ps uax | grep ${PID} | awk {'print $3'}`
#for Memory Usage
MSG_MEM_USG=`ps uax | grep ${PID} | awk {'print... (0 Replies)
If somebody knows there are some tools can show how many CPU, memory useage on AIX and can automatically send email?
Such as when setup if CPU is used over 80%, send alert by email automatically.
Maybe BMC has this tool? (6 Replies)
how can I find cpu usage memory usage swap usage and
I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times
my final destination is monitor process
logical volume usage above X % and number of Logical voluage above
can I not to... (3 Replies)
Hi,
I want to monitor the current cpu usage, monitor usage , disk I/o and network utlization for solaris using SNMP.
I want the oids for above tasks.
can you please tell me that
Thank you (2 Replies)
Hello Friends,
On one of my Solaris 10 box, CPU usage shows 100% using "sar", "vmstat". However, it has 4 CPUs and prstat and glance are not showing enough processes to justify high CPU utilization.
=========================================================================
$ prstat -a
... (4 Replies)
OS: AIX
so we frequently receive a lot of cpu related alerts. all types of checks have been created to keep an eye on the cpu but a lot of these checks make too much noise as the CPU is always being seen as high. the system and application owners say there's no issue with the cpu.
so now,... (6 Replies)
Discussion started by: SkySmart
6 Replies
LEARN ABOUT DEBIAN
if_an
AN(4) BSD Kernel Interfaces Manual AN(4)NAME
an -- Aironet Communications 4500/4800 wireless network adapter driver
SYNOPSIS
To compile this driver into the kernel, place the following lines in your kernel configuration file:
device an
device wlan
Alternatively, to load the driver as a module at boot time, place the following line in loader.conf(5):
if_an_load="YES"
DESCRIPTION
The an driver provides support for Aironet Communications 4500 and 4800 wireless network adapters and variants, including the following:
o Aironet Communications 4500 and 4800 series
o Cisco Aironet 340 and 350 series
o Xircom Wireless Ethernet Adapter
Support for these devices include the ISA, PCI and PCMCIA varieties. The Aironet 4500 series adapters operate at 1 and 2Mbps while the
Aironet 4800 series and Cisco adapters can operate at 1, 2, 5.5 and 11Mbps. The ISA, PCI and PCMCIA devices are all based on the same core
PCMCIA modules and all have the same programming interface, however unlike the Lucent WaveLAN/IEEE cards, the ISA and PCI cards appear to the
host as normal ISA and PCI devices and do not require any PCCARD support.
The PCMCIA Aironet cards require PC Card support, including the kernel pccard(4) driver. ISA cards can either be configured to use ISA Plug
and Play or to use a particular I/O address and IRQ by properly setting the DIP switches on the board. (The default switch setting is for
Plug and Play.) The an driver has Plug and Play support and will work in either configuration, however when using a hard-wired I/O address
and IRQ, the driver configuration and the NIC's switch settings must agree. PCI cards require no switch settings of any kind and will be
automatically probed and attached.
All host/device interaction with the Aironet cards is via programmed I/O. The Aironet devices support 802.11 and 802.3 frames, power manage-
ment, BSS (infrastructure) and IBSS (ad-hoc) operation modes. The an driver encapsulates all IP and ARP traffic as 802.11 frames, however it
can receive either 802.11 or 802.3 frames. Transmit speed is selectable between 1Mbps, 2Mbps, 5.5Mbps, 11Mbps or "auto" (the NIC automati-
cally chooses the best speed).
By default, the an driver configures the Aironet card for infrastructure operation.
For more information on configuring this device, see ifconfig(8).
DIAGNOSTICS
an%d: init failed The Aironet card failed to become ready after an initialization command was issued.
an%d: failed to allocate %d bytes on NIC The driver was unable to allocate memory for transmit frames in the NIC's on-board RAM.
an%d: device timeout The Aironet card failed to generate an interrupt to acknowledge a transmit command.
SEE ALSO altq(4), arp(4), miibus(4), netintro(4), wlan(4), ancontrol(8), ifconfig(8)HISTORY
The an device driver first appeared in FreeBSD 4.0.
AUTHORS
The an driver was written by Bill Paul <wpaul@ee.columbia.edu>.
BSD July 16, 2005 BSD