Get-OraclePerfReports

NAME Get-OraclePerfReports



SYNOPSIS

Generate AWR and/or ADDM report sets from an oracle database





SYNTAX

Get-OraclePerfReports [-TargetDB] <String> [[-DBUser] <String>] [-PasswordPrompt] [-StartTime] <DateTime>

[-EndTime] <DateTime> [-ADDM] [-AWR] [-Compress] [-SendMail] [[-EmailAddress] <String[]>] [-ErrorLog]

[[-ErrorLogFile] <String>] [-WhatIf] [-Confirm] [<CommonParameters>]





DESCRIPTION

This function defines the required variables to generate automatically AWR and ADDM report sets.





PARAMETERS

-TargetDB <String>

This can be a list of databases



Required? true

Position? 1

Default value

Accept pipeline input? true (ByValue, ByPropertyName)

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



-StartTime <DateTime>

This is the starting time for the performance snapshot



Required? true

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-EndTime <DateTime>

This is the ending time for the performance snapshot



Required? true

Position? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ADDM [<SwitchParameter>]

Switch to turn on ADDM report package



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-AWR [<SwitchParameter>]

Switch to turn on AWR report package



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Compress [<SwitchParameter>]

Switch to create compressed report sets



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-SendMail [<SwitchParameter>]

Switch to send email report sets



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-EmailAddress <String[]>



Required? false

Position? 5

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? 6

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

Accept pipeline input? false

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Confirm [<SwitchParameter>]



Required? false

Position? named

Default value

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-OraclePerfReports [-AWR] [-ADDM] -TargetDB myorcl -StartTime '2018-01-21 08:00:00 -5' -EndTime

'2018-01-21 17:00:00 -5'















RELATED LINKS