< Back

Get-OracleADDMReport

Thu Jan 16, 2020 8:28 am

NAME Get-OracleADDMReport



SYNOPSIS

This function generates ADDM Report for single instance and cluster databases





SYNTAX

Get-OracleADDMReport -TargetDB <String> [-DBUser <String>] [-PasswordPrompt] [-Instances <String[]>] [-DBID

<BigInteger>] -StartTime <DateTime> -EndTime <DateTime> [-ErrorLog] [-ErrorLogFile <String>] [<CommonParameters>]



Get-OracleADDMReport -TargetDB <String> [-DBUser <String>] [-PasswordPrompt] [-Instances <String[]>] [-DBID

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

[<CommonParameters>]





DESCRIPTION

This function generates ADDM Report for single instance and cluster databases





PARAMETERS

-TargetDB <String>

Target Database



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



-Instances <String[]>

Target Database



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-DBID <BigInteger>

This is the DBID of the target database



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















RELATED LINKS