oracle

Documentation

Index

• func CountDiskgroups(condArr map[string]string) int64
• func CountOracle(condArr map[string]string) int64
• func CountTablespaces(condArr map[string]string) int64
• func GetProcessRateByDbId(db_id int) int64
• type Diskgroup
  • func ListDiskgroups(condArr map[string]string, page int, offset int) (num int64, err error, dgs []Diskgroup)
  • func (this *Diskgroup) TableName() string
• type Oracle
  • func ListOracleStatus(condArr map[string]string, page int, offset int) (num int64, err error, oracle []Oracle)
  • func (this *Oracle) TableName() string
• type Tablespace
  • func ListTablespaces(condArr map[string]string, page int, offset int) (num int64, err error, tbs []Tablespace)
  • func (this *Tablespace) TableName() string

Functions

func CountDiskgroups

func CountDiskgroups(condArr map[string]string) int64

func CountOracle

func CountOracle(condArr map[string]string) int64

统计数量

func CountTablespaces

func CountTablespaces(condArr map[string]string) int64

func GetProcessRateByDbId

func GetProcessRateByDbId(db_id int) int64

Types

type Diskgroup

type Diskgroup struct {
	Id             int    `orm:"pk;column(id);"`
	Db_Id          int    `orm:"column(db_id);"`
	Host           string `orm:"column(host);"`
	Port           string `orm:"column(port);"`
	Alias          string `orm:"column(alias);"`
	Diskgroup_Name string `orm:"column(diskgroup_name);"`
	State          string `orm:"column(state);"`
	Type           string `orm:"column(type);"`
	Total_Mb       string `orm:"column(total_mb);"`
	Free_Mb        string `orm:"column(free_mb);"`
	Used_Rate      string `orm:"column(used_rate);"`
	Created        int64  `orm:"column(created);"`
}

func ListDiskgroups

func ListDiskgroups(condArr map[string]string, page int, offset int) (num int64, err error, dgs []Diskgroup)

获取oracle磁盘组列表

func (*Diskgroup) TableName

func (this *Diskgroup) TableName() string

type Oracle

type Oracle struct {
	Id              int    `orm:"pk;column(id);"`
	Db_Id           int    `orm:"column(db_id);"`
	Host            string `orm:"column(host);"`
	Port            string `orm:"column(port);"`
	Alias           string `orm:"column(alias);"`
	Connect         int    `orm:"column(connect);"`
	Inst_Num        string `orm:"column(inst_num);"`
	Inst_Name       string `orm:"column(inst_name);"`
	Inst_Role       string `orm:"column(inst_role);"`
	Inst_Status     string `orm:"column(inst_status);"`
	Version         string `orm:"column(version);"`
	Startup_Time    string `orm:"column(startup_time);"`
	Host_Name       string `orm:"column(host_name);"`
	Archiver        string `orm:"column(archiver);"`
	Db_Name         string `orm:"column(db_name);"`
	Db_Role         string `orm:"column(db_role);"`
	Open_Mode       string `orm:"column(open_mode);"`
	Protection_Mode string `orm:"column(protection_mode);"`
	Session_Total   int    `orm:"column(session_total);"`
	Session_Actives int    `orm:"column(session_actives);"`
	Session_Waits   int    `orm:"column(session_waits);"`
	Dg_Stats        string `orm:"column(dg_stats);"`
	Dg_Delay        int    `orm:"column(dg_delay);"`
	Processes       int    `orm:"column(processes);"`
	Flashback_On    string `orm:"column(flashback_on);"`
	Flashback_Usage string `orm:"column(flashback_usage);"`
	Created         int64  `orm:"column(created);"`
}

func ListOracleStatus

func ListOracleStatus(condArr map[string]string, page int, offset int) (num int64, err error, oracle []Oracle)

获取oracle状态列表

func (*Oracle) TableName

func (this *Oracle) TableName() string

type Tablespace

type Tablespace struct {
	Id              int    `orm:"pk;column(id);"`
	Db_Id           int    `orm:"column(db_id);"`
	Host            string `orm:"column(host);"`
	Port            string `orm:"column(port);"`
	Alias           string `orm:"column(alias);"`
	Tablespace_Name string `orm:"column(tablespace_name);"`
	Status          string `orm:"column(status);"`
	Management      string `orm:"column(management);"`
	Total_Size      string `orm:"column(total_size);"`
	Used_Size       string `orm:"column(used_size);"`
	Max_Rate        string `orm:"column(max_rate);"`
	Created         int64  `orm:"column(created);"`
}

func ListTablespaces

func ListTablespaces(condArr map[string]string, page int, offset int) (num int64, err error, tbs []Tablespace)

获取oracle表空间列表

func (*Tablespace) TableName

func (this *Tablespace) TableName() string