9
The Server Dimension
The Server dimension identifies the Web server that handled the request.
This chapter contains the following topics:
Server Dimension Hierarchies
The Server dimension contains one hierarchy:
The sections that follow list the level in this hierarchy, followed by a diagram that provides a graphical representation.
The Server Hierarchy
This hierarchy contains one level. For details about the attributes of this level, see Server Dimension Levels.
Figure 9-1 The Server Level Hierarchy

Text description of the illustration server-h.gif
Server Dimension Levels
The Server dimension is comprised of the following level. For this level, information about each attribute (column name) is provided in the following format:
- Attribute: Description (example value)
In addition to the pre-defined attributes, the level contains five "generic" attributes that can be defined by the user.
CLK_L_SERVER_FARM
- Server_Farm_Code: Identifying code of the server farm to which the server belongs; natural key (WF1)
- Server_Farm_Name: Name of the server farm to which the server belongs (Web Farm 1)
- Server_Farm_Attributes 1-5: Server farm level user-defined attributes
CLK_L_SERVER
- Server_Click_Code: Server identifier taken from the clickstream (svr1, svr1.us.oracle.com)
- Server_Name: User friendly name assigned to the HTTP server/listener (Web Server 1)
- Server_Hostname: DNS hostname of the server (dms.joaz.com)
- Server_Description: Description of the server machine (User-defined)
- Server_Listener_Port: Port on which this HTTP server listens (80)
- Server_Listener_Software: Name of listener software, such as the brand of Web server (Apache)
- Server_Architecture: Computer architecture on which the server is running (i386, i586, sun4m, SunE10000)
- Server_OS_Name: Operating system on which the server software is running (Windows, Linux, SunOS, Solaris, HP/UX)
- Server_OS_Version: Operating system version (NT 4, 2.0.30, 5.6)
- Server_CPU_Count: Number of CPUs installed in the server (1,2,...)
- Server_CPU_Speed: Clock speed of the CPUs (300 MHz, 600 MHz)
- Server_CPU_Vendor: Manufacturer of the CPUs in the server (Sun)
- Server_Main_Memory_Size: Amount of RAM installed in the machine (4 GB)
- Server_Cache_Memory_Size: Amount of the first level cache memory installed in the server (2 MB)
- Server_Storage_Capacity: Capacity of the primary storage device
- Server_Storage_Raid_Level: RAID level of the primary storage device (0,1,3,5)
- Server_Storage_Vendor: Vendor of the primary storage device
- Server_Attributes 1-5: Server level user-defined attributes