[dbo].[dbh_sql

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:12:37 AM Wednesday, March 07, 2007
Last Modified	2:23:32 PM Friday, March 21, 2008

	Name	Data Type	Max Length (Bytes)	Identity
	sql_id	decimal(8,0)	5	1 - 1
$Indexes dbh_sql_ora_snapshot_ts_idx: capture_id\snapshot_timestamp$	capture_id	decimal(8,0)	5
$Indexes dbh_sql_ora_snapshot_ts_idx: capture_id\snapshot_timestamp$ $Indexes dbh_sql_ora_inst_snapts_idx: var1\var2\snapshot_timestamp$	snapshot_timestamp	datetime	8
	sql_owner	varchar(30)	30
	sql_parser	varchar(30)	30
	appl_name	varchar(256)	256
	os_user	varchar(256)	256
	option_defer_parse	char(1)	1
	option_describes_y_n	char(1)	1
	option_combine_fetch	char(1)	1
	option_min_sorting	char(1)	1
	option_array_size	decimal(12,0)	9
	option_n_fetches	decimal(12,0)	9
	option_long_piece_size	decimal(12,0)	9
	option_n_long_peices	decimal(12,0)	9
	option_roll_segment	varchar(30)	30
	bind_carnality	decimal(12,0)	9
	prod_plan	varchar(1)	1
	do_elapsed_time_last	decimal(12,0)	9
	do_total_cpu_last	decimal(16,6)	9
	do_db_calls	decimal(12,0)	9
	row_num_limit	decimal(12,0)	9
	sql_type	varchar(1)	1
	c_sharable_mem	decimal(12,0)	9
	c_sorts	decimal(12,0)	9
	c_loaded_versions	decimal(12,0)	9
	c_executions	decimal(12,0)	9
	c_parse_calls	decimal(12,0)	9
	c_disk_reads	decimal(12,0)	9
	c_buffer_gets	decimal(12,0)	9
	c_users_opening	decimal(12,0)	9
	c_first_load_time	datetime	8
	c_last_load_time	datetime	8
	c_rows_processed	decimal(12,0)	9
	c_cpu_time	decimal(16,6)	9
	c_elapsed_time	decimal(12,0)	9
	c_log_write	decimal(12,0)	9
	c_log_io	decimal(12,0)	9
	c_optimizer_mode	varchar(30)	30
	aud_sid	decimal(12,0)	9
	sid	decimal(12,0)	9
	serial_num	decimal(12,0)	9
	sql_address	varchar(50)	50
	sql_hash_value	decimal(12,0)	9
	child_number	decimal(12,0)	9
	diff_log_read	decimal(12,0)	9
	diff_log_write	decimal(12,0)	9
	diff_phy_read	decimal(12,0)	9
	diff_io	decimal(12,0)	9
	diff_cpu	decimal(16,6)	9
	stmt_text	text	max
	tag	varchar(50)	50
	folder	varchar(50)	50
	description	varchar(2000)	2000
	plan_owner	varchar(30)	30
	db_connect_string	varchar(400)	400
	db_name	varchar(50)	50
	db_version	varchar(30)	30
	create_date	datetime	8
	verify_date	datetime	8
	start_capture_time	datetime	8
	end_capture_time	datetime	8
	capture_interval	decimal(12,2)	9
$Indexes dbh_sql_ora_inst_snapts_idx: var1\var2\snapshot_timestamp$	var1	varchar(400)	400
$Indexes dbh_sql_ora_inst_snapts_idx: var1\var2\snapshot_timestamp$	var2	varchar(400)	400
	var3	varchar(400)	400
	var4	varchar(400)	400
	var5	varchar(400)	400
	text1	varchar(1)	1
	dec1	decimal(12,2)	9
	dec2	decimal(12,2)	9
	dec3	decimal(12,2)	9
	dec4	decimal(16,6)	9
	dec5	decimal(16,6)	9
	float1	float	8
	float2	float	8
	float3	float	8
	date1	datetime	8
	date2	datetime	8
	date3	datetime	8

	Name	Columns	Unique
	dbh_sql_ora_pk	sql_id
	dbh_sql_ora_inst_snapts_idx	var1, var2, snapshot_timestamp
	dbh_sql_ora_snapshot_ts_idx	capture_id, snapshot_timestamp

Name	Delete	Columns
dbh_sql_ora_capture_fk	Cascade	capture_id->[dbo].[dbh_captures].[capture_id]

Type	Action	Owning Principal
Grant	Delete	udmadmin_group
Grant	Insert	udmadmin_group
Grant	Select	udmadmin_group
Grant	Update	udmadmin_group

SQL Script

CREATE TABLE [dbo].[dbh_sql_ora]
(
[sql_id] [decimal] (8, 0) NOT NULL IDENTITY(1, 1),
[capture_id] [decimal] (8, 0) NULL,
[snapshot_timestamp] [datetime] NOT NULL,
[sql_owner] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_parser] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[appl_name] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[os_user] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[option_defer_parse] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[option_describes_y_n] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[option_combine_fetch] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[option_min_sorting] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[option_array_size] [decimal] (12, 0) NULL,
[option_n_fetches] [decimal] (12, 0) NULL,
[option_long_piece_size] [decimal] (12, 0) NULL,
[option_n_long_peices] [decimal] (12, 0) NULL,
[option_roll_segment] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[bind_carnality] [decimal] (12, 0) NULL,
[prod_plan] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[do_elapsed_time_last] [decimal] (12, 0) NULL,
[do_total_cpu_last] [decimal] (16, 6) NULL,
[do_db_calls] [decimal] (12, 0) NULL,
[row_num_limit] [decimal] (12, 0) NULL,
[sql_type] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[c_sharable_mem] [decimal] (12, 0) NULL,
[c_sorts] [decimal] (12, 0) NULL,
[c_loaded_versions] [decimal] (12, 0) NULL,
[c_executions] [decimal] (12, 0) NULL,
[c_parse_calls] [decimal] (12, 0) NULL,
[c_disk_reads] [decimal] (12, 0) NULL,
[c_buffer_gets] [decimal] (12, 0) NULL,
[c_users_opening] [decimal] (12, 0) NULL,
[c_first_load_time] [datetime] NULL,
[c_last_load_time] [datetime] NULL,
[c_rows_processed] [decimal] (12, 0) NULL,
[c_cpu_time] [decimal] (16, 6) NULL,
[c_elapsed_time] [decimal] (12, 0) NULL,
[c_log_write] [decimal] (12, 0) NULL,
[c_log_io] [decimal] (12, 0) NULL,
[c_optimizer_mode] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[aud_sid] [decimal] (12, 0) NULL,
[sid] [decimal] (12, 0) NULL,
[serial_num] [decimal] (12, 0) NULL,
[sql_address] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_hash_value] [decimal] (12, 0) NULL,
[child_number] [decimal] (12, 0) NULL,
[diff_log_read] [decimal] (12, 0) NULL,
[diff_log_write] [decimal] (12, 0) NULL,
[diff_phy_read] [decimal] (12, 0) NULL,
[diff_io] [decimal] (12, 0) NULL,
[diff_cpu] [decimal] (16, 6) NULL,
[stmt_text] [text] COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[tag] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[folder] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[plan_owner] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_connect_string] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_version] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[create_date] [datetime] NULL,
[verify_date] [datetime] NULL,
[start_capture_time] [datetime] NULL,
[end_capture_time] [datetime] NULL,
[capture_interval] [decimal] (12, 2) NULL,
[var1] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var2] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var3] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var4] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var5] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text1] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dec1] [decimal] (12, 2) NULL,
[dec2] [decimal] (12, 2) NULL,
[dec3] [decimal] (12, 2) NULL,
[dec4] [decimal] (16, 6) NULL,
[dec5] [decimal] (16, 6) NULL,
[float1] [float] NULL,
[float2] [float] NULL,
[float3] [float] NULL,
[date1] [datetime] NULL,
[date2] [datetime] NULL,
[date3] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_ora] ADD CONSTRAINT [dbh_sql_ora_pk] PRIMARY KEY CLUSTERED ([sql_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_sql_ora_snapshot_ts_idx] ON [dbo].[dbh_sql_ora] ([capture_id], [snapshot_timestamp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_sql_ora_inst_snapts_idx] ON [dbo].[dbh_sql_ora] ([var1], [var2], [snapshot_timestamp]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_ora] ADD CONSTRAINT [dbh_sql_ora_capture_fk] FOREIGN KEY ([capture_id]) REFERENCES [dbo].[dbh_captures] ([capture_id]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[dbh_sql_ora] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[dbh_sql_ora] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[dbh_sql_ora] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[dbh_sql_ora] TO [udmadmin_group]
GO