public static DescribeOasTopSQLListResponse Unmarshall()

in aliyun-net-sdk-oceanbasepro/OceanBasePro/Transform/V20190901/DescribeOasTopSQLListResponseUnmarshaller.cs [29:211]
177 lines of code
3 McCabe index (conditional complexity)

        public static DescribeOasTopSQLListResponse Unmarshall(UnmarshallerContext _ctx)
        {
			DescribeOasTopSQLListResponse describeOasTopSQLListResponse = new DescribeOasTopSQLListResponse();

			describeOasTopSQLListResponse.HttpResponse = _ctx.HttpResponse;
			describeOasTopSQLListResponse.RequestId = _ctx.StringValue("DescribeOasTopSQLList.RequestId");

			List<DescribeOasTopSQLListResponse.DescribeOasTopSQLList_DataItem> describeOasTopSQLListResponse_data = new List<DescribeOasTopSQLListResponse.DescribeOasTopSQLList_DataItem>();
			for (int i = 0; i < _ctx.Length("DescribeOasTopSQLList.Data.Length"); i++) {
				DescribeOasTopSQLListResponse.DescribeOasTopSQLList_DataItem dataItem = new DescribeOasTopSQLListResponse.DescribeOasTopSQLList_DataItem();
				dataItem.Executions = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].Executions");
				dataItem.RpcCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].RpcCount");
				dataItem.RemotePlans = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].RemotePlans");
				dataItem.MissPlans = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MissPlans");
				dataItem.MaxElapsedTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxElapsedTime");
				dataItem.TotalWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].TotalWaitTime");
				dataItem.ExecPs = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].ExecPs");
				dataItem.MaxCpuTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxCpuTime");
				dataItem.CpuPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].CpuPercentage");
				dataItem.ClientIp = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].ClientIp");
				dataItem.UserName = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].UserName");
				dataItem.DbName = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].DbName");
				dataItem.RetCode4012Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].RetCode4012Count");
				dataItem.RetCode4013Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].RetCode4013Count");
				dataItem.RetCode5001Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].RetCode5001Count");
				dataItem.RetCode5024Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].RetCode5024Count");
				dataItem.RetCode5167Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].RetCode5167Count");
				dataItem.RetCode5217Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].RetCode5217Count");
				dataItem.RetCode6002Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].RetCode6002Count");
				dataItem.FailPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].FailPercentage");
				dataItem.SumWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SumWaitTime");
				dataItem.AvgWaitCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgWaitCount");
				dataItem.AvgRpcCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgRpcCount");
				dataItem.LocalPlanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].LocalPlanPercentage");
				dataItem.RemotePlanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].RemotePlanPercentage");
				dataItem.DistPlanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].DistPlanPercentage");
				dataItem.SumElapsedTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SumElapsedTime");
				dataItem.AvgNetTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgNetTime");
				dataItem.AvgExecutorRpcCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgExecutorRpcCount");
				dataItem.MissPlanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MissPlanPercentage");
				dataItem.TableScanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].TableScanPercentage");
				dataItem.StrongConsistencyPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].StrongConsistencyPercentage");
				dataItem.WeakConsistencyPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].WeakConsistencyPercentage");
				dataItem.MaxAffectedRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxAffectedRows");
				dataItem.MaxReturnRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxReturnRows");
				dataItem.MaxWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxWaitTime");
				dataItem.MaxApplicationWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxApplicationWaitTime");
				dataItem.MaxConcurrencyWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxConcurrencyWaitTime");
				dataItem.MaxUserIoWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxUserIoWaitTime");
				dataItem.MaxDiskReads = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].MaxDiskReads");
				dataItem.AvgExpectedWorkerCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgExpectedWorkerCount");
				dataItem.AvgUsedWorkerCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgUsedWorkerCount");
				dataItem.SumLogicalReads = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SumLogicalReads");
				dataItem.Server = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].Server");
				dataItem.ServerIp = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].ServerIp");
				dataItem.ServerPort = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].ServerPort");
				dataItem.SqlTextShort = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlTextShort");
				dataItem.SqlType = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlType");
				dataItem.SqlId = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlId");
				dataItem.Inner = _ctx.BooleanValue("DescribeOasTopSQLList.Data["+ i +"].Inner");
				dataItem.WaitEvent = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].WaitEvent");
				dataItem.AvgAffectedRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgAffectedRows");
				dataItem.AvgReturnRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgReturnRows");
				dataItem.AvgPartitionCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgPartitionCount");
				dataItem.FailCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].FailCount");
				dataItem.AvgWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgWaitTime");
				dataItem.AvgElapsedTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgElapsedTime");
				dataItem.AvgCpuTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgCpuTime");
				dataItem.AvgNetWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgNetWaitTime");
				dataItem.AvgQueueTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgQueueTime");
				dataItem.AvgDecodeTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgDecodeTime");
				dataItem.AvgGetPlanTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgGetPlanTime");
				dataItem.AvgExecuteTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgExecuteTime");
				dataItem.AvgApplicationWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgApplicationWaitTime");
				dataItem.AvgConcurrencyWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgConcurrencyWaitTime");
				dataItem.AvgUserIoWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgUserIoWaitTime");
				dataItem.AvgScheduleTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgScheduleTime");
				dataItem.AvgRowCacheHit = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgRowCacheHit");
				dataItem.AvgBloomFilterCacheHit = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgBloomFilterCacheHit");
				dataItem.AvgBlockCacheHit = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgBlockCacheHit");
				dataItem.AvgBlockIndexCacheHit = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgBlockIndexCacheHit");
				dataItem.AvgDiskReads = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgDiskReads");
				dataItem.RetryCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].RetryCount");
				dataItem.AvgMemstoreReadRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgMemstoreReadRows");
				dataItem.AvgSsstoreReadRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgSsstoreReadRows");
				dataItem.AvgLogicalReads = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgLogicalReads");
				dataItem.DynamicSql = _ctx.BooleanValue("DescribeOasTopSQLList.Data["+ i +"].DynamicSql");
				dataItem.LastFailCode = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].LastFailCode");
				dataItem.AvgDbTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].AvgDbTime");
				dataItem.SumDbTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SumDbTime");

				List<DescribeOasTopSQLListResponse.DescribeOasTopSQLList_DataItem.DescribeOasTopSQLList_SqlListItem> dataItem_sqlList = new List<DescribeOasTopSQLListResponse.DescribeOasTopSQLList_DataItem.DescribeOasTopSQLList_SqlListItem>();
				for (int j = 0; j < _ctx.Length("DescribeOasTopSQLList.Data["+ i +"].SqlList.Length"); j++) {
					DescribeOasTopSQLListResponse.DescribeOasTopSQLList_DataItem.DescribeOasTopSQLList_SqlListItem sqlListItem = new DescribeOasTopSQLListResponse.DescribeOasTopSQLList_DataItem.DescribeOasTopSQLList_SqlListItem();
					sqlListItem.Executions = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].Executions");
					sqlListItem.RpcCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RpcCount");
					sqlListItem.RemotePlans = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RemotePlans");
					sqlListItem.MissPlans = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MissPlans");
					sqlListItem.MaxElapsedTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxElapsedTime");
					sqlListItem.TotalWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].TotalWaitTime");
					sqlListItem.ExecPs = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].ExecPs");
					sqlListItem.MaxCpuTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxCpuTime");
					sqlListItem.CpuPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].CpuPercentage");
					sqlListItem.ClientIp = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].ClientIp");
					sqlListItem.UserName = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].UserName");
					sqlListItem.DbName = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].DbName");
					sqlListItem.RetCode4012Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RetCode4012Count");
					sqlListItem.RetCode4013Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RetCode4013Count");
					sqlListItem.RetCode5001Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RetCode5001Count");
					sqlListItem.RetCode5024Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RetCode5024Count");
					sqlListItem.RetCode5167Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RetCode5167Count");
					sqlListItem.RetCode5217Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RetCode5217Count");
					sqlListItem.RetCode6002Count = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RetCode6002Count");
					sqlListItem.FailPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].FailPercentage");
					sqlListItem.SumWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].SumWaitTime");
					sqlListItem.AvgWaitCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgWaitCount");
					sqlListItem.AvgRpcCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgRpcCount");
					sqlListItem.LocalPlanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].LocalPlanPercentage");
					sqlListItem.RemotePlanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RemotePlanPercentage");
					sqlListItem.DistPlanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].DistPlanPercentage");
					sqlListItem.SumElapsedTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].SumElapsedTime");
					sqlListItem.AvgNetTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgNetTime");
					sqlListItem.AvgExecutorRpcCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgExecutorRpcCount");
					sqlListItem.MissPlanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MissPlanPercentage");
					sqlListItem.TableScanPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].TableScanPercentage");
					sqlListItem.StrongConsistencyPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].StrongConsistencyPercentage");
					sqlListItem.WeakConsistencyPercentage = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].WeakConsistencyPercentage");
					sqlListItem.MaxAffectedRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxAffectedRows");
					sqlListItem.MaxReturnRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxReturnRows");
					sqlListItem.MaxWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxWaitTime");
					sqlListItem.MaxApplicationWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxApplicationWaitTime");
					sqlListItem.MaxConcurrencyWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxConcurrencyWaitTime");
					sqlListItem.MaxUserIoWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxUserIoWaitTime");
					sqlListItem.MaxDiskReads = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].MaxDiskReads");
					sqlListItem.AvgExpectedWorkerCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgExpectedWorkerCount");
					sqlListItem.AvgUsedWorkerCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgUsedWorkerCount");
					sqlListItem.SumLogicalReads = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].SumLogicalReads");
					sqlListItem.Server = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].Server");
					sqlListItem.ServerIp = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].ServerIp");
					sqlListItem.ServerPort = _ctx.LongValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].ServerPort");
					sqlListItem.SqlTextShort = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].SqlTextShort");
					sqlListItem.SqlType = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].SqlType");
					sqlListItem.SqlId = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].SqlId");
					sqlListItem.Inner = _ctx.BooleanValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].Inner");
					sqlListItem.WaitEvent = _ctx.StringValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].WaitEvent");
					sqlListItem.AvgAffectedRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgAffectedRows");
					sqlListItem.AvgReturnRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgReturnRows");
					sqlListItem.AvgPartitionCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgPartitionCount");
					sqlListItem.FailCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].FailCount");
					sqlListItem.AvgWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgWaitTime");
					sqlListItem.AvgElapsedTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgElapsedTime");
					sqlListItem.AvgCpuTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgCpuTime");
					sqlListItem.AvgNetWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgNetWaitTime");
					sqlListItem.AvgQueueTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgQueueTime");
					sqlListItem.AvgDecodeTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgDecodeTime");
					sqlListItem.AvgGetPlanTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgGetPlanTime");
					sqlListItem.AvgExecuteTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgExecuteTime");
					sqlListItem.AvgApplicationWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgApplicationWaitTime");
					sqlListItem.AvgConcurrencyWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgConcurrencyWaitTime");
					sqlListItem.AvgUserIoWaitTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgUserIoWaitTime");
					sqlListItem.AvgScheduleTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgScheduleTime");
					sqlListItem.AvgRowCacheHit = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgRowCacheHit");
					sqlListItem.AvgBloomFilterCacheHit = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgBloomFilterCacheHit");
					sqlListItem.AvgBlockCacheHit = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgBlockCacheHit");
					sqlListItem.AvgBlockIndexCacheHit = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgBlockIndexCacheHit");
					sqlListItem.AvgDiskReads = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgDiskReads");
					sqlListItem.RetryCount = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].RetryCount");
					sqlListItem.AvgMemstoreReadRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgMemstoreReadRows");
					sqlListItem.AvgSsstoreReadRows = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgSsstoreReadRows");
					sqlListItem.AvgLogicalReads = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgLogicalReads");
					sqlListItem.AvgDbTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].AvgDbTime");
					sqlListItem.SumDbTime = _ctx.DoubleValue("DescribeOasTopSQLList.Data["+ i +"].SqlList["+ j +"].SumDbTime");

					dataItem_sqlList.Add(sqlListItem);
				}
				dataItem.SqlList = dataItem_sqlList;

				describeOasTopSQLListResponse_data.Add(dataItem);
			}
			describeOasTopSQLListResponse.Data = describeOasTopSQLListResponse_data;
        
			return describeOasTopSQLListResponse;
        }