Get-OracleAWRReport

NAME Get-OracleAWRReport



SYNOPSIS

This function generates AWR Report for single instance and cluster databases





SYNTAX

Get-OracleAWRReport -TargetDB <String> [-DBUser <String>] [-PasswordPrompt] [-DBID <BigInteger>] [-Global]

[-Instance <String>] -StartTime <DateTime> -EndTime <DateTime> [-ErrorLog] [-ErrorLogFile <String>]

[<CommonParameters>]



Get-OracleAWRReport -TargetDB <String> [-DBUser <String>] [-PasswordPrompt] [-DBID <BigInteger>] [-Global]

[-Instance <String>] -StartSnapshot <BigInteger> -EndSnapshot <BigInteger> [-ErrorLog] [-ErrorLogFile <String>]

[<CommonParameters>]





DESCRIPTION

This function generates AWR Report for single instance and cluster databases





PARAMETERS

-TargetDB <String>

This can be a list of databases



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-DBUser <String>

Username if required



Required? false

Position? named

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



-DBID <BigInteger>

This can be a list of databases



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Global [<SwitchParameter>]

Global flag



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Instance <String>

Instance name



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-StartTime <DateTime>

This is the starting time for the performance snapshot



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-EndTime <DateTime>

This is the ending time for the performance snapshot



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-StartSnapshot <BigInteger>

This is the starting snapshot for the Report scope



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-EndSnapshot <BigInteger>

This is the ending snapshot for the Report scope



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ErrorLog [<SwitchParameter>]

Switch to turn on the error logging



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-ErrorLogFile <String>



Required? false

Position? named

Default value "$env:TEMP\\OracleUtils_Errors_$PID.log"

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-OracleAWRReport -TargetDB myorcl -StartTime '2018-01-21 08:00:00 -5' -EndTime '2018-01-21 17:00:00 -5'















RELATED LINKS