选择查询中的PL / SQL存储错误(PL/SQL Storage error in Select Query)

 根据您尝试使用Measure-VM，我假设您使用的是Hyper-V。 我在我的一个Hyper-V脚本中使用类似的东西： 
 
(Get-VM dechiro1).HardDrives | ForEach {
    $GetVhd = Get-VHD -Path $_.Path
    [pscustomobject]@{
        Name = $_.Name
        Type = $GetVhd.VhdType
        ProvisionedGB = ($GetVhd.Size / 1GB)
        CommittedGB = ($GetVhd.FileSize / 1GB)
    }
}
 
 基本上，对于每个虚拟机的硬盘驱动器，使用Get-VHD获取VHD详细信息，其中包括完整大小和我所称的承诺大小（磁盘上的实际空间）。 
 
 示例输出： 
 
Name                                                   Type                 ProvisionedGB                   CommittedGB
----                                                   ----                 -------------                   -----------
Hard Drive on IDE controll...                       Dynamic                            20                    0.00390625
Hard Drive on IDE controll...                       Dynamic                            40                    0.00390625
 
 编辑 ： 
 
 如果您想从每个VM中提取并将VM名称包含在返回的对象中，并且您更喜欢使用管道表单，则可以使用： 
 
Get-VM | ForEach { $Vm = $_; $_.HardDrives } | ForEach {
    $GetVhd = Get-VHD -Path $_.Path
    [pscustomobject]@{
        Vm = $Vm.Name
        Name = $_.Name
        Type = $GetVhd.VhdType
        ProvisionedGB = ($GetVhd.Size / 1GB)
        CommittedGB = ($GetVhd.FileSize / 1GB)
    }
}

Based on your attempt to use Measure-VM, I assumed you are using Hyper-V. I use something similar to this in one of my Hyper-V scripts:
 
(Get-VM dechiro1).HardDrives | ForEach {
    $GetVhd = Get-VHD -Path $_.Path
    [pscustomobject]@{
        Name = $_.Name
        Type = $GetVhd.VhdType
        ProvisionedGB = ($GetVhd.Size / 1GB)
        CommittedGB = ($GetVhd.FileSize / 1GB)
    }
}
 
Basically, for each of the virtual machine's hard drives, use Get-VHD to get the VHD details which includes the full size and what I refer to as the committed size (actual space on disk).
 
Example output:
 
Name                                                   Type                 ProvisionedGB                   CommittedGB
----                                                   ----                 -------------                   -----------
Hard Drive on IDE controll...                       Dynamic                            20                    0.00390625
Hard Drive on IDE controll...                       Dynamic                            40                    0.00390625
 
Edit:
 
If you wanted to pull from every VM and include the VM name with the returned object and you prefer to use the pipeline form, this will work:
 
Get-VM | ForEach { $Vm = $_; $_.HardDrives } | ForEach {
    $GetVhd = Get-VHD -Path $_.Path
    [pscustomobject]@{
        Vm = $Vm.Name
        Name = $_.Name
        Type = $GetVhd.VhdType
        ProvisionedGB = ($GetVhd.Size / 1GB)
        CommittedGB = ($GetVhd.FileSize / 1GB)
    }
}