netflow数据

Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as admin

SQL> select * from tabs;

TABLE_NAME TABLESPACE_NAME CLUSTER_NAME IOT_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING BACKED_UP NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE INSTANCES CACHE TABLE_LOCK SAMPLE_SIZE LAST_ANALYZED PARTITIONED IOT_TYPE TEMPORARY SECONDARY NESTED BUFFER_POOL ROW_MOVEMENT GLOBAL_STATS USER_STATS DURATION SKIP_CORRUPT MONITORING CLUSTER_OWNER DEPENDENCIES
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------------- ------- --------- ---------- ---------- ------------ ---------- ---------- ----------- ------------------------- ------------------- -------------------- -------------------- ---------- ---------- ----------- ------------- ----------- ------------ --------- --------- ------ ----------- ------------ ------------ ---------- --------------- ------------ ---------- ------------------------------ ------------
APP NETFLOW_DATA 10 40 1 255 65536 1 2147483645 1 1 YES N 1 1 N ENABLED NO N N NO DEFAULT DISABLED NO NO DISABLED NO DISABLED
DEVICE NETFLOW_DATA 10 40 1 255 65536 1 2147483645 1 1 YES N 1 1 N ENABLED NO N N NO DEFAULT DISABLED NO NO DISABLED NO DISABLED
DEVICEGROUP NETFLOW_DATA 10 40 1 255 65536 1 2147483645

1 1 YES N 1 1 N ENABLED NO N N NO DEFAULT DISABLED NO NO DISABLED NO DISABLED
DEVICEIF NETFLOW_DATA 10 40 1 255 65536 1 2147483645 1 1 YES N 1 1 N ENABLED NO N N NO DEFAULT DISABLED NO NO DISABLED NO DISABLED
NETFLOW NETFLOW_DATA 10 40 1 255 65536 1 2147483645 1 1 YES N 1 1 N ENABLED NO N N NO DEFAULT DISABLED NO NO DISABLED NO DISABLED

SQL> desc device;
Name Type Nullable Default Comments
-------- ------------ -------- ------- --------
DGID NUMBER(11)
DNAME VARCHAR2(20) Y
IP VARCHAR2(15) Y
USED NUMBER(1) Y
DID NUMBER(11) Y
DEVICEID NUMBER(11) Y

SQL> select * from device;

DGID DNAME IP USED DID DEVICEID
------------ -------------------- --------------- ---- ------------ ------------
1 central 192.168.0.1 1 1
2 cisco 192.168.1.110 1 1

SQL> desc devicegroup;
Name Type Nullable Default Comments
------ ------------- -------- ------- --------
DGID NUMBER(10)
DGNAME VARCHAR2(20)
BAK VARCHAR2(100) Y

SQL> select * from devicegroup;

DGID DGNAME BAK
----------- -------------------- -----------------------------------------------------------------

---------------
1 长沙创思 长沙创思

SQL> desc deviceif;
Name Type Nullable Default Comments
----------- ------------ -------- ------- --------
DFID NUMBER(5)
DID NUMBER(11) Y
DFNAME VARCHAR2(20) Y
MFLAG NUMBER(1) Y
MAX_TRAFFIC NUMBER(11) Y

SQL> select * from deviceif;

DFID DID DFNAME MFLAG MAX_TRAFFIC
------ ------------ -------------------- ----- ------------
1 1 ifindex1 1 300000000
2 1 ifindex2 1 300000000
3 1 ifindex3 1 300000000
4 1 ifindex4 1 300000000

SQL> desc netflow;
Name Type Nullable Default Comments
-------- ------------ -------- ------- --------
ROUTERIP VARCHAR2(20) Y
TIMEMARK VARCHAR2(25) Y
SRCIP VARCHAR2(20) Y
DESTIP VARCHAR2(20) Y
OCTETS NUMBER(12) Y
PKGS NUMBER(12) Y
SRCPORT NUMBER(12) Y
DESTPORT NUMBER(12) Y
INIF VARCHAR2(20) Y
OUTIF VARCHAR2(20) Y
PROT VARCHAR2(6) Y

SQL>