RE: Sizing Oracle db for Netview

["Chan, Jack" <jack.chan@nz.unisys.com>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

 
Hi,
 
I turned some snmp collecting for routers on, and a lot of data was inputed
into Oracle. So what our dba did was having a sliding window in the database
table COL_Data to keep a months of data for reporting.
 
If you are collecting snmp, the flat files which get transferred to
relational database are under /usr/OV/database/snmpCollect, all the files
without "!" at the end. The files with "!" at the end are readable.
 
hope it helps.
 
Jack Chan

-----Original Message-----
From: John Mackney [mailto:john.mackney@uk.logical.com]
Sent: Wednesday, 30 May 2001 10:55 p.m.
To: Netview Support list (E-mail)
Subject: [NV-L] Sizing Oracle db for Netview



I want to use Oracle to hold my NetView data, but I don't know how to size
it. 

Are there any rules to determine the sizes of the database instance to
create. For example, can I relate my oracle instance to the size of my
current NetView database? 

Which is my current database? There are a number of files in
/usr/OV/databases. What files are used for what?

Can anyone guide me?

John Mackney

Technical Design Authority

Logical eBOC

Logical (UK) Ltd.

Email:      john.mackney@uk.logical.com

 

Hi,

 

I turned some snmp collecting for routers on, and a lot of data was inputed into Oracle. So what our dba did was having a sliding window in the database table COL_Data to keep a months of data for reporting.

 

If you are collecting snmp, the flat files which get transferred to relational database are under /usr/OV/database/snmpCollect, all the files without "!" at the end. The files with "!" at the end are readable.

 

hope it helps.

 

Jack Chan

-----Original Message-----
From: John Mackney [mailto:john.mackney@uk.logical.com]
Sent: Wednesday, 30 May 2001 10:55 p.m.
To: Netview Support list (E-mail)
Subject: [NV-L] Sizing Oracle db for Netview

I want to use Oracle to hold my NetView data, but I don't know how to size it.

Are there any rules to determine the sizes of the database instance to create. For example, can I relate my oracle instance to the size of my current NetView database?

Which is my current database? There are a number of files in /usr/OV/databases. What files are used for what?

Can anyone guide me?

John Mackney

Technical Design Authority

Logical eBOC

Logical (UK) Ltd.

Email:      john.mackney@uk.logical.com