DBARefLib Functions

1. .SOUtilsAdvanced.lib:function SOgetConfModifyTime

2. .SOUtilsAdvanced.lib:function SOgetHbaModifyTime

3. .SOUtilsAdvanced.lib:function SOmailme

4. .SOUtilsBeta.lib:function SOavgLoadonServer

5. .SOUtilsBeta.lib:function SODiskandNetworkIOUsageLastHour

6. .SOUtilsBeta.lib:function SOgetBloatonTables

7. .SOUtilsBeta.lib:function SOgetCurrentDiskSpaceUsage

8. .SOUtilsBeta.lib:function SOgetDBActivity

9. .SOUtilsBeta.lib:function SOgetDBContention

10. .SOUtilsBeta.lib:function SOgetDBLocks

11. .SOUtilsBeta.lib:function SOgetDBLocksBlocker

12. .SOUtilsBeta.lib:function SOGetDbVersion

13. .SOUtilsBeta.lib:function SOgetLongRunningSQL30min

14. .SOUtilsBeta.lib:function SOgetProcessSpillGt50GB

15. .SOUtilsBeta.lib:function SOgetResQueueInfo

16. .SOUtilsBeta.lib:function SOgetSchemaDetails

17. .SOUtilsBeta.lib:function SOgetSchemaSpaceUsage

18. .SOUtilsBeta.lib:function SOgetSegmentServerDown

19. .SOUtilsBeta.lib:function SOgetTop50TablesbySize

20. .SOUtilsBeta.lib:function SOgetUserRQMap

21. .SOUtilsBeta.lib:function SOgetUsersWithLoginRole

22. .SOUtilsBeta.lib:function SOgetUsersWithNoLoginRole

23. .SOUtilsBeta.lib:function SOgetUsersWithSuperUserRole

24. .SOUtilsBeta.lib:function SOgetWaitingSQLCountbyDB

25. .SOUtilsBeta.lib:function SOhcgetUserOps

26. .SOUtilsBeta.lib:function SOListCatalogFunction

27. .SOUtilsBeta.lib:function SOlistCatalogTables

28. .SOUtilsBeta.lib:function SOlistCatalogViews

29. .SOUtilsBeta.lib:function SOlistToolkitViews

30. .SOUtilsBeta.lib:function SOshowAccesPrivonSchemaObjects

31. .SOUtilsBeta.lib:function SOShowALLRANDOMLYDistributedTable

32. .SOUtilsBeta.lib:function SOShowAllRecordedOpOnSpecifiedTablesandSpecifiedSchema

33. .SOUtilsBeta.lib:function SOshowAOTableinfo

34. .SOUtilsBeta.lib:function SOshowavgMemoryUsed

35. .SOUtilsBeta.lib:function SOshowBlockers

36. .SOUtilsBeta.lib:function SOshowCompressedTables

37. .SOUtilsBeta.lib:function SOshowConnectedUsers

38. .SOUtilsBeta.lib:function SOshowConnectionInfo

39. .SOUtilsBeta.lib:function SOshowCPUandMemUsageLastHour

40. .SOUtilsBeta.lib:function SOshowCPUSpikesMoreThan60PercentLastHour

41. .SOUtilsBeta.lib:function SOshowCRONDUMPHistory

42. .SOUtilsBeta.lib:function SOshowDBActivitySummary

43. .SOUtilsBeta.lib:function SOshowDBExternalTables

44. .SOUtilsBeta.lib:function SOShowDBFunction

45. .SOUtilsBeta.lib:function SOshowDBSequences

46. .SOUtilsBeta.lib:function SOshowDBTables

47. .SOUtilsBeta.lib:function SOshowDBUserdetails

48. .SOUtilsBeta.lib:function SOshowDBViews

49. .SOUtilsBeta.lib:function SOshowDiskFreeonSegmentHosts

50. .SOUtilsBeta.lib:function SOshowDiskSpaceNow

51. .SOUtilsBeta.lib:function SOshowDiskSpaceUsage7Days

52. .SOUtilsBeta.lib:function SOShowDistKeyofSpecifiedTablesInSpecifiedSchema

53. .SOUtilsBeta.lib:function SOshowDynamicMemoryUsageLastHour

54. .SOUtilsBeta.lib:function SOshowEMCConnectHistoryErrWarn

55. .SOUtilsBeta.lib:function SOshowGpDBsizes

56. .SOUtilsBeta.lib:function SOshowGPSegmentConfig

57. .SOUtilsBeta.lib:function SOshowHealthNow

58. .SOUtilsBeta.lib:function SOshowIdleConnections

59. .SOUtilsBeta.lib:function SOshowIdleLastHour

60. .SOUtilsBeta.lib:function SOshowIfUserTablesisLocked

61. .SOUtilsBeta.lib:function SOshowInformationSchemaViews

62. .SOUtilsBeta.lib:function SOShowLastAnalyzeMajorSchema

