< Back

Get-OracleSize

Thu Jan 16, 2020 8:35 am

NAME Get-OracleSize



SYNOPSIS

Returns the Size an Oracle DB, Tablespace or Tables, based on the paramaters passed





SYNTAX

Get-OracleSize [-TargetDB] <String[]> [[-DBUser] <String>] [-PasswordPrompt] [-SizeType] <String> [[-Unit]

<String>] [<CommonParameters>]





DESCRIPTION

This function returns the size of an Oracle DB or some of its components





PARAMETERS

-TargetDB <String[]>

It can check several databases at once



Required? true

Position? 1

Default value

Accept pipeline input? true (ByValue)

Accept wildcard characters? false



-DBUser <String>

Username if required



Required? false

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-PasswordPrompt [<SwitchParameter>]

Flag to ask for a password



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-SizeType <String>

Size types



Required? true

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Unit <String>



Required? false

Position? 4

Default value B

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Get-OracleSize -TargetDB myorcl -SizeType Full -Unit GB















RELATED LINKS