PROCEDURE: SYS.ODCISTATSOPTIONSDUMP

Source

1 PROCEDURE ODCIStatsOptionsDump(so ODCIStatsOptions) IS
2 BEGIN
3   if so is null then
4    dbms_output.put_line('ODCIStatsOptions is null');
5    return;
6   end if;
7 
8   dbms_output.put_line('ODCIStatsOptions');
9   IF (so.Flags = ODCIConst.ComputeStats)
10   THEN
11     dbms_output.put_line('     Compute Stats');
12   END IF;
13   IF (so.Flags = ODCIConst.EstimateStats)
14   THEN
15     dbms_output.put_line('     Estimate Stats');
16     IF (so.Options = ODCIConst.PercentOption)
17     THEN
18       dbms_output.put_line('     Sample ' || so.Sample || ' Percent');
19     ELSE
20           dbms_output.put_line('     Sample ' || so.Sample || ' Rows');
21     END IF;
22   END IF;
23   IF (so.Flags = ODCIConst.Validate)
24   THEN
25     dbms_output.put_line('     Validate');
26   END IF;
27 
28 END;