63. .SOUtilsBeta.lib:function SOshowLocksOnRelation

64. .SOUtilsBeta.lib:function SOshowLocksOnRQ

65. .SOUtilsBeta.lib:function SOshowLogAlertHistory

66. .SOUtilsBeta.lib:function SOshowLogAlertNow

67. .SOUtilsBeta.lib:function SOshowMasterDataDirLocation

68. .SOUtilsBeta.lib:function SOshowObjectCountbySchema

69. .SOUtilsBeta.lib:function SOshowObjectCountbySchemaObject

70. .SOUtilsBeta.lib:function SOshowOrhanLocks

71. .SOUtilsBeta.lib:function SOshowParameterSettings

72. .SOUtilsBeta.lib:function SOshowParameterSettings

73. .SOUtilsBeta.lib:function SOshowParameterSettings

74. .SOUtilsBeta.lib:function SOshowParameterSettings

75. .SOUtilsBeta.lib:function SOshowParameterSettings

76. .SOUtilsBeta.lib:function SOshowParameterSettings

77. .SOUtilsBeta.lib:function SOshowParameterSettingsbyCategory

78. .SOUtilsBeta.lib:function SOshowPartSubPartDetails

79. .SOUtilsBeta.lib:function SOshowPartSummary

80. .SOUtilsBeta.lib:function SOshowPartTables

81. .SOUtilsBeta.lib:function SOshowPGStat

82. .SOUtilsBeta.lib:function SOshowPgStatLastOperation

83. .SOUtilsBeta.lib:function SOShowQueriesbyRQname

84. .SOUtilsBeta.lib:function SOShowQueriesbyUsernameRunningMorethanNminutes

85. .SOUtilsBeta.lib:function SOshowQueriesNow

86. .SOUtilsBeta.lib:function SOShowQueriesSpillgtNgB

87. .SOUtilsBeta.lib:function SOShowQueriesWaitingNminutes

88. .SOUtilsBeta.lib:function SOshowQuriesbyUsers7Days

89. .SOUtilsBeta.lib:function SOshowRoleAssignedToUser

90. .SOUtilsBeta.lib:function SOshowRQactivities

91. .SOUtilsBeta.lib:function SOShowRQactivity

92. .SOUtilsBeta.lib:function SOShowRQactivitybyRQname

93. .SOUtilsBeta.lib:function SOshowRQStaus

94. .SOUtilsBeta.lib:function SOShowRunningQueriesCountbyRQname

95. .SOUtilsBeta.lib:function SOShowRunningQueriesCountbyRQnameandUser

96. .SOUtilsBeta.lib:function SOshowRunningSQL

97. .SOUtilsBeta.lib:function SOShowSchema

98. .SOUtilsBeta.lib:function SOshowSegmentNow

99. .SOUtilsBeta.lib:function SOshowSegmentsApprochingThreshold75percentlimit

100. .SOUtilsBeta.lib:function SOshowSegmentSkewSummary

101. .SOUtilsBeta.lib:function SOShowSessionperConnectedUser

102. .SOUtilsBeta.lib:function SOshowsizeOfPartitionAndIndexesDisk

103. .SOUtilsBeta.lib:function SOshowSizeofTableUncompressed

104. .SOUtilsBeta.lib:function SOshowSkewonTables

105. .SOUtilsBeta.lib:function SOShowSpecificTablesLastVacuumInSpecifiedSchema

106. .SOUtilsBeta.lib:function SOshowSQLRunningGt2hour

107. .SOUtilsBeta.lib:function SOshowSQLwaitingMoreThan30minAfterSubmission

108. .SOUtilsBeta.lib:function SOshowSubPartDetails

109. .SOUtilsBeta.lib:function SOshowSummaryTableDistPolicies

110. .SOUtilsBeta.lib:function SOshowSystemNow

111. .SOUtilsBeta.lib:function

SOShowTableCountNotAnalyzedNdaysbySchemaandTableName

112. .SOUtilsBeta.lib:function SOshowTableDistributionKeys

113. .SOUtilsBeta.lib:function SOshowTableGrantandPriv

114. .SOUtilsBeta.lib:function SOshowTableInfo

115. .SOUtilsBeta.lib:function SOshowTableNotAnalyzed30DaysSummary

116. .SOUtilsBeta.lib:function SOshowTableNotAnalyzed5DaysSummary

117. .SOUtilsBeta.lib:function SOShowTablesanditsSizeInSpecifiedSchema

118. .SOUtilsBeta.lib:function SOShowTablesandRelpageReltuplesandSizeInSpecifiedSchema

119. .SOUtilsBeta.lib:function SOShowTablesbyOwner

120. .SOUtilsBeta.lib:function SOShowTablesbySchemaAndStorageType

121. .SOUtilsBeta.lib:function SOShowTablesDistRANDOMLYinSpecifiedSchema

122. .SOUtilsBeta.lib:function SOshowTablesHavingIndex

