< Back
Get-OracleADDMReport
Post
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
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