Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
This material is the confidential property of Oracle Corporation or its licensors and may be used, reproduced, stored or transmitted only in accordance with a valid Oracle license or sublicense agreement.

Field Index SQL Mapping

Class /performance_snapshot

Base class for storing BRM performance data

Notes

  • This object can be read only by the owner.
  • This object can be modified only by the owner.
  • This object can be created by anyone.

Links



Field Index

Type Field Name
poid PIN_FLD_POID
timestamp PIN_FLD_CREATED_T
timestamp PIN_FLD_MOD_T
string PIN_FLD_READ_ACCESS
string PIN_FLD_WRITE_ACCESS
string PIN_FLD_CREATE_ACCESS
poid PIN_FLD_ACCOUNT_OBJ
int PIN_FLD_DURATION_SECONDS
timestamp PIN_FLD_END_T
string PIN_FLD_NAME
string PIN_FLD_HOSTNAME
int PIN_FLD_PID
array PIN_FLD_RESULTS
string
int
int
string
int
int
string
string
decimal
decimal
decimal
decimal
decimal
decimal
decimal
decimal
int
decimal
decimal
timestamp
decimal
decimal
timestamp PIN_FLD_START_T

Class /performance_snapshot/realtime

Realtime System Transaction

Notes

  • This object can be read only by the owner.
  • This object can be modified only by the owner.
  • This object can be created by anyone.

Links



Field Index

There are no fields defined in this derived class.

Field Details

poid PIN_FLD_POID

Object Identifier for an instance of this class. Portal object ids have four pieces of information: database number, class type, sequence id, revision.

Notes

  • System defined on object creation
  • Can be modified only by System

Links


timestamp PIN_FLD_CREATED_T

Time the object was created.

Notes

  • System defined on object creation
  • Can be modified only by System

Links


timestamp PIN_FLD_MOD_T

Time the object was last modified.

Notes

  • System defined on object creation
  • Can be modified only by System

Links


string PIN_FLD_READ_ACCESS

Read Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links


string PIN_FLD_WRITE_ACCESS

Write Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links


string PIN_FLD_CREATE_ACCESS

Create Access level for object. Valid values are O(BrandOwner), R(Root), N(Any).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links


poid PIN_FLD_ACCOUNT_OBJ

Notes

  • Required on object creation
  • Can be modified

Links


int PIN_FLD_DURATION_SECONDS

Notes

  • Required on object creation
  • Can be modified

Links


timestamp PIN_FLD_END_T

Notes

  • Required on object creation
  • Can be modified

Links


string PIN_FLD_NAME

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links


string PIN_FLD_HOSTNAME

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links


int PIN_FLD_PID

Notes

  • Required on object creation
  • Can be modified

Links


array PIN_FLD_RESULTS

Notes

  • Can be specified on object creation
  • Can be modified

Links


string PIN_FLD_FILENAME

Notes

Links


int PIN_FLD_LINE_NUMBER

Notes

Links


int PIN_FLD_FLAGS

Notes

Links


string PIN_FLD_FUNCTION

Notes

Links


int PIN_FLD_ITEM_LEVEL

Notes

Links


int PIN_FLD_PARENT_ELEMENT_ID

Notes

Links


string PIN_FLD_PROGRAM_NAME

Notes

Links


string PIN_FLD_OBJECT_TYPE

Notes

Links


decimal PIN_FLD_CALLS

Notes

Links


decimal PIN_FLD_TOTAL_ELAPSED

Notes

Links


decimal PIN_FLD_MIN_ELAPSED

Notes

Links


decimal PIN_FLD_MAX_ELAPSED

Notes

Links


decimal PIN_FLD_RECORDS

Notes

Links


decimal PIN_FLD_CACHE_COUNT

Notes

Links


decimal PIN_FLD_CACHE_ELAPSED

Notes

Links


decimal PIN_FLD_ERRORS

Notes

Links


int PIN_FLD_BUCKET_ID

Notes

Links


decimal PIN_FLD_BUCKET_START

Notes

Links


decimal PIN_FLD_BUCKET_END

Notes

Links


timestamp PIN_FLD_EFFECTIVE_T

Notes

Links


decimal PIN_FLD_USER_CPU_TIME

Notes

Links


decimal PIN_FLD_SYSTEM_CPU_TIME

Notes

Links


timestamp PIN_FLD_START_T

Notes

  • Required on object creation
  • Can be modified

Links


There are no fields defined in this derived class.

SQL Mapping

Links


Type Field Name Table Column Name
base-class /performance_snapshot performance_snapshot_t
poid PIN_FLD_POID poid*
timestamp PIN_FLD_CREATED_T created_t
timestamp PIN_FLD_MOD_T mod_t
string PIN_FLD_READ_ACCESS read_access
string PIN_FLD_WRITE_ACCESS wrtie_access
string PIN_FLD_CREATE_ACCESS create_access
poid PIN_FLD_ACCOUNT_OBJ account_obj*
int PIN_FLD_DURATION_SECONDS duration_seconds
timestamp PIN_FLD_END_T end_t
string PIN_FLD_NAME name
string PIN_FLD_HOSTNAME hostname
int PIN_FLD_PID pid
array PIN_FLD_RESULTS performance_results_t
string
PIN_FLD_FILENAME
filename
int
PIN_FLD_LINE_NUMBER
line_number
int
PIN_FLD_FLAGS
flags
string
PIN_FLD_FUNCTION
function
int
PIN_FLD_ITEM_LEVEL
item_level
int
PIN_FLD_PARENT_ELEMENT_ID
parent_element_id
string
PIN_FLD_PROGRAM_NAME
program_name
string
PIN_FLD_OBJECT_TYPE
object_type
decimal
PIN_FLD_CALLS
calls
decimal
PIN_FLD_TOTAL_ELAPSED
total_elapsed
decimal
PIN_FLD_MIN_ELAPSED
min_elapsed
decimal
PIN_FLD_MAX_ELAPSED
max_elapsed
decimal
PIN_FLD_RECORDS
records
decimal
PIN_FLD_CACHE_COUNT
cache_count
decimal
PIN_FLD_CACHE_ELAPSED
cache_elapsed
decimal
PIN_FLD_ERRORS
errors
int
PIN_FLD_BUCKET_ID
bucket_id
decimal
PIN_FLD_BUCKET_START
bucket_start
decimal
PIN_FLD_BUCKET_END
bucket_end
timestamp
PIN_FLD_EFFECTIVE_T
effective_t
decimal
PIN_FLD_USER_CPU_TIME
user_cpu_time
decimal
PIN_FLD_SYSTEM_CPU_TIME
system_cpu_time
timestamp PIN_FLD_START_T start_t
derived-class /performance_snapshot/realtime
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.


Field Index This Class