| Wiki Markup |
|---|
{scrollbar}
----
Through the profiler |
...
Through the profiler service,
...
information
...
generated
...
by
...
each
...
cube
...
published
...
in
...
O3
...
Server
...
is
...
stored
...
in
...
files
...
like
...
the
...
one
...
described
...
below.
...
Each
...
cube
...
generates
...
one
...
separate
...
file.
...
Generation
...
:
...
one
...
record
...
is
...
created
...
each
...
time
...
a
...
query
...
is
...
performed
...
on
...
a
...
cube.
...
Field |
|---|
...
Name |
|---|
...
Type | Description | |
|---|---|---|
Date | dd/mm/yyyy |
...
Date |
...
of |
...
the |
...
query |
...
Hour | hh:mm:ss |
...
Time |
...
of |
...
the |
...
query |
...
Precalc | String | It states if any redundancy level has been calculated. Its values can be: True or False |
query_level | String | Level the query was made at |
View | String | If the user has accessed the cube through a view, it states the name of such view |
User | String | User who made the query |
Role | String | Role through which the user who has made the query accessed the cube |
Ip | String | IP Address from which the user who has made the query is accessing the cube |
query_time | Integer | Query time in milliseconds |
distance | Integer | Distance between query level and precalc as vectors difference |
blocks_accesed | Integer | Total number of blocks accessed to solve the query |
blocks_fault | Integer | Total number of blocks that were not found in the cache and were necessary to solve the query |
used_cube_cache | Integer | Size of the cache used by the cube at the time of the query measured in blocks |
...
| Child pages (Children Display) |
|---|
| Wiki Markup |
|---|
{scrollbar} |