This command lists the latest versions of all plans.
Table 10–5 Arguments and Result for the pdb.p.la Command|
Argument/Result |
Syntax |
Description |
|
|---|---|---|---|
|
sh |
Optional |
Boolean |
Whether hidden plans are shown. Default is false |
|
cat |
Optional |
CategoryID |
Category filter to apply. Default is “all”. |
|
folderID |
Optional |
FolderID |
Parent folder ID; default is the root folder (NM:/) |
|
flatView |
Optional |
Boolean |
Whether to display results in flat view; defaults to true |
|
result |
ExecutionPlanArray |
The execution plans |
|