123. .SOUtilsBeta.lib:function SOShowTablesInALLSchema

124. .SOUtilsBeta.lib:function SOShowTablesInSpecifiedSchema

125. .SOUtilsBeta.lib:function SOshowTableSkewSummary

126. .SOUtilsBeta.lib:function SOShowTablesLastAnalyzedInSpecifiedSchema

127. .SOUtilsBeta.lib:function SOShowTablesLastVacuumInSpecifiedSchema

128. .SOUtilsBeta.lib:function SOShowTablesLastVacuumInSpecifiedSchema

129. .SOUtilsBeta.lib:function SOShowTablesNotAnalyzedNdaysbySchemaandTableName

130. .SOUtilsBeta.lib:function SOShowTablesRelpageReltuplesInSpecifiedSchema

131. .SOUtilsBeta.lib:function SOshowTableswithMissingStats

132. .SOUtilsBeta.lib:function SOshowToastTablesWRTParentTable

133. .SOUtilsBeta.lib:function SOShowTodaysConnectionLogs

134. .SOUtilsBeta.lib:function SOshowtoolkitviews

135. .SOUtilsBeta.lib:function SOshowTop10DBTimebyUsers

136. .SOUtilsBeta.lib:function SOShowTotalWaitersbyDB

137. .SOUtilsBeta.lib:function SOshowUserInactive90Days

138. .SOUtilsBeta.lib:function SOshowWaiters

139. .SOUtilsBeta.lib:function SOshowWaitingSQL

140. .SOUtilsBeta.lib:function SOshowWhichCatalogTablesareLocked

141. .SOUtilsBeta.lib:function SOshowWorkFilePerQuery

142. .SOUtilsBeta.lib:function SOshowWorkFilePerSegment

143. .SOUtilsBeta.lib:function SOshowWorstSQL7Days

144. .SOUtilsBeta.lib:function SOTrackUsersfromQueriesHistory

145. .SOUtilsCommon.lib:function SOCatalogSchema

146. .SOUtilsCommon.lib:function SOchangeDb

147. .SOUtilsCommon.lib:function SOconninfo

148. .SOUtilsCommon.lib:function SOcreateWorkDir

149. .SOUtilsCommon.lib:function SOGeneratetablelist

150. .SOUtilsCommon.lib:function SOGeneratetableList

151. .SOUtilsCommon.lib:function SOgetDbConfig

152. .SOUtilsCommon.lib:function SOgetSegHostConfig

153. .SOUtilsCommon.lib:function SOgetSegsNotInPreferredRole

154. .SOUtilsCommon.lib:function SOreadSchema

155. .SOUtilsCommon.lib:function SOreadTable

156. .SOUtilsCommon.lib:function SOschemasize

157. .SOUtilsCommon.lib:function SOshowDefdbFunction

158. .SOUtilsCommon.lib:function SOshowDefdbTableandViews

159. .SOUtilsCommon.lib:function SOtblCount

160. .SOUtilsCommon.lib:function SOtbllastanalyze

161. .SOUtilsCommon.lib:function SOtblsize

162. .SOUtilsPremium.lib:function SOchktblALL

163. .SOUtilsPremium.lib:function SOCopyPerfDatafromandtodate

164. .SOUtilsPremium.lib:function SOCopyPerfDatafromandtodateForSpecifiedUser

165. .SOUtilsPremium.lib:function SOCopyPerfDatapastNdays

166. .SOUtilsPremium.lib:function SOCopyPerfDatapastNdaysForSpecifiedUser

167. .SOUtilsPremium.lib:function SOCopyPerfDataQueriesHistoryfromandtodate

168. .SOUtilsPremium.lib:function

SOCopyPerfDataQueriesHistoryfromandtodateforSpecifiedaccount

169. .SOUtilsPremium.lib:function SOCopyPerfDataQueriesHistorypastNdays

170. .SOUtilsPremium.lib:function

SOCopyPerfDataQueriesHistorypastNdaysforSpecifiedaccount

171. .SOUtilsPremium.lib:function SOCopyPerfDataSystemHistoryfromandtodate

172. .SOUtilsPremium.lib:function SOCopyPerfDataSystemHistorypastNdays

173. .SOUtilsPremium.lib:function SOdatabaseObjectSearch

174. .SOUtilsPremium.lib:function SOgetALLOperationsReport

175. .SOUtilsPremium.lib:function SOgetOperationsReport

176. .SOUtilsPremium.lib:function SOgetTableOperationsReport

177. .SOUtilsPremium.lib:function SOgetXIDAgeInfo

178. .SOUtilsPremium.lib:function SOPshowObjectType

179. .SOUtilsPremium.lib:function SOPshowTableCompressPct

180. .SOUtilsPremium.lib:function SOPshowTableIndexDiskSizes

181. .SOUtilsPremium.lib:function SOPshowTblTypes

Comments