EC2 maximum number of volumes

Posted on July 8, 2020 by Brian Fitzgerald

Introduction

The documented AWS EC2 EBS volume attachment limit is 27. The attachment limit affects the maximum number of Oracle ASM disks.

EC2 volume limit

Amazon AWS documents a 27-volume attachment limit. I have found that a t2 type creation attempt with 28 EBS volumes will abort.

Attempting to create an m5 (Nitro) with 28 or more volumes will hang.

creating

The attachment limit is 28, including network interfaces, volumes, and instance store volumes. EC2 instances with one network interface can have up to 27 volumes attached.

EC2 instances with more than 27 volumes

I am aware of t2 EC2 systems with as many as 44 volumes attached. I have no information about how this was done, and what the customer’s support expectations are. I would be concerned about how such a system would respond to a change of instance type.

Oracle Database

In planning an Oracle database installation, you may need file system mounts as well. /u01, for example. The underlying volume counts against the maximum attachment count.

In laying out an ASM setup, consider a simple design, with as few ASM disks and ASM disk groups as needed.

Conclusion

Based on the available public information, I recommend limiting the number of EBS volume attachments to 27. Oracle database administrators might want to simplify their ASM implementation.

Gremlin Graph database statements

Posted on May 28, 2019 by Brian Fitzgerald

By Brian Fitzgerald

Introduction

This blog post covers some basic Gremlin data operations on a graph database. The database platforms tested are TinkerPop implementations in Azure Cosmos DB and AWS Neptune.

Initialization

Azure

Create a Cosmos DB account. For API, select “Gremlin (graph)”.

In data explorer, create a new graph.

AWS

Create a Neptune database and an EC2 instance. Setup your security group. Connect via gremlin.sh as described in the manual.

Insert Data

All statements in this blog post will run as well on Azure and AWS, but there are differences in the output display.

Add vertices.

g.addV('person').property('firstName', 'Marko')
g.addV('person').property('firstName', 'Stephen')
g.addV('person').property('firstName', 'Ben')
g.addV('person').property('firstName', 'Mary')

Add edges.

g.V().has('firstName','Marko').addE('knows').to(g.V().has('firstName','Stephen'))
g.V().has('firstName','Marko').addE('knows').to(g.V().has('firstName','Ben'))
g.V().has('firstName','Marko').addE('knows').to(g.V().has('firstName','Mary'))

Update data (set properties)

Set vertex properties

g.V().has('person','firstName','Marko').property('lastName','Rodriguez')

The output in this section is from Azure Cosmos DB Data explorer:

[
  {
    "id": "7cf848d1-0b87-412c-87fe-267e6f259a86",
    "label": "person",
    "type": "vertex",
    "properties": {
      "firstName": [
        {
          "id": "b45eb2be-a0b7-4c55-a956-85b985b88b35",
          "value": "Marko"
        }
      ],
      "lastName": [
        {
          "id": "a28f96e7-8e17-4be7-8a15-a3a0d3aeba87",
          "value": "Rodriguez"
        }
      ]
    }
  }
]

Notice that each vertex property has an “id” field. In this example, the “lastName” “id” is “a28f96e7-8e17-4be7-8a15-a3a0d3aeba87”. If you update a property, even by setting it to the same value, the “id” changes.

g.V().has('person','firstName','Marko').property('lastName','Rodriguez')

[
  {
    "id": "7cf848d1-0b87-412c-87fe-267e6f259a86",
    "label": "person",
    "type": "vertex",
    "properties": {
      "firstName": [
        {
          "id": "b45eb2be-a0b7-4c55-a956-85b985b88b35",
          "value": "Marko"
        }
      ],
      "lastName": [
        {
          "id": "0d5e4855-4d78-45d9-85c2-de774ca21e87",
          "value": "Rodriguez"
        }
      ]
    }
  }
]

Now the “lastName” “id” is “0d5e4855-4d78-45d9-85c2-de774ca21e87”

Set edge properties

Add a weight property to each edge.

g.V().has('person','firstName','Marko').outE('knows').as('e').inV().has('firstName','Stephen').select('e').property('weight', 0.055)
g.V().has('person','firstName','Marko').outE('knows').as('e').inV().has('firstName','Ben').select('e').property('weight', 0.075)
g.V().has('person','firstName','Marko').outE('knows').as('e').inV().has('firstName','Mary').select('e').property('weight', 0.075)

Notice that edge properties to not have an “id” attribute:

g.V().has('person','firstName','Marko').outE('knows').as('e').inV().has('firstName','Stephen').select('e')

[
  {
    "id": "a37cdd6d-9e72-44f9-b36a-256f824eba64",
    "label": "knows",
    "type": "edge",
    "inVLabel": "person",
    "outVLabel": "person",
    "inV": "a9067638-e56d-4fd0-9522-c955c4062fa3",
    "outV": "7cf848d1-0b87-412c-87fe-267e6f259a86",
    "properties": {
      "weight": 0.055
    }
  }
]

Search

Search for Stephen

g.V().has('person','firstName','Stephen')

Azure Cosmos DB

Here is what the output looks like in Azure Cosmos DB Data Explorer.

[
  {
    "id": "a9067638-e56d-4fd0-9522-c955c4062fa3",
    "label": "person",
    "type": "vertex",
    "properties": {
      "firstName": [
        {
          "id": "3ac1eb02-6255-4787-a32c-2b61359f127c",
          "value": "Stephen"
        }
      ]
    }
  }
]

AWS

By comparison, here is gremlin console display.

gremlin> g.V().has('person','firstName','Stephen')
==>v[32b57f9f-703e-722a-ac4c-2cca662a7bd9]

Only the vertex id is displayed.

Here are some more search queries. Find one edge from Marko with the highest weight.

g.V().has('person','firstName','Marko').outE('knows').order().by('weight', decr).limit(1)

[
  {
    "id": "7c13d3a5-efca-4fc6-8ef4-38924e80c5eb",
    "label": "knows",
    "type": "edge",
    "inVLabel": "person",
    "outVLabel": "person",
    "inV": "1bcbdc44-6b0d-47c6-bbdb-96665b034847",
    "outV": "7cf848d1-0b87-412c-87fe-267e6f259a86",
    "properties": {
      "weight": 0.075
    }
  }
]

Find one vertex adjacent to Marko connected by an edge with the highest weight.

g.V().has('person','firstName','Marko').outE('knows').order().by('weight', decr).limit(1).inV().properties('firstName').value()
[
  {
    "id": "1bcbdc44-6b0d-47c6-bbdb-96665b034847",
    "label": "person",
    "type": "vertex",
    "properties": {
      "firstName": [
        {
          "id": "ebdf5e09-c511-472f-8b14-405fad956146",
          "value": "Ben"
        }
      ]
    }
  }
]

Notice that that vertex “Ben” id “1bcbdc44-6b0d-47c6-bbdb-96665b034847” matches edge inV.

Drop vertices

Drop one vertex.

g.V().has('firstName','Mary').drop()

Drop all vertices

g.V().drop()

All edges get dropped as well.

Scala AWS Lambda function

Posted on May 15, 2019 by Brian Fitzgerald

By Brian Fitzgerald

Introduction

This is a step-by-step procedure on how to create Scala AWS Lambda implementation in Eclipse with Maven. The compiled classes will run in the cloud in AWS Lambda’s java runtime environment (JRE).

Eclipse

To begin with, install these packages into your Eclipse, or check that they are installed:

AWS Toolkit for Eclipse
Scala IDE for Eclipse

Begin with Hello from Lambda!

The instructions in this section are based on the AWS manual. Setup AWS Toolkit for Eclipse.

Setup the AWS Lambda project

Click AWS Toolkit for Eclipse,

aws.toolkit.for.eclipse

and select “New AWS Lambda Java project…” from the dropdown. In the dialog box, enter the project name, i.e. “FiboLam”, change “Input Type” from “S3 Event” to “Custom”, and press “Finish”.

new.aws.lam.proj

Test the existing java function

Right click the project and select “Amazon Web Services” -> “Upload Function to AWS Lambda…”. In the dialog box, select “Create a new Lambda function:”. Enter a name and press “Next”. If you have not done so previously, create your role and S3 bucket. Press “Finish”.

upload.func

Again, right click the project and select “Amazon Web Services” -> “Run function on AWS Lambda…”. Note that the Lambda Handler is in the form “package.class”, i.e. “com.amazonaws.lambda.demo.LambdaFunctionHandler”. Press “Invoke”. Check the console:

Skip uploading function code since no local change is found...
Invoking function...
==================== FUNCTION OUTPUT ====================
"Hello from Lambda!"
==================== FUNCTION LOG OUTPUT ====================
START RequestId: 45a20261-f9aa-4104-a0a3-b3a65cc37c07 Version: $LATEST
Input: {}END RequestId: 45a20261-f9aa-4104-a0a3-b3a65cc37c07
REPORT RequestId: 45a20261-f9aa-4104-a0a3-b3a65cc37c07	Duration: 0.74 ms	Billed Duration: 100 ms 	Memory Size: 512 MB	Max Memory Used: 82 MB

Up to here, we have a working AWS Lambda Java project.

Delete the existing java code

Now wipe out the java code

Expand src/main/java. Delete file LambdaFunctionHandler.java. Delete package com.example.lambda.demo

Expand src/test/java. You may delete file LambdaFunctionHandlerTest.java. Fixing it is out of scope for now.

Expand Maven Dependencies. You will see no scala runtime libraries, so far.

Scala

Add scala runtime library

Right click on the project, select “Configure->Add Scala Nature”

Refresh Maven Dependencies and take note of the version number, i.e. 2.12.3

Right click on the project and select “Maven”->”Add Dependency”, In the dialog box enter:

Group Id: org.scala-lang

Artifact Id: scala-library

Version: the version. i.e 2.12.3

Press “OK”

add.maven.dependency

Expand Maven Dependencies. Note that the scala-library jar appears. A screenshot of the updated Maven tree appears later in this blog.

Create Scala Sources

Set scala perspective

Select Window->Perspective->Open Perspective->Other..” Scroll down and select “Scala”. Press “Open”

Create Scala classes

At “src/main/java”, you can create a new package, let’s say “com.yourcompany.fibo”. Then, create your scala source file. Select “New->Scala Class”, and enter the class name, i.e. “com.yourcompany.fibo.Fibo”.

Replace the code with:

import com.amazonaws.services.lambda.runtime.Context
import com.amazonaws.services.lambda.runtime.RequestHandler

class YourClass extends RequestHandler[Object, String] {

  def handleRequest(o: Object, cx: Context): String =
    yourCode

}

Method “handleRequest” is mandatory. In practice, input Object will be JSON serializable. The return must be of type String. For example, Fibo.scala:

package com.yourcompany.fibo

import com.amazonaws.services.lambda.runtime.Context
import com.amazonaws.services.lambda.runtime.RequestHandler
import com.yourcompany.fibo.FibTailRec.fib

class Fibo extends RequestHandler[Object, String] {

  def handleRequest(o: Object, cx: Context): String =
    fibTailRec(o.toString.toInt).toString

  def fibTailRec(n: Int): Int =
    fib(n, 0, 1)

}

press ctrl-S to save.

FibTailRec.scala

package com.yourcompany.fibo

import scala.annotation.tailrec

object FibTailRec {

  @tailrec def fib(i: Int, p: Int, f: Int): Int = i match {
    case 0 => {
      p
    }
    case _ => fib(i - 1, f, p + f)
  }
}

By the way, this function demonstrates Scala tail call optimization, and is examined in more detail here.

The project tree

Examine the Package Explorer. Expand src/main/java. Note that there is only your package, your sources, and no demo code. Expand Maven Dependencies. Note the scala library jar. Note that no folders or files are flagged with errors.

explorer

Upload the Lambda function

Right click the project and select “Amazon Web Services”->”Upload Function to AWS Lambda..”. Select the correct handler (there should be only one), i.e. “com.yourcompany.fibo.Fibo”. That way, AWS Lambda will automatically look to run method handleRequest. Choose existing Lambda Function: FiboLam

upload.scala

Run the Lambda function

Again, right click the project and select “Amazon Web Services” -> “Run function on AWS Lambda…”. Select your handler, i.e. “com.yourcompany.fibo.Fibo”. For the sake of this blog, we’re not going to delve into scala JSON parsing, so in the text pane, enter a nonnegative integer, i.e. 7. Press “Invoke”.

run.dialog

Output:

Skip uploading function code since no local change is found...
Invoking function...
==================== FUNCTION OUTPUT ====================
"13"
==================== FUNCTION LOG OUTPUT ====================
START RequestId: 0f0990fe-497d-4f78-9709-5c67085d7a78 Version: $LATEST
END RequestId: 0f0990fe-497d-4f78-9709-5c67085d7a78
REPORT RequestId: 0f0990fe-497d-4f78-9709-5c67085d7a78	Duration: 0.54 ms	Billed Duration: 100 ms 	Memory Size: 512 MB	Max Memory Used: 93 MB

Interpretation: 13 is the 7th Fibonacci number.

The upload file

You can go to your S3 bucket and find your file there (FiboLam.zip). You can download and explore the zip file and find your class files and the library jar files.

Summary

I have implemented a Scala AWS Lambda Function using these tools:

Eclipse
- AWS Toolkit
- Scala IDE
AWS
- Lambda Function
- IAM role
- S3 bucket
Maven

The finished Lambda is made from only Scala classes. Now you can replace the Fibonacci code with your own code, and replace the test event with events from other AWS components in your own project.

Using operators >> and << for push and pop in a C++ stack

Posted on April 7, 2019 by Brian Fitzgerald

By Brian Fitzgerald

The C++ “>>” (extraction operator) and “<<” (insertion operator) are normally used with I/O streams (cin/cout), but you can overload these operators in your own classes and make them do other things. In this case, I implement a stack of integers. “>>” is used for push and “<<” is used for pop. Here is Stk.cpp, containing the Stk class routines:

#include "Stk.h"

// push i onto the stack

Stk& operator >>(Stk& st, int i) {
	st.ints = (int *) realloc(st.ints, (++st.len * sizeof(int)));
	st.ints[st.len - 1] = i;
	return st;
}

// pop i off the stack
Stk& operator <<(Stk& st, int &i) {
	if (st.len == 0) {
		throw "empty stack";
	}
	i = st.ints[--st.len];
	return st;
}

int Stk::size() {
	return len;
}

int Stk::peek() {
	return ints[len - 1];
}
bool Stk::isempty() {
	return len == 0;
}

A few things to notice:

The stack is implemented as ints, an array of int.
Push resizes the array with a call to realloc.
Operators >> and << are not members of class Stk
They are implemented as friends.
The friend functions have access to private variables ints and len.
In >> and <<, the type of the first argument and the return is &Stk.

Here is the header:

#include 

#ifndef STK_H_
#define STK_H_

class Stk {
public:
	int size();
	int peek();
	bool isempty();
	friend Stk& operator >>(Stk& st, int i);
	friend Stk& operator <<(Stk& st, int &i);
private:
	int *ints = NULL;
	int len = 0;
};

#endif /* STK_H_ */

Here is the main program:

#include 
#include "Stk.h"
using namespace std;

int main() {
	cout << "begin" << endl;

	Stk st;
	cout << "push 3: 13, 17, 19" << endl; 	st >> 13 >> 17 >> 19;

	cout << "stack size=" << st.size() << endl;
	cout << "pop the stack" << endl;
	while (!st.isempty()) {
		int n;
		st << n;
		cout << "popped n=" << n << endl;
	}
	cout << "stack size=" << st.size() << endl;

	cout << "push 3: 29, 31, 37" << endl; 	st >> 29 >> 31 >> 37;
	int i, j, k;
	cout << "pop 2" << endl;
	st << i << j;
	cout << "i=" << i << " j=" << j << endl;
	cout << "peek " << st.peek() << endl;
	cout << "stack size=" << st.size() << endl;
	cout << "push 2: 41, 47" << endl; 	st >> 41 >> 47;
	cout << "pop 1" << endl;
	st << k;
	cout << "popped k=" << k << endl;
	cout << "stack size=" << st.size() << endl;
	// int p, q, r;
	// st << p << q << r; // empty stack exception
	cout << "done" << endl;
	return 0;
}

Points to notice:

Expression st >> 13 >> 17 >> 19 is evaluated left to right.
st >> 13 is evaluated. The result is st, the stack with 13 pushed.
Internally, the partially evaluated expression is now st >> 17 >> 19.
st >> 17 is evaluated, and so on.

Output:

C:\Users\Brian Fitzgerald\eclipse-workspace\Stk\Debug>Stk.exe
begin
push 3: 13, 17, 19
stack size=3
pop the stack
popped n=19
popped n=17
popped n=13
stack size=0
push 3: 29, 31, 37
pop 2
i=37 j=31
peek 29
stack size=1
push 2: 41, 47
pop 1
popped k=47
stack size=2
done

This is my Saturday project. The purpose was to refresh some skills and to use C++ language features in an interesting way. I saw something similar in one client’s Sybase CT-Library variable binding code. If we’re going to migrate the application to some other database connectivity library, we need to understand how the existing code works, and from there, develop a a migration action plan.

I am a database administrator, not a developer. Any comments or suggestions from anyone in any field are welcome.

neater python logging messages

Posted on May 4, 2018 by Brian Fitzgerald

By Brian Fitzgerald

Here are a few notes on cleaner-looking python logging messages. Some package defaults lead to verbose, ragged looking output.

from threading import Thread
from logging import debug, info, warning, error, critical
from logging import DEBUG, basicConfig
def hello():
    warning('Something is up')
basicConfig(level=DEBUG,
            format='%(asctime)s %(levelname)s %(threadName)s %(message)s'
            )
debug('begin')
error('problem')
critical('danger')
threads = []
for i in [1, 2]:
    th = Thread(target=hello)
    th.start()
    threads.append(th)
for th in threads:
    th.join()
    info('joined')
info('done')

"C:\Users\Brian Fitzgerald\PycharmProjects\blog\venv\Scripts\python.exe" "C:/Users/Brian Fitzgerald/PycharmProjects/blog/threadlogging.py"
2018-05-03 21:12:51,098 DEBUG MainThread begin
2018-05-03 21:12:51,099 ERROR MainThread problem
2018-05-03 21:12:51,099 CRITICAL MainThread danger
2018-05-03 21:12:51,099 WARNING Thread-1 Something is up
2018-05-03 21:12:51,100 WARNING Thread-2 Something is up
2018-05-03 21:12:51,100 INFO MainThread joined
2018-05-03 21:12:51,100 INFO MainThread joined
2018-05-03 21:12:51,100 INFO MainThread done

Process finished with exit code 0

Notes:

The timestamp field is 23 characters
The level field is 4 to 8 characters
The thread identifier in this example is up to 10 characters
The logger prefix requires up to 43 characters
The content has a ragged appearance

Next, we will make three changes

use datefmt for a shorter date string: %Y%m%d.%H%M%S
use single character abbreviations for level: D, I, W, E, and C
format short, fixed-width thread identifiers using th%02d

from threading import Thread, currentThread
from logging import debug, info, warning, error, critical
from logging import DEBUG, basicConfig, addLevelName
def hello():
    warning('Something is up')
basicConfig(
    level=DEBUG,
    datefmt='%Y%m%d.%H%M%S',
    format='%(asctime)s %(levelname)s %(threadName)s %(message)s')
currentThread().setName('main')
addLevelName(10, 'D')
addLevelName(20, 'I')
addLevelName(30, 'W')
addLevelName(40, 'E')
addLevelName(50, 'C')
debug('begin')
error('problem')
critical('danger')
threads = []
for i in [1, 2]:
    th = Thread(target=hello)
    th.setName('th%02d' % i)
    th.start()
    threads.append(th)
for th in threads:
    th.join()
    info('joined')
info('done')

"C:\Users\Brian Fitzgerald\PycharmProjects\blog\venv\Scripts\python.exe" "C:/Users/Brian Fitzgerald/PycharmProjects/blog/threadlogging.py"
20180503.211759 D main begin
20180503.211759 E main problem
20180503.211759 C main danger
20180503.211759 W th01 Something is up
20180503.211759 W th02 Something is up
20180503.211759 I main joined
20180503.211759 I main joined
20180503.211759 I main done

Process finished with exit code 0

Now, each log file entry has a fixed 22-character width. There is more space to the right for the actual content.

python sys.exit vs. os._exit

Posted on May 1, 2018 by Brian Fitzgerald

By Brian Fitzgerald

Here are some notes on the behavior of python functions sys.exit() vs os._exit() in a threaded program.

from threading import Thread, currentThread
from time import sleep, time
import sys
import atexit

def pt(str=None):
    print('el=%ss th=%s: %s' % (
        round(time() - t0, 1),
        currentThread().name, str)
          )

def testexit():
    pt('sleeping')
    sleep(int(currentThread().getName()))
    pt('calling sys.exit')
    sys.exit(0)
    pt('returning')

def alldone():
    pt('all done')

t0 = time()
atexit.register(alldone)
threads = []
for i in [1, 2]:
    th = Thread(target=testexit)
    th.setName(i)
    th.setDaemon(False)
    th.start()
    threads.append(th)
for th in threads:
    pt('waiting to join thread th=%s' % th.name)
    th.join()
    pt('main: joined to th=%s' % th.name)

In the threads, the sleep time equals the thread id, i.e. 1 or 2 seconds. We have arranged that function alldone will execute when the program exits.

"C:\Users\Brian Fitzgerald\PycharmProjects\blog\venv\Scripts\python.exe" "C:/Users/Brian Fitzgerald/PycharmProjects/blog/threadexit.py"
el=0.0s th=1: sleeping
el=0.0s th=2: sleeping
el=0.0s th=MainThread: waiting to join thread th=1
el=1.0s th=1: calling sys.exit
el=1.0s th=MainThread: main: joined to th=1
el=1.0s th=MainThread: waiting to join thread th=2
el=2.0s th=2: calling sys.exit
el=2.0s th=MainThread: main: joined to th=2
el=2.0s th=MainThread: all done
Process finished with exit code 0

Notes:

sys.exit() causes the thread to exit
statement “pt(‘returning’)” is not reached
The main thread finishes
Function alldone is executed
The output is identical if th.setDaemon(True)

Now changing “import sys” to “import os”, and “sys.exit(0)” to “os._exit(0)”:

from threading import Thread, currentThread
from time import sleep, time
import os
import atexit

def pt(str=None):
    print('el=%ss th=%s: %s' % (
        round(time() - t0, 1),
        currentThread().name, str)
          )

def testexit():
    pt('sleeping')
    sleep(int(currentThread().getName()))
    pt('calling os._exit')
    os._exit(0)
    pt('returning')

def alldone():
    pt('all done')

t0 = time()
atexit.register(alldone)
threads = []
for i in [1, 2]:
    th = Thread(target=testexit)
    th.setName(i)
    th.setDaemon(False)
    th.start()
    threads.append(th)

for th in threads:
    pt('waiting to join thread th=%s' % th.name)
    th.join()
    pt('main: joined to th=%s' % th.name)

"C:\Users\Brian Fitzgerald\PycharmProjects\blog\venv\Scripts\python.exe" "C:/Users/Brian Fitzgerald/PycharmProjects/blog/threadexit.py"
el=0.0s th=1: sleeping
el=0.0s th=2: sleeping
el=0.0s th=MainThread: waiting to join thread th=1
el=1.0s th=1: calling os._exit

Process finished with exit code 0

Notes:

MainThread is terminated while waiting to join thread 1.
thread 2 is terminated while sleeping
alldone is not reached
The output is identical if th.setDaemon(True)

Beware that os._exit can terminate a thread while it is in an exception handler:

def testexit():
    pt('try')
    try:
        raise Exception()
    except:
        pt('sleeping')
        sleep(int(currentThread().getName()))
        pt('done except')
    finally:
        pt('done finally')
    pt('calling os._exit')
    os._exit(0)
    pt('returning')

"C:\Users\Brian Fitzgerald\PycharmProjects\blog\venv\Scripts\python.exe" "C:/Users/Brian Fitzgerald/PycharmProjects/blog/threadexit.py"
el=0.0s th=1: try
el=0.0s th=1: sleeping
el=0.0s th=MainThread: waiting to join thread th=1
el=0.0s th=2: try
el=0.0s th=2: sleeping
el=1.0s th=1: done except
el=1.0s th=1: done finally
el=1.0s th=1: calling os._exit

Process finished with exit code 0

Note:

In thread 2, pt(‘done except’) is not reached.

os._exit can also interrupt a finally block:

def testexit():
    pt('try')
    try:
        raise Exception()
    except:
        pt('done except')
    finally:
        pt('sleeping')
        sleep(int(currentThread().getName()))
        pt('done finally')
    pt('calling os._exit')
    os._exit(0)
    pt('returning')

"C:\Users\Brian Fitzgerald\PycharmProjects\blog\venv\Scripts\python.exe" "C:/Users/Brian Fitzgerald/PycharmProjects/blog/threadexit.py"
el=0.0s th=1: try
el=0.0s th=1: done except
el=0.0s th=1: sleeping
el=0.0s th=2: try
el=0.0s th=2: done except
el=0.0s th=MainThread: waiting to join thread th=1
el=0.0s th=2: sleeping
el=1.0s th=1: done finally
el=1.0s th=1: calling os._exit

Process finished with exit code 0

Note:

In thread 2, pt(‘done finally’) is not reached

Python variable scope

Posted on April 15, 2018 by Brian Fitzgerald

By Brian Fitzgerald

Python variable scoping rules are different from other languages. If you are accustomed to java, the behavior may surprise you. Scope can be file, class, or function; however, control blocks such as if-else, try-except, or while do not define scope. A variable that is defined in a control block can be used after the control block.

A simple demonstration case is the if-else block. In function test, variable a is set in the if and else blocks, and is used after the if-else structure.

Not defining a variable before entering a control block is considered idiomatic python. IDE PyCharm reports no warnings. If you try to define variable a before the if-else block, as you would in java, PyCharm greys out a and reports it as an unused variable.

Finally, if statement “a = 0” is changed to “pass”, then in statement “a = None”, a is no longer reported as an unused variable, and is displayed in dark grey.

In conclusion, python scoping is different from java’s. You should not carry java variable declaration habits into python projects.

10053 diff: where categoryid and status

Posted on February 12, 2018 by Brian Fitzgerald

[oracle@stormking db12201 12.2]$ diff run1/db12201_ora_20225_CAT.trc run2/db12201_ora_20607_CAT.trc
1c1
< Trace file /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20225_CAT.trc
---
> Trace file /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_CAT.trc
12,13c12,13
< Oracle process number: 41
< Unix process pid: 20225, image: oracle@stormking (TNS V1-V3)
---
> Oracle process number: 40
> Unix process pid: 20607, image: oracle@stormking (TNS V1-V3)
16,22c16,22
< *** 2018-02-11T14:23:23.119343-05:00
< *** SESSION ID:(84.19304) 2018-02-11T14:23:23.119343-05:00
< *** CLIENT ID:() 2018-02-11T14:23:23.119343-05:00
< *** SERVICE NAME:(SYS$USERS) 2018-02-11T14:23:23.119343-05:00
< *** MODULE NAME:(SQL*Plus) 2018-02-11T14:23:23.119343-05:00
< *** ACTION NAME:() 2018-02-11T14:23:23.119343-05:00
< *** CLIENT DRIVER:(SQL*PLUS) 2018-02-11T14:23:23.119343-05:00
---
> *** 2018-02-11T14:25:26.881036-05:00
> *** SESSION ID:(84.15782) 2018-02-11T14:25:26.881036-05:00
> *** CLIENT ID:() 2018-02-11T14:25:26.881036-05:00
> *** SERVICE NAME:(SYS$USERS) 2018-02-11T14:25:26.881036-05:00
> *** MODULE NAME:(SQL*Plus) 2018-02-11T14:25:26.881036-05:00
> *** ACTION NAME:() 2018-02-11T14:25:26.881036-05:00
> *** CLIENT DRIVER:(SQL*PLUS) 2018-02-11T14:25:26.881036-05:00
25c25
< *** TRACE CONTINUED FROM FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20225_STATUS.trc ***
---
> *** TRACE CONTINUED FROM FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_STATUS.trc ***
27c27
< Registered qb: SEL$1 0xf972ef68 (PARSER)
---
> Registered qb: SEL$1 0x6bfd6f68 (PARSER)
817c817
< kkoqbc-subheap (create addr=0x7fddf9729810)
---
> kkoqbc-subheap (create addr=0x7f286bfd1810)
876a877,878
> Column (#3):
> NewDensity:0.000050, OldDensity:0.000050 BktCnt:10000.000000, PopBktCnt:9999.000000, PopValCnt:1, NDV:2
878,879c880,882
< AvgLen: 9 NDV: 2 Nulls: 0 Density: 0.500000
< Estimated selectivity: 0.500000 , col: #3
---
> AvgLen: 9 NDV: 2 Nulls: 0 Density: 0.000050
> Histogram: Freq #Bkts: 2 UncompBkts: 10000 EndPtVals: 2 ActualVal: no
> Estimated selectivity: 0.999900 , endpoint value predicate, col: #3
886c889
< Estimated selectivity: 0.500000 , col: #3
---
> Estimated selectivity: 0.999900 , endpoint value predicate, col: #3
888c891
< Card: Original: 10000.000000 Rounded: 5 Computed: 5.000000 Non Adjusted: 5.000000
---
> Card: Original: 10000.000000 Rounded: 10 Computed: 9.999000 Non Adjusted: 9.999000
893c896
< io = NOCOST, cpu = 50.000000, sel = 0.500000 flag = 2048 ("ORDS"."STATUS"='COMPLETE')
---
> io = NOCOST, cpu = 50.000000, sel = 0.999900 flag = 2048 ("ORDS"."STATUS"='COMPLETE')
916c919
< Estimated selectivity: 0.500000 , col: #3
---
> Estimated selectivity: 0.999900 , endpoint value predicate, col: #3
919,921c922,924
< resc_io: 30.000000 resc_cpu: 2414493
< ix_sel: 0.500000 ix_sel_with_filters: 0.500000
< Cost: 30.064126 Resp: 30.064126 Degree: 1
---
> resc_io: 60.000000 resc_cpu: 4827696
> ix_sel: 0.999900 ix_sel_with_filters: 0.999900
> Cost: 60.128217 Resp: 60.128217 Degree: 1
933c936
< Estimated selectivity: 0.500000 , col: #3
---
> Estimated selectivity: 0.999900 , endpoint value predicate, col: #3
937c940
< Estimated selectivity: 0.500000 , col: #3
---
> Estimated selectivity: 0.999900 , endpoint value predicate, col: #3
940,942c943,945
< resc_io: 14.000000 resc_cpu: 1100550
< ix_sel: 0.500000 ix_sel_with_filters: 0.500000
< Cost: 14.029229 Resp: 14.029229 Degree: 0
---
> resc_io: 28.000000 resc_cpu: 2200050
> ix_sel: 0.999900 ix_sel_with_filters: 0.999900
> Cost: 28.058430 Resp: 28.058430 Degree: 0
946,950c949,950
< Used STATUS_IDX
< Cost = 14.047156, sel = 0.500000
< Access path: Bitmap index - accepted
< Cost: 16.017750 Cost_io: 15.970067 Cost_cpu: 1795404.871128 Sel: 5.0000e-04
< Not Believed to be index-only
---
> Not used STATUS_IDX
> Cost = 28.094281, sel = 0.999900
968c968
< resc: 14.029229 card: 5000.000000 bytes: deg: 1 resp: 14.029229
---
> resc: 28.058430 card: 9999.000000 bytes: deg: 1 resp: 28.058430
970,972c970,972
< Cost per ptn: 0.029254 #ptns: 1
< hash_area: 256 (max=41035) buildfrag: 1 probefrag: 19 ppasses: 1
< Hash join: Resc: 15.058748 Resp: 15.058748 [multiMatchCost=0.000000]
---
> Cost per ptn: 0.042531 #ptns: 1
> hash_area: 256 (max=41035) buildfrag: 1 probefrag: 38 ppasses: 1
> Hash join: Resc: 29.101226 Resp: 29.101226 [multiMatchCost=0.000000]
976c976
< resc: 1.000265 card 5.000000 bytes: deg: 1 resp: 1.000265
---
> resc: 1.000265 card 9.999000 bytes: deg: 1 resp: 1.000265
980c980
< Cost per ptn: 0.042514 #ptns: 1
---
> Cost per ptn: 0.042534 #ptns: 1
982c982
< Hash join: Resc: 22.099868 Resp: 22.099868 [multiMatchCost=0.000000]
---
> Hash join: Resc: 22.099888 Resp: 22.099888 [multiMatchCost=0.000000]
986c986
< Cost: 37.158616
---
> Cost: 51.201114
990c990
< Cost: 11.002220 Degree: 1 Resp: 11.002220 Card: 5.000000 Bytes: 0.000000
---
> Cost: 11.002220 Degree: 1 Resp: 11.002220 Card: 9.999000 Bytes: 0.000000
1004c1004
< Best so far: Table#: 0 cost: 11.002220 card: 5.000000 bytes: 85.000000
---
> Best so far: Table#: 0 cost: 11.002220 card: 9.999000 bytes: 170.000000
1026c1026
< Cost: 11.002220 Degree: 1 Card: 5.000000 Bytes: 85.000000
---
> Cost: 11.002220 Degree: 1 Card: 10.000000 Bytes: 170.000000
1029c1029
< kkoqbc-subheap (delete addr=0x7fddf9729810, in-use=42200, alloc=49272)
---
> kkoqbc-subheap (delete addr=0x7f286bfd1810, in-use=42200, alloc=49272)
1032c1032
< call(in-use=10064, alloc=65760), compile(in-use=93904, alloc=97328), execution(in-use=2936, alloc=4032)
---
> call(in-use=9856, alloc=65760), compile(in-use=95696, alloc=99072), execution(in-use=2936, alloc=4032)
1038c1038
< call(in-use=10064, alloc=65760), compile(in-use=94912, alloc=97328), execution(in-use=2936, alloc=4032)
---
> call(in-use=9856, alloc=65760), compile(in-use=96704, alloc=99072), execution(in-use=2936, alloc=4032)
1043c1043
< SPD: Inserted felem, fid=11333809974545767572, ftype = 1, freason = 1, dtype = 0, dstate = 0, dflag = 0, ver = NO, keep = NO
---
> SPD: Modified felem, fid=11333809974545767572, ftype = 1, freason = 1, dtype = 0, dstate = 0, dflag = 0, ver = NO, keep = NO
1047c1047
< SPD: Inserted felem, fid=2757520453804995358, ftype = 1, freason = 1, dtype = 0, dstate = 0, dflag = 0, ver = NO, keep = NO
---
> SPD: Modified felem, fid=2757520453804995358, ftype = 1, freason = 1, dtype = 0, dstate = 0, dflag = 0, ver = NO, keep = NO
1083c1083
< | 1 | TABLE ACCESS BY INDEX ROWID BATCHED | ORDS | 5 | 85 | 11 | 00:00:01 |
---
> | 1 | TABLE ACCESS BY INDEX ROWID BATCHED | ORDS | 10 | 170 | 11 | 00:00:01 |
2973c2973
< SEL$1 0xf972ef68 (PARSER) [FINAL]
---
> SEL$1 0x6bfd6f68 (PARSER) [FINAL]
2976c2976
< call(in-use=17648, alloc=65760), compile(in-use=123424, alloc=183352), execution(in-use=10112, alloc=12144)
---
> call(in-use=17440, alloc=65760), compile(in-use=125208, alloc=187496), execution(in-use=10112, alloc=12144)
2983c2983
< *** TRACE CONTINUES IN FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20225_GBY.trc ***
---
> *** TRACE CONTINUES IN FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_GBY.trc ***

10053 diff: where status = ‘PENDING’

Posted on February 12, 2018 by Brian Fitzgerald

[oracle@stormking db12201 12.2]$ diff run1/db12201_ora_20225_STATUS.trc run2/db12201_ora_20607_STATUS.trc

1c1
< Trace file /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20225_STATUS.trc
---
> Trace file /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_STATUS.trc
12,13c12,13
< Oracle process number: 41
< Unix process pid: 20225, image: oracle@stormking (TNS V1-V3)
---
> Oracle process number: 40
> Unix process pid: 20607, image: oracle@stormking (TNS V1-V3)
16,22c16,22
< *** 2018-02-11T14:23:22.737391-05:00
< *** SESSION ID:(84.19304) 2018-02-11T14:23:22.737391-05:00
< *** CLIENT ID:() 2018-02-11T14:23:22.737391-05:00
< *** SERVICE NAME:(SYS$USERS) 2018-02-11T14:23:22.737391-05:00
< *** MODULE NAME:(SQL*Plus) 2018-02-11T14:23:22.737391-05:00
< *** ACTION NAME:() 2018-02-11T14:23:22.737391-05:00
< *** CLIENT DRIVER:(SQL*PLUS) 2018-02-11T14:23:22.737391-05:00
---
> *** 2018-02-11T14:25:26.553076-05:00
> *** SESSION ID:(84.15782) 2018-02-11T14:25:26.553076-05:00
> *** CLIENT ID:() 2018-02-11T14:25:26.553076-05:00
> *** SERVICE NAME:(SYS$USERS) 2018-02-11T14:25:26.553076-05:00
> *** MODULE NAME:(SQL*Plus) 2018-02-11T14:25:26.553076-05:00
> *** ACTION NAME:() 2018-02-11T14:25:26.553076-05:00
> *** CLIENT DRIVER:(SQL*PLUS) 2018-02-11T14:25:26.553076-05:00
25c25
< *** TRACE CONTINUED FROM FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20225_STATS.trc ***
---
> *** TRACE CONTINUED FROM FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_STATS.trc ***
27c27
< Registered qb: SEL$1 0xf972ef68 (PARSER)
---
> Registered qb: SEL$1 0x6bfd6f68 (PARSER)
816c816
< kkoqbc-subheap (create addr=0x7fddf9729810)
---
> kkoqbc-subheap (create addr=0x7f286bfd1810)
873a874,875
> Column (#3):
> NewDensity:0.000050, OldDensity:0.000050 BktCnt:10000.000000, PopBktCnt:9999.000000, PopValCnt:1, NDV:2
875,876c877,879
< AvgLen: 9 NDV: 2 Nulls: 0 Density: 0.500000
< Estimated selectivity: 0.500000 , col: #3
---
> AvgLen: 9 NDV: 2 Nulls: 0 Density: 0.000050
> Histogram: Freq #Bkts: 2 UncompBkts: 10000 EndPtVals: 2 ActualVal: no
> Estimated selectivity: 1.0000e-04 , endpoint value predicate, col: #3
878c881
< Card: Original: 10000.000000 Rounded: 5000 Computed: 5000.000000 Non Adjusted: 5000.000000
---
> Card: Original: 10000.000000 Rounded: 1 Computed: 1.000000 Non Adjusted: 1.000000
882c885
< io = NOCOST, cpu = 50.000000, sel = 0.500000 flag = 2048 ("ORDS"."STATUS"='PENDING')
---
> io = NOCOST, cpu = 50.000000, sel = 0.000100 flag = 2048 ("ORDS"."STATUS"='PENDING')
896c899
< Estimated selectivity: 0.500000 , col: #3
---
> Estimated selectivity: 1.0000e-04 , endpoint value predicate, col: #3
899,901c902,904
< resc_io: 30.000000 resc_cpu: 2164493
< ix_sel: 0.500000 ix_sel_with_filters: 0.500000
< Cost: 30.057486 Resp: 30.057486 Degree: 1
---
> resc_io: 2.000000 resc_cpu: 15483
> ix_sel: 1.0000e-04 ix_sel_with_filters: 1.0000e-04
> Cost: 2.000411 Resp: 2.000411 Degree: 1
904c907
< Estimated selectivity: 0.500000 , col: #3
---
> Estimated selectivity: 1.0000e-04 , endpoint value predicate, col: #3
908c911
< Estimated selectivity: 0.500000 , col: #3
---
> Estimated selectivity: 1.0000e-04 , endpoint value predicate, col: #3
911,913c914,916
< resc_io: 14.000000 resc_cpu: 1100550
< ix_sel: 0.500000 ix_sel_with_filters: 0.500000
< Cost: 14.029229 Resp: 14.029229 Degree: 0
---
> resc_io: 1.000000 resc_cpu: 8171
> ix_sel: 1.0000e-04 ix_sel_with_filters: 1.0000e-04
> Cost: 1.000217 Resp: 1.000217 Degree: 0
916c919
< Cost = 14.047156, sel = 0.500000
---
> Cost = 1.000221, sel = 1.0000e-04
931c934
< resc: 14.029229 card 5000.000000 bytes: deg: 1 resp: 14.029229
---
> resc: 1.000217 card 1.000000 bytes: deg: 1 resp: 1.000217
935,937c938,940
< Cost per ptn: 0.062413 #ptns: 1
< hash_area: 256 (max=41035) buildfrag: 19 probefrag: 32 ppasses: 1
< Hash join: Resc: 35.148731 Resp: 35.148731 [multiMatchCost=0.000000]
---
> Cost per ptn: 0.042498 #ptns: 1
> hash_area: 256 (max=41035) buildfrag: 1 probefrag: 32 ppasses: 1
> Hash join: Resc: 22.099804 Resp: 22.099804 [multiMatchCost=0.000000]
941c944
< Cost: 35.148731
---
> Cost: 22.099804
943,944c946,948
< Best:: AccessPath: TableScan
< Cost: 11.070360 Degree: 1 Resp: 11.070360 Card: 5000.000000 Bytes: 0.000000
---
> Best:: AccessPath: IndexRange
> Index: STATUS_IDX
> Cost: 2.000411 Degree: 1 Resp: 2.000411 Card: 1.000000 Bytes: 0.000000
958c962
< Best so far: Table#: 0 cost: 11.070360 card: 5000.000000 bytes: 65000.000000
---
> Best so far: Table#: 0 cost: 2.000411 card: 1.000000 bytes: 13.000000
970,971c974,975
< AutoDOP: Consider caching for ORDS[ORDS](obj#93045)
< cost:11.070360 blkSize:8192 objSize:35.00 marObjSize:33.25 bufSize:469047.00 affPercent:80 smallTab:YES affinitized:NO
---
> AutoDOP: Consider caching for ORDS[ORDS](obj#-1)
> cost:2.000411 blkSize:8192 objSize:35.00 marObjSize:33.25 bufSize:469047.00 affPercent:80 smallTab:YES affinitized:NO
974c978,979
< id=0 frofand predicate="ORDS"."STATUS"='PENDING'
---
> id=0 frofkks[i] (index start key) predicate="ORDS"."STATUS"='PENDING'
> id=0 frofkke[i] (index stop key) predicate="ORDS"."STATUS"='PENDING'
978,981c983,986
< Cost: 11.070360 Degree: 1 Card: 5000.000000 Bytes: 65000.000000
< Resc: 11.070360 Resc_io: 11.000000 Resc_cpu: 2649250
< Resp: 11.070360 Resp_io: 11.000000 Resc_cpu: 2649250
< kkoqbc-subheap (delete addr=0x7fddf9729810, in-use=41016, alloc=49272)
---
> Cost: 2.000411 Degree: 1 Card: 1.000000 Bytes: 13.000000
> Resc: 2.000411 Resc_io: 2.000000 Resc_cpu: 15483
> Resp: 2.000411 Resp_io: 2.000000 Resc_cpu: 15483
> kkoqbc-subheap (delete addr=0x7f286bfd1810, in-use=41112, alloc=49272)
984c989
< call(in-use=9096, alloc=65760), compile(in-use=86264, alloc=89040), execution(in-use=2936, alloc=4032)
---
> call(in-use=8888, alloc=65760), compile(in-use=88344, alloc=89040), execution(in-use=2936, alloc=4032)
990c995
< call(in-use=9096, alloc=65760), compile(in-use=87272, alloc=89040), execution(in-use=2936, alloc=4032)
---
> call(in-use=8888, alloc=65760), compile(in-use=89352, alloc=93184), execution(in-use=2936, alloc=4032)
992a998,1004
> CBRID: ORDS @ SEL$1 TableLookup allocation - Failure - bug-fix control
> kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
> block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
> tot_io_size=0(MB) time=0(ms)
> kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
> block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
> tot_io_size=0(MB) time=0(ms)
1002c1014
< sql_id=03y2yj25g7d27 plan_hash_value=1252245826 problem_type=3
---
> sql_id=03y2yj25g7d27 plan_hash_value=1807741764 problem_type=3
1016,1021c1028,1034
< -------------------------------------+-----------------------------------+
< | Id | Operation | Name | Rows | Bytes | Cost | Time |
< -------------------------------------+-----------------------------------+
< | 0 | SELECT STATEMENT | | | | 11 | |
< | 1 | TABLE ACCESS FULL | ORDS | 5000 | 63K | 11 | 00:00:01 |
< -------------------------------------+-----------------------------------+
---
> ---------------------------------------------------------+-----------------------------------+
> | Id | Operation | Name | Rows | Bytes | Cost | Time |
> ---------------------------------------------------------+-----------------------------------+
> | 0 | SELECT STATEMENT | | | | 2 | |
> | 1 | TABLE ACCESS BY INDEX ROWID BATCHED | ORDS | 1 | 13 | 2 | 00:00:01 |
> | 2 | INDEX RANGE SCAN | STATUS_IDX| 1 | | 1 | 00:00:01 |
> ---------------------------------------------------------+-----------------------------------+
1024a1038
> 2 - SEL$1 / ORDS@SEL$1
1028c1042
< 1 - filter("STATUS"='PENDING')
---
> 2 - access("STATUS"='PENDING')
1034,1036c1048,1050
< plan_hash_full : 2095704957
< plan_hash : 1252245826
< plan_hash_2 : 2095704957
---
> plan_hash_full : 2670720227
> plan_hash : 1807741764
> plan_hash_2 : 2670720227
1045c1059,1060
< FULL(@"SEL$1" "ORDS"@"SEL$1")
---
> INDEX_RS_ASC(@"SEL$1" "ORDS"@"SEL$1" ("ORDS"."STATUS"))
> BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$1" "ORDS"@"SEL$1")
2906c2921
< SEL$1 0xf972ef68 (PARSER) [FINAL]
---
> SEL$1 0x6bfd6f68 (PARSER) [FINAL]
2909c2924
< call(in-use=16696, alloc=65760), compile(in-use=108432, alloc=168664), execution(in-use=6504, alloc=8088)
---
> call(in-use=13888, alloc=65760), compile(in-use=113288, alloc=175064), execution(in-use=9136, alloc=12144)
2916c2931,2933
< *** TRACE CONTINUES IN FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20225_CAT.trc ***
---
> *** 2018-02-11T14:25:26.880036-05:00
>
> *** TRACE CONTINUES IN FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_CAT.trc ***

db12201_ora_20607_GBY.trc

Posted on February 11, 2018 by Brian Fitzgerald

Trace file /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_GBY.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME: /u01/app/oracle/product/12.2.0/dbhome_1
System name: Linux
Node name: stormking
Release: 2.6.39-400.247.1.el6uek.x86_64
Version: #1 SMP Thu Feb 5 16:06:15 PST 2015
Machine: x86_64
Instance name: db12201
Redo thread mounted by this instance: 1
Oracle process number: 40
Unix process pid: 20607, image: oracle@stormking (TNS V1-V3)




*** 2018-02-11T14:25:27.002021-05:00
*** SESSION ID:(84.15782) 2018-02-11T14:25:27.002021-05:00
*** CLIENT ID:() 2018-02-11T14:25:27.002021-05:00
*** SERVICE NAME:(SYS$USERS) 2018-02-11T14:25:27.002021-05:00
*** MODULE NAME:(SQL*Plus) 2018-02-11T14:25:27.002021-05:00
*** ACTION NAME:() 2018-02-11T14:25:27.002021-05:00
*** CLIENT DRIVER:(SQL*PLUS) 2018-02-11T14:25:27.002021-05:00


*** TRACE CONTINUED FROM FILE /u01/app/oracle/diag/rdbms/db12201/db12201/trace/db12201_ora_20607_CAT.trc ***

Registered qb: SEL$1 0x6bfd6f68 (PARSER)
---------------------
QUERY BLOCK SIGNATURE
---------------------
 signature (): qb_name=SEL$1 nbfros=1 flg=0
 fro(0): flg=4 objn=93045 hint_alias="ORDS"@"SEL$1"

SPM: statement not found in SMB
SPM: capture of plan baseline is OFF

**************************
Automatic degree of parallelism (AUTODOP)
**************************
Automatic degree of parallelism is disabled: Parameter.
kkopqSetForceParallelProperties: Hint:no
Query: compute:yes forced:no forceDop:0
Global Manual Dop: 1 - Rounded?: no

PM: Considering predicate move-around in query block SEL$1 (#0)
**************************
Predicate Move-Around (PM)
**************************
OPTIMIZER INFORMATION

******************************************
----- Current SQL Statement for this session (sql_id=1yn23jxt8g9fj) -----
select status, count(*) numords
from ords
group by status
*******************************************
Legend
The following abbreviations are used by optimizer trace.
CBQT - cost-based query transformation
JPPD - join predicate push-down
OJPPD - old-style (non-cost-based) JPPD
FPD - filter push-down
PM - predicate move-around
CVM - complex view merging
SPJ - select-project-join
SJC - set join conversion
SU - subquery unnesting
OBYE - order by elimination
OST - old style star transformation
ST - new (cbqt) star transformation
CNT - count(col) to count(*) transformation
JE - Join Elimination
JF - join factorization
CBY - connect by
SLP - select list pruning
DP - distinct placement
VT - vector transformation
AAT - Approximate Aggregate Transformation
ORE - CBQT OR-Expansion
LORE - Legacy OR-Expansion
qb - query block
LB - leaf blocks
DK - distinct keys
LB/K - average number of leaf blocks per key
DB/K - average number of data blocks per key
CLUF - clustering factor
NDV - number of distinct values
Resp - response cost
Card - cardinality
Resc - resource cost
NL - nested loops (join)
SM - sort merge (join)
HA - hash (join)
CPUSPEED - CPU Speed 
IOTFRSPEED - I/O transfer speed
IOSEEKTIM - I/O seek time
SREADTIM - average single block read time
MREADTIM - average multiblock read time
MBRC - average multiblock read count
MAXTHR - maximum I/O system throughput
SLAVETHR - average slave I/O throughput
dmeth - distribution method
 1: no partitioning required
 2: value partitioned
 4: right is random (round-robin)
 128: left is random (round-robin)
 8: broadcast right and partition left
 16: broadcast left and partition right
 32: partition left using partitioning of right
 64: partition right using partitioning of left
 256: run the join in serial
 0: invalid distribution method
sel - selectivity
ptn - partition
AP - adaptive plans
***************************************
PARAMETERS USED BY THE OPTIMIZER
********************************
 *************************************
 PARAMETERS WITH ALTERED VALUES
 ******************************
Compilation Environment Dump
_pga_max_size = 328280 KB
Bug Fix Control Environment




*************************************
 PARAMETERS WITH DEFAULT VALUES
 ******************************
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 12.2.0.1
_optimizer_search_limit = 5
cpu_count = 1
active_instance_count = 1
parallel_threads_per_cpu = 2
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 1641472 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 1024 KB
_smm_max_size_static = 164140 KB
_smm_px_max_size_static = 820736 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 12.2.0.1
parallel_query_mode = enabled
parallel_dml_mode = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
sqlstat_enabled = false
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = false
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
statistics_level = typical
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
_optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_optimizer_null_aware_antijoin = true
_optimizer_extend_jppd_view_types = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_optimizer_connect_by_cost_based = true
_gby_hash_aggregation_enabled = true
_globalindex_pnum_filter_enabled = true
_px_minus_intersect = true
_fix_control_key = 0
_force_slave_mapping_intra_part_loads = false
_force_tmp_segment_loads = false
_query_mmvrewrite_maxpreds = 10
_query_mmvrewrite_maxintervals = 5
_query_mmvrewrite_maxinlists = 5
_query_mmvrewrite_maxdmaps = 10
_query_mmvrewrite_maxcmaps = 20
_query_mmvrewrite_maxregperm = 512
_query_mmvrewrite_maxqryinlistvals = 500
_disable_parallel_conventional_load = false
_trace_virtual_columns = false
_replace_virtual_columns = true
_virtual_column_overload_allowed = true
_kdt_buffering = true
_first_k_rows_dynamic_proration = true
_optimizer_sortmerge_join_inequality = true
_optimizer_aw_stats_enabled = true
_bloom_pruning_enabled = true
result_cache_mode = MANUAL
_px_ual_serial_input = true
_optimizer_skip_scan_guess = false
_enable_row_shipping = true
_row_shipping_threshold = 100
_row_shipping_explain = false
transaction_isolation_level = read_commited
_optimizer_distinct_elimination = true
_optimizer_multi_level_push_pred = true
_optimizer_group_by_placement = true
_optimizer_rownum_bind_default = 10
_enable_query_rewrite_on_remote_objs = true
_optimizer_extended_cursor_sharing_rel = simple
_optimizer_adaptive_cursor_sharing = true
_direct_path_insert_features = 0
_optimizer_improve_selectivity = true
optimizer_use_pending_statistics = false
_optimizer_enable_density_improvements = true
_optimizer_aw_join_push_enabled = true
_optimizer_connect_by_combine_sw = true
_enable_pmo_ctas = 0
_optimizer_native_full_outer_join = force
_bloom_predicate_enabled = true
_optimizer_enable_extended_stats = true
_is_lock_table_for_ddl_wait_lock = 0
_pivot_implementation_method = choose
optimizer_capture_sql_plan_baselines = false
optimizer_use_sql_plan_baselines = true
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_with_subquery = OPTIMIZER
_optimizer_fkr_index_cost_bias = 10
_optimizer_use_subheap = true
parallel_degree_policy = manual
parallel_degree = 0
parallel_min_time_threshold = 10
_parallel_time_unit = 10
_optimizer_or_expansion_subheap = true
_optimizer_free_transformation_heap = true
_optimizer_reuse_cost_annotations = true
_result_cache_auto_size_threshold = 100
_result_cache_auto_time_threshold = 1000
_optimizer_nested_rollup_for_gset = 100
_nlj_batching_enabled = 1
parallel_query_default_dop = 0
is_recur_flags = 0
optimizer_use_invisible_indexes = false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force = true
cell_offload_processing = true
_rdbms_internal_fplib_enabled = false
db_file_multiblock_read_count = 128
_bloom_folding_enabled = true
_mv_generalized_oj_refresh_opt = true
cell_offload_compaction = ADAPTIVE
cell_offload_plan_display = AUTO
_bloom_predicate_offload = true
_bloom_filter_size = 0
_bloom_pushing_max = 512
parallel_degree_limit = 65535
parallel_force_local = false
parallel_max_degree = 2
total_cpu_count = 1
_optimizer_coalesce_subqueries = true
_optimizer_fast_pred_transitivity = true
_optimizer_fast_access_pred_analysis = true
_optimizer_unnest_disjunctive_subq = true
_optimizer_unnest_corr_set_subq = true
_optimizer_distinct_agg_transform = true
_aggregation_optimization_settings = 0
_optimizer_connect_by_elim_dups = true
_optimizer_eliminate_filtering_join = true
_connect_by_use_union_all = true
dst_upgrade_insert_conv = true
advanced_queuing_internal_cursor = 0
_optimizer_unnest_all_subqueries = true
parallel_autodop = 0
parallel_ddldml = 0
_parallel_cluster_cache_policy = adaptive
_parallel_scalability = 50
iot_internal_cursor = 0
_optimizer_instance_count = 0
_optimizer_connect_by_cb_whr_only = false
_suppress_scn_chk_for_cqn = nosuppress_1466
_optimizer_join_factorization = true
_optimizer_use_cbqt_star_transformation = true
_optimizer_table_expansion = true
_and_pruning_enabled = true
_deferred_constant_folding_mode = DEFAULT
_optimizer_distinct_placement = true
partition_pruning_internal_cursor = 0
parallel_hinted = none
_sql_compatibility = 0
_optimizer_use_feedback = true
_optimizer_try_st_before_jppd = true
_dml_frequency_tracking = false
_optimizer_interleave_jppd = true
kkb_drop_empty_segments = 0
_px_partition_scan_enabled = true
_px_partition_scan_threshold = 64
_optimizer_false_filter_pred_pullup = true
_bloom_minmax_enabled = true
only_move_row = 0
_optimizer_enable_table_lookup_by_nl = true
parallel_execution_message_size = 16384
_px_loc_msg_cost = 1000
_px_net_msg_cost = 10000
_optimizer_generate_transitive_pred = true
_optimizer_cube_join_enabled = true
_optimizer_filter_pushdown = true
deferred_segment_creation = true
_optimizer_outer_join_to_inner = true
_allow_level_without_connect_by = false
_max_rwgs_groupings = 8192
_optimizer_hybrid_fpwj_enabled = true
_px_replication_enabled = true
ilm_filter = 0
_optimizer_partial_join_eval = true
_px_concurrent = true
_px_object_sampling_enabled = true
_px_back_to_parallel = OFF
_optimizer_unnest_scalar_sq = true
_optimizer_full_outer_join_to_outer = true
_px_filter_parallelized = true
_px_filter_skew_handling = true
_zonemap_use_enabled = true
_zonemap_control = 0
_optimizer_multi_table_outerjoin = true
_px_groupby_pushdown = force
_partition_advisor_srs_active = true
_optimizer_ansi_join_lateral_enhance = true
_px_parallelize_expression = true
_fast_index_maintenance = true
_optimizer_ansi_rearchitecture = true
_optimizer_gather_stats_on_load = true
ilm_access_tracking = 0
ilm_dml_timestamp = 0
_px_adaptive_dist_method = choose
_px_adaptive_dist_method_threshold = 0
_optimizer_batch_table_access_by_rowid = true
optimizer_adaptive_reporting_only = false
_optimizer_ads_max_table_count = 0
_optimizer_ads_time_limit = 0
_optimizer_ads_use_result_cache = true
_px_wif_dfo_declumping = choose
_px_wif_extend_distribution_keys = true
_px_join_skew_handling = true
_px_join_skew_ratio = 10
_px_join_skew_minfreq = 30
CLI_internal_cursor = 0
_parallel_fault_tolerance_enabled = false
_parallel_fault_tolerance_threshold = 3
_px_partial_rollup_pushdown = adaptive
_px_single_server_enabled = true
_optimizer_dsdir_usage_control = 0
_px_cpu_autodop_enabled = true
_px_cpu_process_bandwidth = 200
_sql_hvshare_threshold = 0
_px_tq_rowhvs = true
_optimizer_use_gtt_session_stats = true
_optimizer_proc_rate_level = basic
_px_hybrid_TSM_HWMB_load = true
_optimizer_use_histograms = true
PMO_altidx_rebuild = 0
_cell_offload_expressions = true
_cell_materialize_virtual_columns = true
_cell_materialize_all_expressions = false
_rowsets_enabled = true
_rowsets_target_maxsize = 524288
_rowsets_max_rows = 256
_use_hidden_partitions = 0
_px_monitor_load = false
_px_load_monitor_threshold = 10000
_px_numa_support_enabled = false
total_processor_group_count = 1
_adaptive_window_consolidator_enabled = true
_optimizer_strans_adaptive_pruning = true
_bloom_rm_filter = false
_optimizer_null_accepting_semijoin = true
_long_varchar_allow_IOT = 0
_parallel_ctas_enabled = true
_cell_offload_complex_processing = true
_optimizer_performance_feedback = off
_optimizer_proc_rate_source = DEFAULT
_hashops_prefetch_size = 4
_cell_offload_sys_context = true
_multi_commit_global_index_maint = 0
_stat_aggs_one_pass_algorithm = false
_dbg_scan = 2048
_oltp_comp_dbg_scan = 0
_arch_comp_dbg_scan = 0
_optimizer_gather_feedback = true
_upddel_dba_hash_mask_bits = 0
_px_pwmr_enabled = true
_px_cdb_view_enabled = true
_bloom_sm_enabled = true
_optimizer_cluster_by_rowid = true
_optimizer_cluster_by_rowid_control = 129
_partition_cdb_view_enabled = true
_common_data_view_enabled = true
_pred_push_cdb_view_enabled = true
_rowsets_cdb_view_enabled = true
_distinct_agg_optimization_gsets = choose
_array_cdb_view_enabled = true
_optimizer_adaptive_plan_control = 0
_optimizer_adaptive_random_seed = 0
_optimizer_cbqt_or_expansion = on
_inmemory_dbg_scan = 0
_gby_vector_aggregation_enabled = true
_optimizer_vector_transformation = true
_optimizer_vector_fact_dim_ratio = 10
_key_vector_max_size = 0
_key_vector_predicate_enabled = true
_key_vector_predicate_threshold = 0
_key_vector_caching = false
_vector_operations_control = 0
_optimizer_vector_min_fact_rows = 10000000
parallel_dblink = 0
_px_scalable_invdist = true
_key_vector_offload = predicate
_optimizer_aggr_groupby_elim = true
_optimizer_reduce_groupby_key = true
_vector_serialize_temp_threshold = 1000
_always_vector_transformation = false
_optimizer_cluster_by_rowid_batched = true
_object_link_fixed_enabled = true
optimizer_inmemory_aware = true
_optimizer_inmemory_table_expansion = true
_optimizer_inmemory_gen_pushable_preds = true
_optimizer_inmemory_autodop = true
_optimizer_inmemory_access_path = true
_optimizer_inmemory_bloom_filter = true
_parallel_inmemory_min_time_threshold = 1
_parallel_inmemory_time_unit = 1
_rc_sys_obj_enabled = true
_optimizer_nlj_hj_adaptive_join = true
_indexable_con_id = true
_bloom_serial_filter = on
inmemory_force = default
inmemory_query = enable
_inmemory_query_scan = true
_inmemory_query_fetch_by_rowid = false
_inmemory_pruning = on
_px_autodop_pq_overhead = true
_px_external_table_default_stats = true
_optimizer_key_vector_aggr_factor = 75
_optimizer_vector_cost_adj = 100
_cdb_cross_container = 65535
_cdb_view_parallel_degree = 65535
_optimizer_hll_entry = 4096
_px_cdb_view_join_enabled = true
inmemory_size = 0
_external_table_smart_scan = hadoop_only
_optimizer_inmemory_minmax_pruning = true
_approx_cnt_distinct_gby_pushdown = choose
_approx_cnt_distinct_optimization = 0
_optimizer_ads_use_partial_results = true
_query_execution_time_limit = 0
_optimizer_inmemory_cluster_aware_dop = true
_optimizer_db_blocks_buffers = 0 KB
_query_rewrite_use_on_query_computation = true
_px_scalable_invdist_mcol = true
_optimizer_bushy_join = off
_optimizer_bushy_fact_dim_ratio = 20
_optimizer_bushy_fact_min_size = 100000
_optimizer_bushy_cost_factor = 100
_rmt_for_table_redef_enabled = true
_optimizer_eliminate_subquery = true
_sqlexec_cache_aware_hash_join_enabled = true
_zonemap_usage_tracking = true
_sqlexec_hash_based_distagg_enabled = false
_sqlexec_disable_hash_based_distagg_tiv = false
_sqlexec_hash_based_distagg_ssf_enabled = true
_sqlexec_distagg_optimization_settings = 0
approx_for_aggregation = false
approx_for_count_distinct = false
_optimizer_union_all_gsets = true
_rowsets_use_encoding = true
_rowsets_max_enc_rows = 64
_optimizer_enhanced_join_elimination = true
_optimizer_multicol_join_elimination = true
_key_vector_create_pushdown_threshold = 20000
_optimizer_enable_plsql_stats = true
_recursive_with_parallel = true
_recursive_with_branch_iterations = 7
_px_dist_agg_partial_rollup_pushdown = adaptive
_px_adaptive_dist_bypass_enabled = true
_enable_view_pdb = true
_optimizer_key_vector_pruning_enabled = true
_pwise_distinct_enabled = true
_recursive_with_using_temp_table = false
_partition_read_only = true
_sql_alias_scope = true
_cdb_view_no_skip_migrate = false
_approx_perc_sampling_err_rate = 2
_sqlexec_encoding_aware_hj_enabled = true
rim_node_exist = 0
_enable_containers_subquery = false
_force_containers_subquery = false
_cell_offload_vector_groupby = true
_vector_encoding_mode = manual
_ds_xt_split_count = 1
_ds_sampling_method = PROGRESSIVE
_optimizer_ads_use_spd_cache = true
_optimizer_use_table_scanrate = HADOOP_ONLY
_optimizer_use_xt_rowid = true
_xt_sampling_scan_granules = on
_recursive_with_control = 0
_sqlexec_use_rwo_aware_expr_analysis = true
_optimizer_band_join_aware = true
_optimizer_vector_base_dim_fact_factor = 200
approx_for_percentile = none
_approx_percentile_optimization = 0
_projection_pushdown = true
_px_object_sampling = 200
_px_reuse_server_group = true
_optimizer_adaptive_plans_continuous = false
_optimizer_adaptive_plans_iterative = false
_ds_enable_view_sampling = true
_optimizer_generate_ptf_implied_preds = true
_optimizer_inmemory_use_stored_stats = AUTO
_cdb_special_old_xplan = false
uniaud_internal_cursor = 0
_kd_dbg_control = 0
_mv_access_compute_fresh_data = on
_bloom_filter_ratio = 35
_optimizer_control_shard_qry_processing = 65534
containers_parallel_degree = 65535
sql_from_coordinator = 0
_xt_sampling_scan_granules_min_granules = 1
_in_memory_cdt = LIMITED
_in_memory_cdt_maxpx = 4
_px_partition_load_dist_threshold = 64
_px_adaptive_dist_bypass_optimization = 1
_optimizer_interleave_or_expansion = true
_bloom_use_crchash = BASIC
optimizer_adaptive_plans = true
optimizer_adaptive_statistics = false
_optimizer_use_feedback_for_join = false
_optimizer_ads_for_pq = false
_px_join_skewed_values_count = 0

***************************************
 PARAMETERS IN OPT_PARAM HINT
 ****************************
***************************************
Column Usage Monitoring is ON: tracking level = 21
***************************************

Considering Query Transformations on query block SEL$1 (#0)
**************************
Query transformations (QT)
**************************
CBQT: Validity checks passed for 1yn23jxt8g9fj.
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
OBYE: Considering Order-by Elimination from view SEL$1 (#0)
***************************
Order-by elimination (OBYE)
***************************
OBYE: OBYE bypassed: no order by to eliminate.
OJE: Begin: find best directive for query block SEL$1 (#0)
OJE: End: finding best directive for query block SEL$1 (#0)
CNT: Considering count(col) to count(*) on query block SEL$1 (#0)
*************************
Count(col) to Count(*) (CNT)
*************************
CNT: COUNT() to COUNT(*) not done.
query block SEL$1 (#0) unchanged
Considering Query Transformations on query block SEL$1 (#0)
**************************
Query transformations (QT)
**************************
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
query block SEL$1 (#0) unchanged
apadrv-start sqlid=2256377696693495249
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
 :
 call(in-use=1328, alloc=16344), compile(in-use=67976, alloc=68272), execution(in-use=2936, alloc=4032)

*******************************************
Peeked values of the binds in SQL statement
*******************************************




=====================================
SPD: BEGIN context at statement level
=====================================
Stmt: ******* UNPARSED QUERY IS *******
SELECT "ORDS"."STATUS" "STATUS",COUNT(*) "NUMORDS" FROM "U"."ORDS" "ORDS" GROUP BY "ORDS"."STATUS"
Objects referenced in the statement
 ORDS[ORDS] 93045, type = 1
Objects in the hash table
 Hash table Object 93045, type = 1, ownerid = 7329457324875310191:
 No Dynamic Sampling Directives for the object
Return code in qosdInitDirCtx: ENBLD
===================================
SPD: END context at statement level
===================================
CBQT: Considering cost-based transformation on query block SEL$1 (#0)
********************************
COST-BASED QUERY TRANSFORMATIONS
********************************
FPD: Considering simple filter push (pre rewrite) in query block SEL$1 (#0)
FPD: Current where clause predicates ??

OBYE: Considering Order-by Elimination from view SEL$1 (#0)
***************************
Order-by elimination (OBYE)
***************************
OBYE: OBYE bypassed: no order by to eliminate.
Considering Query Transformations on query block SEL$1 (#0)
**************************
Query transformations (QT)
**************************
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
AAT: Considering Approximate Aggregate Transformation on query block SEL$1 (#0) 
*******************************************
Approximate Aggregate Transformation (AAT) 
*******************************************
AAT: no exact aggregates transformed
SQE: Trying SQ elimination.
kkqctdrvTD-start on query block SEL$1 (#0)
kkqctdrvTD-start: :
 call(in-use=1328, alloc=16344), compile(in-use=119504, alloc=122000), execution(in-use=2936, alloc=4032)

ORE: Checking validity of OR Expansion for query block SEL$1 (#1)
kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1328, alloc=16344), compile(in-use=120008, alloc=122000), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1328, alloc=16344), compile(in-use=120128, alloc=122000), execution(in-use=2936, alloc=4032)

kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1328, alloc=16344), compile(in-use=120128, alloc=122000), execution(in-use=2936, alloc=4032)

kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1328, alloc=16344), compile(in-use=120536, alloc=122000), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1328, alloc=16344), compile(in-use=120656, alloc=122000), execution(in-use=2936, alloc=4032)

SJC: Considering set-join conversion in query block SEL$1 (#1)
*************************
Set-Join Conversion (SJC)
*************************
SJC: not performed
QB before group-by removal:******* UNPARSED QUERY IS *******
SELECT "ORDS"."STATUS" "STATUS",COUNT(*) "NUMORDS" FROM "U"."ORDS" "ORDS" GROUP BY "ORDS"."STATUS"
DCL: Checking validity of group-by elimination SEL$1 (#1)
DCL: Result of group-by elimination: Invalid
OJE: Begin: find best directive for query block SEL$1 (#1)
OJE: End: finding best directive for query block SEL$1 (#1)
CNT: Considering count(col) to count(*) on query block SEL$1 (#1)
*************************
Count(col) to Count(*) (CNT)
*************************
CNT: COUNT() to COUNT(*) not done.
PM: Considering predicate move-around in query block SEL$1 (#1)
**************************
Predicate Move-Around (PM)
**************************
PM: PM bypassed: Outer query contains no views.
PM: PM bypassed: Outer query contains no views.
kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1736, alloc=16344), compile(in-use=120800, alloc=122000), execution(in-use=2936, alloc=4032)

kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1736, alloc=16344), compile(in-use=121208, alloc=122000), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1736, alloc=16344), compile(in-use=121328, alloc=122000), execution(in-use=2936, alloc=4032)

isReduceGrByValid: Group By Validation (Passed).
isReduceGrByValid: Group By Validation (Passed).
QB before group-by removal:******* UNPARSED QUERY IS *******
SELECT "ORDS"."STATUS" "STATUS",COUNT(*) "NUMORDS" FROM "U"."ORDS" "ORDS" GROUP BY "ORDS"."STATUS"
kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1736, alloc=16344), compile(in-use=121496, alloc=122000), execution(in-use=2936, alloc=4032)

VT: Initial VT validity check for query block SEL$1 (#1)
VT: Bypassed: inmemory is disabled.
kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1736, alloc=16344), compile(in-use=121928, alloc=126144), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1736, alloc=16344), compile(in-use=122048, alloc=126144), execution(in-use=2936, alloc=4032)

kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1736, alloc=16344), compile(in-use=122048, alloc=126144), execution(in-use=2936, alloc=4032)

BJ: Checking validity for bushy join for query block SEL$1 (#1)
invalid because Not enabled by hint/parameter
BJ: Bypassed: Not enabled by hint/parameter.
kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1736, alloc=16344), compile(in-use=122456, alloc=126144), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1736, alloc=16344), compile(in-use=122576, alloc=126144), execution(in-use=2936, alloc=4032)

kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1736, alloc=16344), compile(in-use=122576, alloc=126144), execution(in-use=2936, alloc=4032)

Registered qb: SEL$1 0x6c4d9b28 (COPY SEL$1)
---------------------
QUERY BLOCK SIGNATURE
---------------------
 signature(): NULL
****************************************
 Cost-Based Group-By/Distinct Placement
****************************************
GBP/DP: Checking validity of GBP/DP for query block SEL$1 (#1)
GBP: Checking validity of group-by placement for query block SEL$1 (#1)
GBP: Bypassed: Query has invalid constructs.
DP: Checking validity of distinct placement for query block SEL$1 (#1)
DP: Bypassed: Query has invalid constructs.
kkqctdrvTD-cleanup: transform(in-use=3584, alloc=4184) :
 call(in-use=1736, alloc=16344), compile(in-use=130400, alloc=136232), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1736, alloc=16344), compile(in-use=126272, alloc=136232), execution(in-use=2936, alloc=4032)

kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1736, alloc=16344), compile(in-use=126272, alloc=136232), execution(in-use=2936, alloc=4032)

TE: Checking validity of table expansion for query block SEL$1 (#1)
TE: Bypassed: No partitioned table in query block.
kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1736, alloc=16344), compile(in-use=126704, alloc=136232), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1736, alloc=16344), compile(in-use=126824, alloc=136232), execution(in-use=2936, alloc=4032)

TE: Checking validity of table expansion for query block SEL$1 (#1)
TE: Bypassed: No partitioned table in query block.
kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1736, alloc=16344), compile(in-use=126824, alloc=136232), execution(in-use=2936, alloc=4032)

ORE: Checking validity of OR Expansion for query block SEL$1 (#1)
kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1736, alloc=16344), compile(in-use=127272, alloc=136232), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1736, alloc=16344), compile(in-use=127392, alloc=136232), execution(in-use=2936, alloc=4032)

ST: Query in kkqstardrv:******* UNPARSED QUERY IS *******
SELECT "ORDS"."STATUS" "STATUS",COUNT(*) "NUMORDS" FROM "U"."ORDS" "ORDS" GROUP BY "ORDS"."STATUS"
ST: not valid since star transformation parameter is FALSE
kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1736, alloc=16344), compile(in-use=127392, alloc=136232), execution(in-use=2936, alloc=4032)

JF: Checking validity of join factorization for query block SEL$1 (#1)
JF: Bypassed: not a UNION or UNION-ALL query block.
kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1736, alloc=16344), compile(in-use=127800, alloc=136232), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1736, alloc=16344), compile(in-use=127920, alloc=136232), execution(in-use=2936, alloc=4032)

JPPD: Considering Cost-based predicate pushdown from query block SEL$1 (#1)
************************************
Cost-based predicate pushdown (JPPD)
************************************
kkqctdrvTD-start on query block SEL$1 (#1)
kkqctdrvTD-start: :
 call(in-use=1736, alloc=16344), compile(in-use=127920, alloc=136232), execution(in-use=2936, alloc=4032)

kkqctdrvTD-cleanup: transform(in-use=0, alloc=0) :
 call(in-use=1736, alloc=16344), compile(in-use=128328, alloc=136232), execution(in-use=2936, alloc=4032)

kkqctdrvTD-end:
 call(in-use=1736, alloc=16344), compile(in-use=128448, alloc=136232), execution(in-use=2936, alloc=4032)

JPPD: Applying transformation directives
query block SEL$1 (#1) unchanged
FPD: Considering simple filter push in query block SEL$1 (#1)
 ?? 
CSE: Considering common sub-expression elimination in query block SEL$1 (#1)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#1).
Final query after transformations:******* UNPARSED QUERY IS *******
SELECT "ORDS"."STATUS" "STATUS",COUNT(*) "NUMORDS" FROM "U"."ORDS" "ORDS" GROUP BY "ORDS"."STATUS"
kkoqbc: optimizing query block SEL$1 (#1)
 
 :
 call(in-use=1736, alloc=16344), compile(in-use=129728, alloc=136232), execution(in-use=2936, alloc=4032)

kkoqbc-subheap (create addr=0x7f286bfd1810)
****************
QUERY BLOCK TEXT
****************
select status, count(*) numords
from ords
group by status

---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0
 fro(0): flg=0 objn=93045 hint_alias="ORDS"@"SEL$1"

-----------------------------
SYSTEM STATISTICS INFORMATION
-----------------------------
Using dictionary system stats.
 Using NOWORKLOAD Stats
 CPUSPEEDNW: 3138 millions instructions/sec (default is 100)
 IOTFRSPEED: 4096 bytes per millisecond (default is 4096)
 IOSEEKTIM: 10 milliseconds (default is 10)
 MBRC: NO VALUE blocks (default is 8)

***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
 Table: ORDS Alias: ORDS
 #Rows: 10000 SSZ: 0 LGR: 0 #Blks: 35 AvgRowLen: 17.00 NEB: 0 ChainCnt: 0.00 ScanRate: 0.00 SPC: 0 RFL: 0 RNF: 0 CBK: 0 CHR: 0 KQDFLG: 1
 #IMCUs: 0 IMCRowCnt: 0 IMCJournalRowCnt: 0 #IMCBlocks: 0 IMCQuotient: 0.000000
Index Stats::
 Index: CATEGORY_IDX Col#: 2
 LVLS: 1 #LB: 21 #DK: 1000 LB/K: 1.00 DB/K: 10.00 CLUF: 10000.00 NRW: 10000.00 SSZ: 0.00 LGR: 0.00 CBK: 0.00 GQL: 0.00 CHR: 0.00 KQDFLG: 8192 BSZ: 1
 KKEISFLG: 1 
 Index: ORDS Col#: 1
 LVLS: 1 #LB: 20 #DK: 10000 LB/K: 1.00 DB/K: 1.00 CLUF: 31.00 NRW: 10000.00 SSZ: 0.00 LGR: 0.00 CBK: 0.00 GQL: 0.00 CHR: 0.00 KQDFLG: 8192 BSZ: 1
 KKEISFLG: 1 
 Index: STATUS_IDX Col#: 3
 LVLS: 1 #LB: 28 #DK: 2 LB/K: 14.00 DB/K: 16.00 CLUF: 32.00 NRW: 10000.00 SSZ: 0.00 LGR: 0.00 CBK: 0.00 GQL: 0.00 CHR: 0.00 KQDFLG: 8192 BSZ: 1
 KKEISFLG: 1 
 Column (#3): 
 NewDensity:0.000050, OldDensity:0.000050 BktCnt:10000.000000, PopBktCnt:9999.000000, PopValCnt:1, NDV:2
 Column (#3): STATUS(VARCHAR2)
 AvgLen: 9 NDV: 2 Nulls: 0 Density: 0.000050
 Histogram: Freq #Bkts: 2 UncompBkts: 10000 EndPtVals: 2 ActualVal: no 
try to generate single-table filter predicates from ORs for query block SEL$1 (#1)
=======================================
SPD: BEGIN context at query block level
=======================================
Query Block SEL$1 (#1)
Return code in qosdSetupDirCtx4QB: NOCTX
=====================================
SPD: END context at query block level
=====================================
Access path analysis for ORDS
***************************************
SINGLE TABLE ACCESS PATH 
 Single Table Cardinality Estimation for ORDS[ORDS] 
 SPD: Return code in qosdDSDirSetup: NOCTX, estType = TABLE
 Table: ORDS Alias: ORDS
 Card: Original: 10000.000000 Rounded: 10000 Computed: 10000.000000 Non Adjusted: 10000.000000
 Scan IO Cost (Disk) = 11.000000
 Scan CPU Cost (Disk) = 2149250.400000
 Total Scan IO Cost = 11.000000 (scan (Disk))
 = 11.000000
 Total Scan CPU Cost = 2149250.400000 (scan (Disk))
 = 2149250.400000
 Access Path: TableScan
 Cost: 11.057081 Resp: 11.057081 Degree: 0
 Cost_io: 11.000000 Cost_cpu: 2149250
 Resp_io: 11.000000 Resp_cpu: 2149250
 Access Path: index (index (FFS))
 Index: STATUS_IDX
 resc_io: 9.000000 resc_cpu: 1399400
 ix_sel: 0.000000 ix_sel_with_filters: 1.000000 
 Access Path: index (FFS)
 Cost: 9.037166 Resp: 9.037166 Degree: 1
 Cost_io: 9.000000 Cost_cpu: 1399400
 Resp_io: 9.000000 Resp_cpu: 1399400
 ****** Costing Index STATUS_IDX
 Access Path: index (FullScan)
 Index: STATUS_IDX
 resc_io: 29.000000 resc_cpu: 2206522
 ix_sel: 1.000000 ix_sel_with_filters: 1.000000 
 Cost: 29.058602 Resp: 29.058602 Degree: 1
******** Begin index join costing ********
 ****** trying bitmap/domain indexes ******
 ****** Costing Index STATUS_IDX
 Access Path: index (FullScan)
 Index: STATUS_IDX
 resc_io: 29.000000 resc_cpu: 2206522
 ix_sel: 1.000000 ix_sel_with_filters: 1.000000 
 Cost: 29.058602 Resp: 29.058602 Degree: 0
 ****** Costing Index STATUS_IDX
 Access Path: index (FullScan)
 Index: STATUS_IDX
 resc_io: 29.000000 resc_cpu: 2206522
 ix_sel: 1.000000 ix_sel_with_filters: 1.000000 
 Cost: 29.058602 Resp: 29.058602 Degree: 0
 Bitmap nodes:
 Used STATUS_IDX
 Cost = 36.323253, sel = 1.000000
 ****** finished trying bitmap/domain indexes ******
******** End index join costing ********
 Best:: AccessPath: IndexFFS
 Index: STATUS_IDX
 Cost: 9.037166 Degree: 1 Resp: 9.037166 Card: 10000.000000 Bytes: 0.000000

Grouping column cardinality [ STATUS] 2
***************************************




OPTIMIZER STATISTICS AND COMPUTATIONS
PJE: Bypassed; QB has a single table SEL$1 (#1)
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.
Permutations for Starting Table :0
Join order[1]: ORDS[ORDS]#0
GROUP BY sort
GROUP BY/Correlated Subquery Filter adjustment factor: 1.000000
GROUP BY cardinality: 2.000000, TABLE cardinality: 10000.000000
Vector group by not costed because no SYS_OP_XLATE_USE in group by.
 SORT ressource Sort statistics
 Sort width: 960 Area size: 1048576 Max Area size: 168079360
 Degree: 1
 Blocks to Sort: 25 Row size: 20 Total Rows: 10000
 Initial runs: 1 Merge passes: 0 IO Cost / pass: 0
 Total IO sort cost: 0.000000 Total CPU sort cost: 43639286
 Total Temp space used: 0
***********************
Best so far: Table#: 0 cost: 10.196165 card: 10000.000000 bytes: 90000.000000
***********************

****** Recost for ORDER BY (using index) ************
Access path analysis for ORDS
***************************************
SINGLE TABLE ACCESS PATH 
 Single Table Cardinality Estimation for ORDS[ORDS] 
 SPD: Return code in qosdDSDirSetup: NOCTX, estType = TABLE
 Table: ORDS Alias: ORDS
 Card: Original: 10000.000000 Rounded: 10000 Computed: 10000.000000 Non Adjusted: 10000.000000
 Scan IO Cost (Disk) = 11.000000
 Scan CPU Cost (Disk) = 2149250.400000
 Total Scan IO Cost = 11.000000 (scan (Disk))
 = 11.000000
 Total Scan CPU Cost = 2149250.400000 (scan (Disk))
 = 2149250.400000
 Access Path: TableScan
 Cost: 11.057081 Resp: 11.057081 Degree: 0
 Cost_io: 11.000000 Cost_cpu: 2149250
 Resp_io: 11.000000 Resp_cpu: 2149250
 ****** Costing Index STATUS_IDX
 Access Path: index (FullScan)
 Index: STATUS_IDX
 resc_io: 29.000000 resc_cpu: 2206522
 ix_sel: 1.000000 ix_sel_with_filters: 1.000000 
 Cost: 29.058602 Resp: 29.058602 Degree: 1
 Best:: AccessPath: IndexRange
 Index: STATUS_IDX
 Cost: 29.058602 Degree: 1 Resp: 29.058602 Card: 10000.000000 Bytes: 0.000000

Join order[1]: ORDS[ORDS]#0
Join order aborted: cost > best plan cost
***********************
(newjo-stop-1) k:0, spcnt:0, perm:1, maxperm:2000

*********************************
Number of join permutations tried: 1
*********************************
Enumerating distribution method (advanced)

GROUP BY/Correlated Subquery Filter adjustment factor: 1.000000
GROUP BY cardinality: 2.000000, TABLE cardinality: 10000.000000
 SORT ressource Sort statistics
 Sort width: 960 Area size: 1048576 Max Area size: 168079360
 Degree: 1
 Blocks to Sort: 25 Row size: 20 Total Rows: 10000
 Initial runs: 1 Merge passes: 0 IO Cost / pass: 0
 Total IO sort cost: 0.000000 Total CPU sort cost: 43639286
 Total Temp space used: 0
LORE: Or-Expansion validity checks failed on query block SEL$1 (#1) because Cost based OR expansion enabled
Transfer Optimizer annotations for query block SEL$1 (#1)
AP: Checking validity for query block SEL$1, sqlid=1yn23jxt8g9fj
AutoDOP: Consider caching for ORDS[ORDS](obj#93048) 
cost:10.196165 blkSize:8192 objSize:28.00 marObjSize:26.60 bufSize:469047.00 affPercent:80 smallTab:YES affinitized:NO
kkecComputeAPDop: IO Dop: 0.000000 - CPU Dop: 0.000000
Replication not feasible for first input in join order
Transfer optimizer annotations for ORDS[ORDS]
GROUP BY/Correlated Subquery Filter adjustment factor: 1.000000
Final cost for query block SEL$1 (#1) - All Rows Plan:
 Best join order: 1
 Cost: 10.196165 Degree: 1 Card: 10000.000000 Bytes: 90000.000000
 Resc: 10.196165 Resc_io: 9.000000 Resc_cpu: 45038687
 Resp: 10.196165 Resp_io: 9.000000 Resc_cpu: 45038687
kkoqbc-subheap (delete addr=0x7f286bfd1810, in-use=27312, alloc=32840)
kkoqbc-end:
 :
 call(in-use=9624, alloc=65656), compile(in-use=135032, alloc=136232), execution(in-use=2936, alloc=4032)

kkoqbc: finish optimizing query block SEL$1 (#1)
CBRID: ORDS @ SEL$1 - blocking operation in qb SEL$1
apadrv-end
 :
 call(in-use=9624, alloc=65656), compile(in-use=138208, alloc=140376), execution(in-use=2936, alloc=4032)




kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s) 
 block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes) 
 tot_io_size=0(MB) time=0(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s) 
 block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes) 
 tot_io_size=0(MB) time=0(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s) 
 block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes) 
 tot_io_size=0(MB) time=0(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s) 
 block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes) 
 tot_io_size=0(MB) time=0(ms)
Starting SQL statement dump

user_id=114 user_name=U module=SQL*Plus action=
sql_id=1yn23jxt8g9fj plan_hash_value=-1648398675 problem_type=3
----- Current SQL Statement for this session (sql_id=1yn23jxt8g9fj) -----
select status, count(*) numords
from ords
group by status
sql_text_length=59
sql=select status, count(*) numords
from ords
group by status

----- Explain Plan Dump -----
----- Plan Table -----
 
============
Plan Table
============
-------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 10 | |
| 1 | HASH GROUP BY | | 2 | 18 | 10 | 00:00:01 |
| 2 | INDEX FAST FULL SCAN | STATUS_IDX| 10K | 88K | 9 | 00:00:01 |
-------------------------------------------+-----------------------------------+
Query Block Name / Object Alias(identified by operation id):
------------------------------------------------------------
 1 - SEL$1 
 2 - SEL$1 / ORDS@SEL$1
------------------------------------------------------------
Predicate Information:
----------------------
 
Content of other_xml column
===========================
 db_version : 12.2.0.1
 parse_schema : U
 plan_hash_full : 3044090569
 plan_hash : 2646568621
 plan_hash_2 : 3044090569
 Outline Data:
 /*+
 BEGIN_OUTLINE_DATA
 IGNORE_OPTIM_EMBEDDED_HINTS
 OPTIMIZER_FEATURES_ENABLE('12.2.0.1')
 DB_VERSION('12.2.0.1')
 ALL_ROWS
 OUTLINE_LEAF(@"SEL$1")
 INDEX_FFS(@"SEL$1" "ORDS"@"SEL$1" ("ORDS"."STATUS"))
 USE_HASH_AGGREGATION(@"SEL$1")
 END_OUTLINE_DATA
 */
 
Optimizer state dump:
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 12.2.0.1
_optimizer_search_limit = 5
cpu_count = 1
active_instance_count = 1
parallel_threads_per_cpu = 2
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 1641472 KB
_pga_max_size = 328280 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 1024 KB
_smm_max_size_static = 164140 KB
_smm_px_max_size_static = 820736 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 12.2.0.1
parallel_query_mode = enabled
parallel_dml_mode = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
sqlstat_enabled = false
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = false
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
statistics_level = typical
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
_optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_optimizer_null_aware_antijoin = true
_optimizer_extend_jppd_view_types = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_optimizer_connect_by_cost_based = true
_gby_hash_aggregation_enabled = true
_globalindex_pnum_filter_enabled = true
_px_minus_intersect = true
_fix_control_key = 0
_force_slave_mapping_intra_part_loads = false
_force_tmp_segment_loads = false
_query_mmvrewrite_maxpreds = 10
_query_mmvrewrite_maxintervals = 5
_query_mmvrewrite_maxinlists = 5
_query_mmvrewrite_maxdmaps = 10
_query_mmvrewrite_maxcmaps = 20
_query_mmvrewrite_maxregperm = 512
_query_mmvrewrite_maxqryinlistvals = 500
_disable_parallel_conventional_load = false
_trace_virtual_columns = false
_replace_virtual_columns = true
_virtual_column_overload_allowed = true
_kdt_buffering = true
_first_k_rows_dynamic_proration = true
_optimizer_sortmerge_join_inequality = true
_optimizer_aw_stats_enabled = true
_bloom_pruning_enabled = true
result_cache_mode = MANUAL
_px_ual_serial_input = true
_optimizer_skip_scan_guess = false
_enable_row_shipping = true
_row_shipping_threshold = 100
_row_shipping_explain = false
transaction_isolation_level = read_commited
_optimizer_distinct_elimination = true
_optimizer_multi_level_push_pred = true
_optimizer_group_by_placement = true
_optimizer_rownum_bind_default = 10
_enable_query_rewrite_on_remote_objs = true
_optimizer_extended_cursor_sharing_rel = simple
_optimizer_adaptive_cursor_sharing = true
_direct_path_insert_features = 0
_optimizer_improve_selectivity = true
optimizer_use_pending_statistics = false
_optimizer_enable_density_improvements = true
_optimizer_aw_join_push_enabled = true
_optimizer_connect_by_combine_sw = true
_enable_pmo_ctas = 0
_optimizer_native_full_outer_join = force
_bloom_predicate_enabled = true
_optimizer_enable_extended_stats = true
_is_lock_table_for_ddl_wait_lock = 0
_pivot_implementation_method = choose
optimizer_capture_sql_plan_baselines = false
optimizer_use_sql_plan_baselines = true
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_with_subquery = OPTIMIZER
_optimizer_fkr_index_cost_bias = 10
_optimizer_use_subheap = true
parallel_degree_policy = manual
parallel_degree = 0
parallel_min_time_threshold = 10
_parallel_time_unit = 10
_optimizer_or_expansion_subheap = true
_optimizer_free_transformation_heap = true
_optimizer_reuse_cost_annotations = true
_result_cache_auto_size_threshold = 100
_result_cache_auto_time_threshold = 1000
_optimizer_nested_rollup_for_gset = 100
_nlj_batching_enabled = 1
parallel_query_default_dop = 0
is_recur_flags = 0
optimizer_use_invisible_indexes = false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force = true
cell_offload_processing = true
_rdbms_internal_fplib_enabled = false
db_file_multiblock_read_count = 128
_bloom_folding_enabled = true
_mv_generalized_oj_refresh_opt = true
cell_offload_compaction = ADAPTIVE
cell_offload_plan_display = AUTO
_bloom_predicate_offload = true
_bloom_filter_size = 0
_bloom_pushing_max = 512
parallel_degree_limit = 65535
parallel_force_local = false
parallel_max_degree = 2
total_cpu_count = 1
_optimizer_coalesce_subqueries = true
_optimizer_fast_pred_transitivity = true
_optimizer_fast_access_pred_analysis = true
_optimizer_unnest_disjunctive_subq = true
_optimizer_unnest_corr_set_subq = true
_optimizer_distinct_agg_transform = true
_aggregation_optimization_settings = 0
_optimizer_connect_by_elim_dups = true
_optimizer_eliminate_filtering_join = true
_connect_by_use_union_all = true
dst_upgrade_insert_conv = true
advanced_queuing_internal_cursor = 0
_optimizer_unnest_all_subqueries = true
parallel_autodop = 0
parallel_ddldml = 0
_parallel_cluster_cache_policy = adaptive
_parallel_scalability = 50
iot_internal_cursor = 0
_optimizer_instance_count = 0
_optimizer_connect_by_cb_whr_only = false
_suppress_scn_chk_for_cqn = nosuppress_1466
_optimizer_join_factorization = true
_optimizer_use_cbqt_star_transformation = true
_optimizer_table_expansion = true
_and_pruning_enabled = true
_deferred_constant_folding_mode = DEFAULT
_optimizer_distinct_placement = true
partition_pruning_internal_cursor = 0
parallel_hinted = none
_sql_compatibility = 0
_optimizer_use_feedback = true
_optimizer_try_st_before_jppd = true
_dml_frequency_tracking = false
_optimizer_interleave_jppd = true
kkb_drop_empty_segments = 0
_px_partition_scan_enabled = true
_px_partition_scan_threshold = 64
_optimizer_false_filter_pred_pullup = true
_bloom_minmax_enabled = true
only_move_row = 0
_optimizer_enable_table_lookup_by_nl = true
parallel_execution_message_size = 16384
_px_loc_msg_cost = 1000
_px_net_msg_cost = 10000
_optimizer_generate_transitive_pred = true
_optimizer_cube_join_enabled = true
_optimizer_filter_pushdown = true
deferred_segment_creation = true
_optimizer_outer_join_to_inner = true
_allow_level_without_connect_by = false
_max_rwgs_groupings = 8192
_optimizer_hybrid_fpwj_enabled = true
_px_replication_enabled = true
ilm_filter = 0
_optimizer_partial_join_eval = true
_px_concurrent = true
_px_object_sampling_enabled = true
_px_back_to_parallel = OFF
_optimizer_unnest_scalar_sq = true
_optimizer_full_outer_join_to_outer = true
_px_filter_parallelized = true
_px_filter_skew_handling = true
_zonemap_use_enabled = true
_zonemap_control = 0
_optimizer_multi_table_outerjoin = true
_px_groupby_pushdown = force
_partition_advisor_srs_active = true
_optimizer_ansi_join_lateral_enhance = true
_px_parallelize_expression = true
_fast_index_maintenance = true
_optimizer_ansi_rearchitecture = true
_optimizer_gather_stats_on_load = true
ilm_access_tracking = 0
ilm_dml_timestamp = 0
_px_adaptive_dist_method = choose
_px_adaptive_dist_method_threshold = 0
_optimizer_batch_table_access_by_rowid = true
optimizer_adaptive_reporting_only = false
_optimizer_ads_max_table_count = 0
_optimizer_ads_time_limit = 0
_optimizer_ads_use_result_cache = true
_px_wif_dfo_declumping = choose
_px_wif_extend_distribution_keys = true
_px_join_skew_handling = true
_px_join_skew_ratio = 10
_px_join_skew_minfreq = 30
CLI_internal_cursor = 0
_parallel_fault_tolerance_enabled = false
_parallel_fault_tolerance_threshold = 3
_px_partial_rollup_pushdown = adaptive
_px_single_server_enabled = true
_optimizer_dsdir_usage_control = 0
_px_cpu_autodop_enabled = true
_px_cpu_process_bandwidth = 200
_sql_hvshare_threshold = 0
_px_tq_rowhvs = true
_optimizer_use_gtt_session_stats = true
_optimizer_proc_rate_level = basic
_px_hybrid_TSM_HWMB_load = true
_optimizer_use_histograms = true
PMO_altidx_rebuild = 0
_cell_offload_expressions = true
_cell_materialize_virtual_columns = true
_cell_materialize_all_expressions = false
_rowsets_enabled = true
_rowsets_target_maxsize = 524288
_rowsets_max_rows = 256
_use_hidden_partitions = 0
_px_monitor_load = false
_px_load_monitor_threshold = 10000
_px_numa_support_enabled = false
total_processor_group_count = 1
_adaptive_window_consolidator_enabled = true
_optimizer_strans_adaptive_pruning = true
_bloom_rm_filter = false
_optimizer_null_accepting_semijoin = true
_long_varchar_allow_IOT = 0
_parallel_ctas_enabled = true
_cell_offload_complex_processing = true
_optimizer_performance_feedback = off
_optimizer_proc_rate_source = DEFAULT
_hashops_prefetch_size = 4
_cell_offload_sys_context = true
_multi_commit_global_index_maint = 0
_stat_aggs_one_pass_algorithm = false
_dbg_scan = 2048
_oltp_comp_dbg_scan = 0
_arch_comp_dbg_scan = 0
_optimizer_gather_feedback = true
_upddel_dba_hash_mask_bits = 0
_px_pwmr_enabled = true
_px_cdb_view_enabled = true
_bloom_sm_enabled = true
_optimizer_cluster_by_rowid = true
_optimizer_cluster_by_rowid_control = 129
_partition_cdb_view_enabled = true
_common_data_view_enabled = true
_pred_push_cdb_view_enabled = true
_rowsets_cdb_view_enabled = true
_distinct_agg_optimization_gsets = choose
_array_cdb_view_enabled = true
_optimizer_adaptive_plan_control = 0
_optimizer_adaptive_random_seed = 0
_optimizer_cbqt_or_expansion = on
_inmemory_dbg_scan = 0
_gby_vector_aggregation_enabled = true
_optimizer_vector_transformation = true
_optimizer_vector_fact_dim_ratio = 10
_key_vector_max_size = 0
_key_vector_predicate_enabled = true
_key_vector_predicate_threshold = 0
_key_vector_caching = false
_vector_operations_control = 0
_optimizer_vector_min_fact_rows = 10000000
parallel_dblink = 0
_px_scalable_invdist = true
_key_vector_offload = predicate
_optimizer_aggr_groupby_elim = true
_optimizer_reduce_groupby_key = true
_vector_serialize_temp_threshold = 1000
_always_vector_transformation = false
_optimizer_cluster_by_rowid_batched = true
_object_link_fixed_enabled = true
optimizer_inmemory_aware = true
_optimizer_inmemory_table_expansion = true
_optimizer_inmemory_gen_pushable_preds = true
_optimizer_inmemory_autodop = true
_optimizer_inmemory_access_path = true
_optimizer_inmemory_bloom_filter = true
_parallel_inmemory_min_time_threshold = 1
_parallel_inmemory_time_unit = 1
_rc_sys_obj_enabled = true
_optimizer_nlj_hj_adaptive_join = true
_indexable_con_id = true
_bloom_serial_filter = on
inmemory_force = default
inmemory_query = enable
_inmemory_query_scan = true
_inmemory_query_fetch_by_rowid = false
_inmemory_pruning = on
_px_autodop_pq_overhead = true
_px_external_table_default_stats = true
_optimizer_key_vector_aggr_factor = 75
_optimizer_vector_cost_adj = 100
_cdb_cross_container = 65535
_cdb_view_parallel_degree = 65535
_optimizer_hll_entry = 4096
_px_cdb_view_join_enabled = true
inmemory_size = 0
_external_table_smart_scan = hadoop_only
_optimizer_inmemory_minmax_pruning = true
_approx_cnt_distinct_gby_pushdown = choose
_approx_cnt_distinct_optimization = 0
_optimizer_ads_use_partial_results = true
_query_execution_time_limit = 0
_optimizer_inmemory_cluster_aware_dop = true
_optimizer_db_blocks_buffers = 0 KB
_query_rewrite_use_on_query_computation = true
_px_scalable_invdist_mcol = true
_optimizer_bushy_join = off
_optimizer_bushy_fact_dim_ratio = 20
_optimizer_bushy_fact_min_size = 100000
_optimizer_bushy_cost_factor = 100
_rmt_for_table_redef_enabled = true
_optimizer_eliminate_subquery = true
_sqlexec_cache_aware_hash_join_enabled = true
_zonemap_usage_tracking = true
_sqlexec_hash_based_distagg_enabled = false
_sqlexec_disable_hash_based_distagg_tiv = false
_sqlexec_hash_based_distagg_ssf_enabled = true
_sqlexec_distagg_optimization_settings = 0
approx_for_aggregation = false
approx_for_count_distinct = false
_optimizer_union_all_gsets = true
_rowsets_use_encoding = true
_rowsets_max_enc_rows = 64
_optimizer_enhanced_join_elimination = true
_optimizer_multicol_join_elimination = true
_key_vector_create_pushdown_threshold = 20000
_optimizer_enable_plsql_stats = true
_recursive_with_parallel = true
_recursive_with_branch_iterations = 7
_px_dist_agg_partial_rollup_pushdown = adaptive
_px_adaptive_dist_bypass_enabled = true
_enable_view_pdb = true
_optimizer_key_vector_pruning_enabled = true
_pwise_distinct_enabled = true
_recursive_with_using_temp_table = false
_partition_read_only = true
_sql_alias_scope = true
_cdb_view_no_skip_migrate = false
_approx_perc_sampling_err_rate = 2
_sqlexec_encoding_aware_hj_enabled = true
rim_node_exist = 0
_enable_containers_subquery = false
_force_containers_subquery = false
_cell_offload_vector_groupby = true
_vector_encoding_mode = manual
_ds_xt_split_count = 1
_ds_sampling_method = PROGRESSIVE
_optimizer_ads_use_spd_cache = true
_optimizer_use_table_scanrate = HADOOP_ONLY
_optimizer_use_xt_rowid = true
_xt_sampling_scan_granules = on
_recursive_with_control = 0
_sqlexec_use_rwo_aware_expr_analysis = true
_optimizer_band_join_aware = true
_optimizer_vector_base_dim_fact_factor = 200
approx_for_percentile = none
_approx_percentile_optimization = 0
_projection_pushdown = true
_px_object_sampling = 200
_px_reuse_server_group = true
_optimizer_adaptive_plans_continuous = false
_optimizer_adaptive_plans_iterative = false
_ds_enable_view_sampling = true
_optimizer_generate_ptf_implied_preds = true
_optimizer_inmemory_use_stored_stats = AUTO
_cdb_special_old_xplan = false
uniaud_internal_cursor = 0
_kd_dbg_control = 0
_mv_access_compute_fresh_data = on
_bloom_filter_ratio = 35
_optimizer_control_shard_qry_processing = 65534
containers_parallel_degree = 65535
sql_from_coordinator = 0
_xt_sampling_scan_granules_min_granules = 1
_in_memory_cdt = LIMITED
_in_memory_cdt_maxpx = 4
_px_partition_load_dist_threshold = 64
_px_adaptive_dist_bypass_optimization = 1
_optimizer_interleave_or_expansion = true
_bloom_use_crchash = BASIC
optimizer_adaptive_plans = true
optimizer_adaptive_statistics = false
_optimizer_use_feedback_for_join = false
_optimizer_ads_for_pq = false
_px_join_skewed_values_count = 0
Bug Fix Control Environment
 fix 3834770 = 1 
 fix 3746511 = enabled
 fix 4519016 = enabled
 fix 3118776 = enabled
 fix 4488689 = enabled
 fix 2194204 = disabled
 fix 2660592 = enabled
 fix 2320291 = enabled
 fix 2324795 = enabled
 fix 4308414 = enabled
 fix 3499674 = disabled
 fix 4569940 = enabled
 fix 4631959 = enabled
 fix 4519340 = enabled
 fix 4550003 = enabled
 fix 1403283 = enabled
 fix 4554846 = enabled
 fix 4602374 = enabled
 fix 4584065 = enabled
 fix 4545833 = enabled
 fix 4611850 = enabled
 fix 4663698 = enabled
 fix 4663804 = enabled
 fix 4666174 = enabled
 fix 4567767 = enabled
 fix 4556762 = 15 
 fix 4728348 = enabled
 fix 4708389 = enabled
 fix 4175830 = enabled
 fix 4752814 = enabled
 fix 4583239 = enabled
 fix 4386734 = enabled
 fix 4887636 = enabled
 fix 4483240 = enabled
 fix 4872602 = disabled
 fix 4711525 = enabled
 fix 4545802 = enabled
 fix 4605810 = enabled
 fix 4704779 = enabled
 fix 4900129 = enabled
 fix 4924149 = enabled
 fix 4663702 = enabled
 fix 4878299 = enabled
 fix 4658342 = enabled
 fix 4881533 = enabled
 fix 4676955 = enabled
 fix 4273361 = enabled
 fix 4967068 = enabled
 fix 4969880 = disabled
 fix 5005866 = enabled
 fix 5015557 = enabled
 fix 4705343 = enabled
 fix 4904838 = enabled
 fix 4716096 = enabled
 fix 4483286 = disabled
 fix 4722900 = enabled
 fix 4615392 = enabled
 fix 5096560 = enabled
 fix 5029464 = enabled
 fix 4134994 = enabled
 fix 4904890 = enabled
 fix 5104624 = enabled
 fix 5014836 = enabled
 fix 4768040 = enabled
 fix 4600710 = enabled
 fix 5129233 = enabled
 fix 4595987 = enabled
 fix 4908162 = enabled
 fix 5139520 = enabled
 fix 5084239 = enabled
 fix 5143477 = disabled
 fix 2663857 = enabled
 fix 4717546 = enabled
 fix 5240264 = disabled
 fix 5099909 = enabled
 fix 5240607 = enabled
 fix 5195882 = enabled
 fix 5220356 = enabled
 fix 5263572 = enabled
 fix 5385629 = enabled
 fix 5302124 = enabled
 fix 5391942 = enabled
 fix 5384335 = enabled
 fix 5482831 = enabled
 fix 4158812 = enabled
 fix 5387148 = enabled
 fix 5383891 = enabled
 fix 5466973 = enabled
 fix 5396162 = enabled
 fix 5394888 = enabled
 fix 5395291 = enabled
 fix 5236908 = enabled
 fix 5509293 = enabled
 fix 5449488 = enabled
 fix 5567933 = enabled
 fix 5570494 = enabled
 fix 5288623 = enabled
 fix 5505995 = enabled
 fix 5505157 = enabled
 fix 5112460 = enabled
 fix 5554865 = enabled
 fix 5112260 = enabled
 fix 5112352 = enabled
 fix 5547058 = enabled
 fix 5618040 = enabled
 fix 5585313 = enabled
 fix 5547895 = enabled
 fix 5634346 = enabled
 fix 5620485 = enabled
 fix 5483301 = enabled
 fix 5657044 = enabled
 fix 5694984 = enabled
 fix 5868490 = enabled
 fix 5650477 = enabled
 fix 5611962 = enabled
 fix 4279274 = enabled
 fix 5741121 = enabled
 fix 5714944 = enabled
 fix 5391505 = enabled
 fix 5762598 = enabled
 fix 5578791 = enabled
 fix 5259048 = enabled
 fix 5882954 = enabled
 fix 2492766 = enabled
 fix 5707608 = enabled
 fix 5891471 = enabled
 fix 5884780 = enabled
 fix 5680702 = enabled
 fix 5371452 = enabled
 fix 5838613 = enabled
 fix 5949981 = enabled
 fix 5624216 = enabled
 fix 5741044 = enabled
 fix 5976822 = enabled
 fix 6006457 = enabled
 fix 5872956 = enabled
 fix 5923644 = enabled
 fix 5943234 = enabled
 fix 5844495 = enabled
 fix 4168080 = enabled
 fix 6020579 = enabled
 fix 5842686 = disabled
 fix 5996801 = enabled
 fix 5593639 = enabled
 fix 6133948 = enabled
 fix 3151991 = enabled
 fix 6146906 = enabled
 fix 6239909 = enabled
 fix 6267621 = enabled
 fix 5909305 = enabled
 fix 6279918 = enabled
 fix 6141818 = enabled
 fix 6151963 = enabled
 fix 6251917 = enabled
 fix 6282093 = enabled
 fix 6119510 = enabled
 fix 6119382 = enabled
 fix 3801750 = enabled
 fix 5705630 = disabled
 fix 5944076 = enabled
 fix 5406763 = enabled
 fix 6070954 = enabled
 fix 6282944 = enabled
 fix 6138746 = enabled
 fix 6082745 = enabled
 fix 3426050 = enabled
 fix 599680 = enabled
 fix 6062266 = enabled
 fix 6087237 = enabled
 fix 6122894 = enabled
 fix 6377505 = enabled
 fix 5893768 = enabled
 fix 6163564 = enabled
 fix 6073325 = enabled
 fix 6188881 = enabled
 fix 6007259 = enabled
 fix 6239971 = enabled
 fix 5284200 = disabled
 fix 6042205 = enabled
 fix 6051211 = enabled
 fix 6434668 = enabled
 fix 6438752 = enabled
 fix 5936366 = enabled
 fix 6439032 = enabled
 fix 6438892 = enabled
 fix 6006300 = enabled
 fix 5947231 = enabled
 fix 5416118 = 1 
 fix 6365442 = 1 
 fix 6239039 = enabled
 fix 6502845 = enabled
 fix 6913094 = enabled
 fix 6029469 = enabled
 fix 5919513 = enabled
 fix 6057611 = enabled
 fix 6469667 = enabled
 fix 6608941 = disabled
 fix 6368066 = enabled
 fix 6329318 = enabled
 fix 6656356 = enabled
 fix 4507997 = enabled
 fix 6671155 = enabled
 fix 6694548 = enabled
 fix 6688200 = enabled
 fix 6612471 = enabled
 fix 6708183 = disabled
 fix 6326934 = enabled
 fix 6520717 = disabled
 fix 6714199 = enabled
 fix 6681545 = enabled
 fix 6748058 = enabled
 fix 6167716 = enabled
 fix 6674254 = enabled
 fix 6468287 = enabled
 fix 6503543 = enabled
 fix 6808773 = disabled
 fix 6766962 = enabled
 fix 6120483 = enabled
 fix 6670551 = enabled
 fix 6771838 = enabled
 fix 6626018 = disabled
 fix 6530596 = enabled
 fix 6778642 = enabled
 fix 6699059 = enabled
 fix 6376551 = enabled
 fix 6429113 = enabled
 fix 6782437 = enabled
 fix 6776808 = enabled
 fix 6765823 = enabled
 fix 6768660 = enabled
 fix 6782665 = enabled
 fix 6610822 = enabled
 fix 6514189 = enabled
 fix 6818410 = enabled
 fix 6827696 = enabled
 fix 6773613 = enabled
 fix 5902962 = enabled
 fix 6956212 = enabled
 fix 3056297 = enabled
 fix 6440977 = disabled
 fix 6972291 = disabled
 fix 6904146 = enabled
 fix 6221403 = enabled
 fix 5475051 = enabled
 fix 6845871 = enabled
 fix 5468809 = enabled
 fix 6917633 = enabled
 fix 4444536 = disabled
 fix 6955210 = enabled
 fix 6994194 = enabled
 fix 6399597 = disabled
 fix 6951776 = enabled
 fix 5648287 = 3 
 fix 6987082 = disabled
 fix 7132036 = enabled
 fix 6980350 = enabled
 fix 5199213 = enabled
 fix 7138405 = enabled
 fix 7148689 = enabled
 fix 6820988 = enabled
 fix 7032684 = enabled
 fix 6617866 = enabled
 fix 7155968 = enabled
 fix 7127980 = enabled
 fix 6982954 = enabled
 fix 7241819 = enabled
 fix 6897034 = enabled
 fix 7236148 = enabled
 fix 7298570 = enabled
 fix 7249095 = enabled
 fix 7314499 = enabled
 fix 7324224 = enabled
 fix 7289023 = enabled
 fix 7237571 = enabled
 fix 7116357 = enabled
 fix 7345484 = enabled
 fix 7375179 = enabled
 fix 6430500 = disabled
 fix 5897486 = enabled
 fix 6774209 = enabled
 fix 7306637 = enabled
 fix 6451322 = enabled
 fix 7208131 = enabled
 fix 7388652 = enabled
 fix 7127530 = enabled
 fix 6751206 = enabled
 fix 6669103 = enabled
 fix 7430474 = enabled
 fix 6990305 = enabled
 fix 7043307 = enabled
 fix 3120429 = enabled
 fix 7452823 = disabled
 fix 6838105 = enabled
 fix 6769711 = enabled
 fix 7170213 = enabled
 fix 6528872 = enabled
 fix 7295298 = enabled
 fix 5922070 = enabled
 fix 7259468 = enabled
 fix 6418552 = enabled
 fix 4619997 = enabled
 fix 7524366 = enabled
 fix 6942476 = enabled
 fix 6418771 = enabled
 fix 7375077 = enabled
 fix 5400639 = enabled
 fix 4570921 = enabled
 fix 7426911 = enabled
 fix 5099019 = disabled
 fix 7528216 = enabled
 fix 7521266 = enabled
 fix 7385140 = enabled
 fix 7576516 = enabled
 fix 7573526 = enabled
 fix 7576476 = enabled
 fix 7165898 = enabled
 fix 7263214 = enabled
 fix 3320140 = enabled
 fix 7555510 = enabled
 fix 7613118 = enabled
 fix 7597059 = enabled
 fix 7558911 = enabled
 fix 5520732 = enabled
 fix 7679490 = disabled
 fix 7449971 = enabled
 fix 3628118 = enabled
 fix 4370840 = enabled
 fix 7281191 = enabled
 fix 7519687 = enabled
 fix 5029592 = 3 
 fix 6012093 = 1 
 fix 6053861 = disabled
 fix 6941515 = disabled
 fix 7696414 = enabled
 fix 7272039 = enabled
 fix 7834811 = enabled
 fix 7640597 = enabled
 fix 7341616 = enabled
 fix 7168184 = enabled
 fix 399198 = enabled
 fix 7831070 = enabled
 fix 7676897 = disabled
 fix 7414637 = enabled
 fix 7585456 = enabled
 fix 8202421 = enabled
 fix 7658097 = disabled
 fix 8251486 = enabled
 fix 7132684 = enabled
 fix 7512227 = enabled
 fix 6972987 = enabled
 fix 7199035 = enabled
 fix 8243446 = enabled
 fix 7650462 = enabled
 fix 6720701 = enabled
 fix 7592673 = enabled
 fix 7718694 = enabled
 fix 7534027 = enabled
 fix 7708267 = enabled
 fix 5716785 = enabled
 fix 7356191 = enabled
 fix 7679161 = enabled
 fix 7597159 = enabled
 fix 7499258 = enabled
 fix 8328363 = enabled
 fix 7452863 = enabled
 fix 8284930 = enabled
 fix 7298626 = enabled
 fix 7657126 = enabled
 fix 8371884 = enabled
 fix 8318020 = enabled
 fix 8255423 = enabled
 fix 7135745 = enabled
 fix 8356253 = enabled
 fix 7534257 = enabled
 fix 8323407 = enabled
 fix 7539815 = enabled
 fix 8289316 = enabled
 fix 8447850 = enabled
 fix 7675944 = enabled
 fix 8355120 = enabled
 fix 7176746 = enabled
 fix 8442891 = enabled
 fix 8373261 = enabled
 fix 7679164 = enabled
 fix 7670533 = enabled
 fix 8408665 = enabled
 fix 8491399 = enabled
 fix 8348392 = enabled
 fix 8348585 = enabled
 fix 8335178 = enabled
 fix 8247017 = enabled
 fix 7325597 = enabled
 fix 8531490 = enabled
 fix 6163600 = enabled
 fix 8589278 = disabled
 fix 8557992 = enabled
 fix 7556098 = enabled
 fix 8580883 = enabled
 fix 5892599 = disabled
 fix 8609714 = enabled
 fix 8619631 = disabled
 fix 8672915 = enabled
 fix 8514561 = enabled
 fix 8213977 = enabled
 fix 8560951 = disabled
 fix 8578587 = enabled
 fix 8287870 = enabled
 fix 8467123 = enabled
 fix 8602185 = enabled
 fix 8519457 = enabled
 fix 3335182 = enabled
 fix 8602840 = enabled
 fix 8725296 = enabled
 fix 8628970 = enabled
 fix 6754080 = enabled
 fix 8767442 = enabled
 fix 8760135 = enabled
 fix 8644935 = enabled
 fix 8352378 = enabled
 fix 8685327 = enabled
 fix 8763472 = enabled
 fix 8773324 = enabled
 fix 8813674 = enabled
 fix 8532236 = enabled
 fix 8629716 = enabled
 fix 7277732 = enabled
 fix 8692170 = enabled
 fix 8900973 = enabled
 fix 8919133 = enabled
 fix 8927050 = enabled
 fix 8551880 = enabled
 fix 8901237 = enabled
 fix 8812372 = enabled
 fix 6236862 = enabled
 fix 8528517 = enabled
 fix 7215982 = enabled
 fix 8214022 = enabled
 fix 8595392 = enabled
 fix 8890233 = enabled
 fix 8999317 = enabled
 fix 9004800 = enabled
 fix 8986163 = enabled
 fix 8855396 = enabled
 fix 8800514 = 20 
 fix 9007859 = enabled
 fix 8198783 = disabled
 fix 9053879 = enabled
 fix 6086930 = enabled
 fix 7641601 = enabled
 fix 9052506 = enabled
 fix 9103775 = enabled
 fix 9047975 = enabled
 fix 8893626 = enabled
 fix 9111170 = enabled
 fix 8971829 = enabled
 fix 7628358 = enabled
 fix 9125151 = enabled
 fix 9039715 = enabled
 fix 9106224 = enabled
 fix 9185228 = enabled
 fix 9206747 = enabled
 fix 9088510 = enabled
 fix 9143856 = enabled
 fix 8833381 = enabled
 fix 8949971 = enabled
 fix 8951812 = enabled
 fix 9148171 = enabled
 fix 8706652 = enabled
 fix 9245114 = enabled
 fix 8802198 = enabled
 fix 9011016 = enabled
 fix 9265681 = enabled
 fix 7284269 = enabled
 fix 9272549 = enabled
 fix 8917507 = 7 
 fix 8531463 = enabled
 fix 9263333 = enabled
 fix 8675087 = enabled
 fix 8896955 = enabled
 fix 9041934 = enabled
 fix 9344709 = enabled
 fix 9024933 = enabled
 fix 9033718 = enabled
 fix 9240455 = enabled
 fix 9081848 = enabled
 fix 5982893 = enabled
 fix 9287401 = enabled
 fix 8590021 = enabled
 fix 9340120 = enabled
 fix 9355794 = enabled
 fix 9356656 = enabled
 fix 9385634 = enabled
 fix 9069046 = enabled
 fix 9239337 = enabled
 fix 9300228 = enabled
 fix 9298010 = enabled
 fix 9384170 = enabled
 fix 9407929 = enabled
 fix 8836806 = enabled
 fix 9344055 = enabled
 fix 9274675 = enabled
 fix 9203723 = enabled
 fix 9443476 = enabled
 fix 9195582 = enabled
 fix 8226666 = enabled
 fix 9433490 = enabled
 fix 9065494 = enabled
 fix 9303766 = enabled
 fix 9437283 = enabled
 fix 9116214 = enabled
 fix 9456688 = enabled
 fix 9456746 = disabled
 fix 9342979 = enabled
 fix 9465425 = enabled
 fix 9092442 = enabled
 fix 4926618 = enabled
 fix 8792846 = enabled
 fix 9474259 = enabled
 fix 9495669 = disabled
 fix 6472966 = enabled
 fix 6408301 = enabled
 fix 9380298 = disabled
 fix 8500130 = enabled
 fix 9584723 = enabled
 fix 9270951 = enabled
 fix 9508254 = enabled
 fix 9593680 = enabled
 fix 9196440 = disabled
 fix 9309281 = enabled
 fix 8693158 = enabled
 fix 9381638 = enabled
 fix 9383967 = enabled
 fix 7711900 = enabled
 fix 9218587 = enabled
 fix 9728438 = enabled
 fix 9038395 = enabled
 fix 9577300 = enabled
 fix 9171113 = enabled
 fix 8973745 = enabled
 fix 9732434 = enabled
 fix 8937971 = disabled
 fix 9102474 = enabled
 fix 9243499 = enabled
 fix 9791810 = enabled
 fix 9785632 = enabled
 fix 9898249 = enabled
 fix 9153459 = enabled
 fix 9680430 = enabled
 fix 9841679 = enabled
 fix 9912503 = enabled
 fix 9850461 = enabled
 fix 9762592 = 3 
 fix 9716877 = enabled
 fix 9814067 = enabled
 fix 9776736 = enabled
 fix 8349119 = enabled
 fix 9958518 = enabled
 fix 10041074 = enabled
 fix 10004943 = enabled
 fix 9980661 = enabled
 fix 9554026 = enabled
 fix 9593547 = enabled
 fix 9833381 = enabled
 fix 10043801 = enabled
 fix 9940732 = enabled
 fix 9702850 = enabled
 fix 9659125 = 0 
 fix 9668086 = enabled
 fix 9476520 = enabled
 fix 10158107 = enabled
 fix 10148457 = enabled
 fix 10106423 = enabled
 fix 9721439 = disabled
 fix 10162430 = enabled
 fix 10134677 = enabled
 fix 10182051 = 3 
 fix 10175079 = enabled
 fix 10026972 = enabled
 fix 10192889 = enabled
 fix 3566843 = enabled
 fix 9550277 = disabled
 fix 10236566 = enabled
 fix 10227392 = enabled
 fix 8961143 = enabled
 fix 9721228 = enabled
 fix 10080014 = enabled
 fix 10101489 = enabled
 fix 9929609 = enabled
 fix 10015652 = enabled
 fix 9918661 = enabled
 fix 10333395 = enabled
 fix 10336499 = disabled
 fix 10182672 = enabled
 fix 9578670 = enabled
 fix 10232225 = enabled
 fix 10330090 = enabled
 fix 10232623 = enabled
 fix 9630092 = disabled
 fix 10271790 = enabled
 fix 9227576 = enabled
 fix 10197666 = enabled
 fix 10376744 = enabled
 fix 8274946 = enabled
 fix 10046368 = enabled
 fix 9569678 = enabled
 fix 9002661 = enabled
 fix 10038373 = enabled
 fix 9477688 = enabled
 fix 10013899 = enabled
 fix 9832338 = enabled
 fix 10623119 = enabled
 fix 9898066 = enabled
 fix 11699884 = enabled
 fix 10640430 = enabled
 fix 10428450 = enabled
 fix 10117760 = enabled
 fix 11720178 = enabled
 fix 9881812 = enabled
 fix 10428278 = enabled
 fix 11741436 = enabled
 fix 11668189 = enabled
 fix 10359631 = enabled
 fix 9829887 = enabled
 fix 8275054 = enabled
 fix 11814428 = enabled
 fix 11676888 = disabled
 fix 10348427 = enabled
 fix 11843512 = enabled
 fix 11657468 = enabled
 fix 11877160 = enabled
 fix 11738631 = enabled
 fix 11744086 = enabled
 fix 11830663 = enabled
 fix 11853331 = enabled
 fix 9748015 = enabled
 fix 11834739 = enabled
 fix 6055658 = enabled
 fix 11740670 = enabled
 fix 11940126 = enabled
 fix 12315002 = enabled
 fix 8275023 = enabled
 fix 12352373 = enabled
 fix 12390139 = enabled
 fix 11935589 = enabled
 fix 10226906 = enabled
 fix 12327548 = enabled
 fix 12388221 = enabled
 fix 11892888 = enabled
 fix 11814265 = enabled
 fix 10230017 = enabled
 fix 12341619 = enabled
 fix 11744016 = enabled
 fix 10216738 = enabled
 fix 10298302 = enabled
 fix 12563419 = enabled
 fix 12399886 = enabled
 fix 12584007 = enabled
 fix 11881047 = enabled
 fix 12534597 = enabled
 fix 8683604 = enabled
 fix 12410972 = enabled
 fix 7147087 = enabled
 fix 11846314 = enabled
 fix 12535474 = enabled
 fix 12561635 = enabled
 fix 12432426 = enabled
 fix 9913117 = enabled
 fix 12432089 = enabled
 fix 12587690 = enabled
 fix 11858963 = enabled
 fix 12569245 = enabled
 fix 12569300 = enabled
 fix 7308975 = disabled
 fix 12569316 = enabled
 fix 12569321 = enabled
 fix 12335617 = enabled
 fix 9002958 = enabled
 fix 12591120 = enabled
 fix 11876260 = enabled
 fix 12313574 = enabled
 fix 12569713 = enabled
 fix 12348584 = enabled
 fix 10420220 = enabled
 fix 12559453 = enabled
 fix 12727549 = enabled
 fix 12728203 = enabled
 fix 12828479 = enabled
 fix 10181153 = enabled
 fix 9971371 = disabled
 fix 12864791 = enabled
 fix 12810427 = enabled
 fix 12605402 = enabled
 fix 12861609 = enabled
 fix 12915337 = enabled
 fix 12942119 = enabled
 fix 12622441 = enabled
 fix 11072246 = enabled
 fix 12739252 = enabled
 fix 12953765 = enabled
 fix 12905116 = enabled
 fix 12978495 = enabled
 fix 9633142 = disabled
 fix 3639130 = enabled
 fix 12827166 = enabled
 fix 12944193 = enabled
 fix 13020272 = enabled
 fix 12673320 = enabled
 fix 12975771 = enabled
 fix 12882092 = enabled
 fix 12379334 = enabled
 fix 12723414 = enabled
 fix 9488694 = disabled
 fix 13255388 = 10 
 fix 11727871 = enabled
 fix 13110511 = enabled
 fix 13075297 = enabled
 fix 13345888 = enabled
 fix 11657903 = disabled
 fix 13396096 = enabled
 fix 12591379 = enabled
 fix 13398214 = enabled
 fix 13382280 = enabled
 fix 12869367 = enabled
 fix 12999577 = enabled
 fix 12433153 = enabled
 fix 9094254 = enabled
 fix 13104618 = enabled
 fix 13524237 = enabled
 fix 11813257 = enabled
 fix 13489017 = enabled
 fix 12954320 = enabled
 fix 13555551 = enabled
 fix 13499154 = enabled
 fix 13036910 = enabled
 fix 13545925 = enabled
 fix 13545956 = enabled
 fix 13545989 = enabled
 fix 12839247 = enabled
 fix 9858777 = enabled
 fix 13568366 = enabled
 fix 13393357 = enabled
 fix 13040171 = enabled
 fix 13406619 = enabled
 fix 13594757 = enabled
 fix 13543207 = enabled
 fix 13594712 = enabled
 fix 12648629 = enabled
 fix 13549808 = enabled
 fix 13634700 = enabled
 fix 8792821 = enabled
 fix 13454409 = enabled
 fix 13146487 = enabled
 fix 13592248 = enabled
 fix 11689541 = enabled
 fix 13527374 = enabled
 fix 13430622 = enabled
 fix 13704562 = enabled
 fix 9547706 = enabled
 fix 13497184 = enabled
 fix 13704977 = enabled
 fix 13734456 = enabled
 fix 13070532 = enabled
 fix 6520878 = enabled
 fix 2273284 = enabled
 fix 13786127 = enabled
 fix 13065064 = enabled
 fix 13972896 = enabled
 fix 11843466 = enabled
 fix 13777823 = enabled
 fix 13616573 = enabled
 fix 13831671 = enabled
 fix 13652216 = enabled
 fix 13912192 = enabled
 fix 13909909 = enabled
 fix 13849486 = enabled
 fix 13321547 = enabled
 fix 13886606 = disabled
 fix 14013502 = enabled
 fix 13850256 = enabled
 fix 13929275 = enabled
 fix 11732303 = enabled
 fix 13906168 = enabled
 fix 14055128 = enabled
 fix 12856200 = enabled
 fix 14008590 = enabled
 fix 13627489 = disabled
 fix 13961105 = enabled
 fix 13583722 = enabled
 fix 13076238 = enabled
 fix 13936229 = enabled
 fix 9852856 = enabled
 fix 3904125 = enabled
 fix 5910187 = enabled
 fix 10068316 = enabled
 fix 14029891 = enabled
 fix 4215125 = enabled
 fix 13711083 = enabled
 fix 13973691 = enabled
 fix 13486825 = enabled
 fix 13682550 = enabled
 fix 13826669 = enabled
 fix 14033181 = enabled
 fix 13836796 = enabled
 fix 12555499 = enabled
 fix 13568506 = enabled
 fix 9891396 = enabled
 fix 13699643 = enabled
 fix 13835788 = enabled
 fix 7271518 = enabled
 fix 14127824 = enabled
 fix 12557401 = enabled
 fix 13350470 = enabled
 fix 14095362 = enabled
 fix 13000118 = enabled
 fix 14254795 = enabled
 fix 14012261 = enabled
 fix 14241953 = enabled
 fix 14221012 = enabled
 fix 13329748 = enabled
 fix 13843964 = enabled
 fix 14254052 = enabled
 fix 13814866 = enabled
 fix 14255600 = disabled
 fix 13735304 = enabled
 fix 14142884 = disabled
 fix 12909121 = enabled
 fix 14464068 = enabled
 fix 14295250 = 45000 
 fix 6873091 = enabled
 fix 13448445 = enabled
 fix 14155722 = enabled
 fix 14098180 = enabled
 fix 11905801 = enabled
 fix 14467202 = enabled
 fix 14541122 = enabled
 fix 13905599 = disabled
 fix 14320077 = enabled
 fix 14243782 = enabled
 fix 9114915 = enabled
 fix 14516175 = enabled
 fix 12812697 = enabled
 fix 13109345 = enabled
 fix 14456124 = enabled
 fix 14605040 = enabled
 fix 14595273 = disabled
 fix 14176247 = enabled
 fix 11894476 = enabled
 fix 14256885 = enabled
 fix 14545269 = disabled
 fix 14668404 = disabled
 fix 14144611 = enabled
 fix 14346182 = enabled
 fix 13083139 = enabled
 fix 14726188 = enabled
 fix 14707009 = enabled
 fix 14703133 = enabled
 fix 14618560 = enabled
 fix 14170552 = enabled
 fix 13263174 = enabled
 fix 14669785 = enabled
 fix 14633570 = enabled
 fix 14755138 = enabled
 fix 14682092 = enabled
 fix 14712222 = enabled
 fix 14570575 = enabled
 fix 14707748 = disabled
 fix 14684079 = enabled
 fix 13245379 = enabled
 fix 13853916 = enabled
 fix 13699007 = enabled
 fix 14843189 = enabled
 fix 14147762 = enabled
 fix 14795969 = enabled
 fix 14746036 = 1 
 fix 14750501 = enabled
 fix 13891981 = enabled
 fix 15996520 = enabled
 fix 16026776 = enabled
 fix 13573073 = enabled
 fix 13263455 = enabled
 fix 16053273 = enabled
 fix 16029607 = enabled
 fix 14242833 = enabled
 fix 13362020 = enabled
 fix 13799389 = enabled
 fix 12693573 = enabled
 fix 15998585 = enabled
 fix 16166364 = enabled
 fix 14723910 = enabled
 fix 15873008 = enabled
 fix 14133928 = enabled
 fix 16085999 = enabled
 fix 14176203 = enabled
 fix 16226575 = enabled
 fix 16015637 = enabled
 fix 15968693 = disabled
 fix 16220895 = enabled
 fix 16178821 = enabled
 fix 11865196 = enabled
 fix 16237969 = enabled
 fix 16058481 = enabled
 fix 13361493 = enabled
 fix 16264537 = enabled
 fix 14401107 = enabled
 fix 13943459 = enabled
 fix 13994546 = enabled
 fix 7174435 = enabled
 fix 14750443 = enabled
 fix 14469756 = enabled
 fix 14552075 = enabled
 fix 16324844 = enabled
 fix 13583529 = enabled
 fix 14565911 = enabled
 fix 13526551 = enabled
 fix 16368002 = enabled
 fix 16077770 = enabled
 fix 16419357 = enabled
 fix 15889476 = disabled
 fix 16273483 = enabled
 fix 16496848 = disabled
 fix 14107333 = enabled
 fix 11814337 = enabled
 fix 15882436 = enabled
 fix 14764840 = enabled
 fix 16226660 = enabled
 fix 16555865 = enabled
 fix 16625151 = enabled
 fix 16092378 = enabled
 fix 16487030 = enabled
 fix 9552303 = enabled
 fix 16609749 = enabled
 fix 16751246 = enabled
 fix 13253977 = enabled
 fix 14058291 = disabled
 fix 16749025 = enabled
 fix 16750067 = enabled
 fix 16726844 = enabled
 fix 15899648 = enabled
 fix 16690013 = enabled
 fix 15996156 = enabled
 fix 16544878 = enabled
 fix 9413591 = disabled
 fix 16792882 = 0 
 fix 16725982 = enabled
 fix 14648222 = enabled
 fix 16799181 = enabled
 fix 16516883 = enabled
 fix 16507317 = enabled
 fix 16837274 = enabled
 fix 14085520 = enabled
 fix 16713081 = enabled
 fix 14703295 = enabled
 fix 16908409 = enabled
 fix 16212250 = enabled
 fix 13692395 = disabled
 fix 17087729 = enabled
 fix 17088819 = enabled
 fix 13848786 = enabled
 fix 13522189 = enabled
 fix 16400122 = enabled
 fix 16796185 = enabled
 fix 15950252 = enabled
 fix 17070464 = enabled
 fix 16976121 = enabled
 fix 14580303 = enabled
 fix 16554552 = enabled
 fix 16582322 = enabled
 fix 16712213 = enabled
 fix 17382690 = enabled
 fix 14846352 = enabled
 fix 16516751 = enabled
 fix 3174223 = enabled
 fix 8611462 = enabled
 fix 14851437 = 3 
 fix 17348895 = enabled
 fix 16515789 = enabled
 fix 5451645 = disabled
 fix 14062749 = enabled
 fix 16346018 = enabled
 fix 12977599 = enabled
 fix 14191778 = enabled
 fix 15939321 = enabled
 fix 16874299 = enabled
 fix 16470836 = enabled
 fix 16805362 = disabled
 fix 17442009 = disabled
 fix 16825679 = enabled
 fix 17543180 = enabled
 fix 17301564 = enabled
 fix 12373708 = enabled
 fix 17397506 = enabled
 fix 14558315 = enabled
 fix 16615686 = enabled
 fix 16622801 = enabled
 fix 10038517 = enabled
 fix 16954950 = enabled
 fix 17728161 = enabled
 fix 17760375 = enabled
 fix 14311185 = enabled
 fix 13077335 = disabled
 fix 13458979 = disabled
 fix 17485514 = enabled
 fix 17599514 = enabled
 fix 17640863 = enabled
 fix 17716301 = enabled
 fix 17368047 = disabled
 fix 17597748 = enabled
 fix 17303359 = enabled
 fix 17376322 = disabled
 fix 16391176 = disabled
 fix 16673868 = enabled
 fix 17800514 = enabled
 fix 14826303 = enabled
 fix 17663076 = enabled
 fix 17760755 = enabled
 fix 17793460 = enabled
 fix 17997159 = enabled
 fix 17938754 = enabled
 fix 14733442 = enabled
 fix 17727676 = enabled
 fix 17781659 = enabled
 fix 17526569 = enabled
 fix 17950612 = enabled
 fix 17760686 = enabled
 fix 17696414 = enabled
 fix 17799716 = enabled
 fix 18116777 = enabled
 fix 18159664 = disabled
 fix 16052625 = enabled
 fix 18091750 = enabled
 fix 17572606 = enabled
 fix 17971955 = enabled
 fix 17946915 = enabled
 fix 18196576 = enabled
 fix 10145667 = enabled
 fix 17736165 = enabled
 fix 16434021 = enabled
 fix 18035463 = enabled
 fix 18011820 = enabled
 fix 16405740 = enabled
 fix 14612201 = enabled
 fix 17491018 = enabled
 fix 18365267 = enabled
 fix 17986549 = enabled
 fix 18115594 = enabled
 fix 18182018 = enabled
 fix 18302923 = enabled
 fix 18377553 = enabled
 fix 5677419 = enabled
 fix 17896018 = disabled
 fix 13097308 = enabled
 fix 17863980 = enabled
 fix 17567154 = enabled
 fix 18398980 = enabled
 fix 17023040 = enabled
 fix 17991403 = 1 
 fix 16033838 = enabled
 fix 17908541 = enabled
 fix 18134680 = enabled
 fix 18405517 = 0 
 fix 18304693 = enabled
 fix 18456944 = enabled
 fix 18467455 = enabled
 fix 18425876 = enabled
 fix 18508675 = enabled
 fix 17473046 = disabled
 fix 18636079 = enabled
 fix 18388128 = enabled
 fix 18415557 = enabled
 fix 18385778 = enabled
 fix 18308329 = enabled
 fix 18461984 = enabled
 fix 17973658 = enabled
 fix 18558952 = enabled
 fix 9912950 = enabled
 fix 18751128 = enabled
 fix 16809786 = enabled
 fix 18795224 = enabled
 fix 14776289 = enabled
 fix 18823135 = enabled
 fix 18874242 = enabled
 fix 18770199 = disabled
 fix 4185270 = disabled
 fix 18765574 = enabled
 fix 18754357 = disabled
 fix 18959892 = enabled
 fix 17324379 = disabled
 fix 18952882 = enabled
 fix 18924221 = enabled
 fix 18422714 = enabled
 fix 18798414 = enabled
 fix 18969167 = enabled
 fix 16191689 = enabled
 fix 18907562 = enabled
 fix 19055664 = enabled
 fix 18898582 = enabled
 fix 18960760 = enabled
 fix 19070454 = enabled
 fix 19230097 = enabled
 fix 19063497 = enabled
 fix 19046459 = enabled
 fix 19269482 = enabled
 fix 18876528 = enabled
 fix 19227996 = enabled
 fix 18864613 = enabled
 fix 19239478 = enabled
 fix 19451895 = enabled
 fix 19450139 = enabled
 fix 18907390 = enabled
 fix 19025959 = enabled
 fix 19309574 = enabled
 fix 16774698 = enabled
 fix 16923858 = 6 
 fix 19546825 = enabled
 fix 19475484 = enabled
 fix 19498595 = enabled
 fix 16934526 = enabled
 fix 19287919 = enabled
 fix 19386746 = enabled
 fix 19774486 = enabled
 fix 19803410 = enabled
 fix 18671960 = enabled
 fix 19484911 = enabled
 fix 19731940 = enabled
 fix 19604408 = enabled
 fix 14402409 = enabled
 fix 16486095 = enabled
 fix 19563657 = enabled
 fix 19632232 = enabled
 fix 19889960 = enabled
 fix 17208933 = enabled
 fix 19710102 = enabled
 fix 18697515 = enabled
 fix 18318631 = enabled
 fix 19377983 = enabled
 fix 20078639 = enabled
 fix 19503668 = enabled
 fix 20124288 = enabled
 fix 19847091 = enabled
 fix 12989345 = enabled
 fix 12618642 = enabled
 fix 19779920 = enabled
 fix 20186282 = enabled
 fix 20186295 = enabled
 fix 19563433 = enabled
 fix 19848804 = enabled
 fix 20046257 = enabled
 fix 20265690 = enabled
 fix 16047938 = enabled
 fix 19507904 = enabled
 fix 18915345 = enabled
 fix 20173686 = disabled
 fix 20329321 = enabled
 fix 20225191 = enabled
 fix 18776755 = enabled
 fix 19882842 = enabled
 fix 20010996 = enabled
 fix 20445764 = disabled
 fix 19728543 = disabled
 fix 20379571 = enabled
 fix 20129763 = enabled
 fix 19899588 = enabled
 fix 10098852 = enabled
 fix 19663421 = enabled
 fix 20355502 = 0 
 fix 20526705 = enabled
 fix 20465582 = enabled
 fix 20581886 = disabled
 fix 16732417 = enabled
 fix 20732410 = enabled
 fix 20289688 = enabled
 fix 20543684 = enabled
 fix 20636003 = enabled
 fix 20506136 = enabled
 fix 20458598 = disabled
 fix 20830312 = enabled
 fix 19768896 = enabled
 fix 20321661 = enabled
 fix 19814541 = enabled
 fix 20933264 = enabled
 fix 17443547 = enabled
 fix 20602794 = enabled
 fix 19123152 = enabled
 fix 19899833 = enabled
 fix 20754928 = enabled
 fix 20808265 = enabled
 fix 20808192 = enabled
 fix 20340595 = enabled
 fix 14474264 = disabled
 fix 20508819 = enabled
 fix 21098866 = disabled
 fix 18949550 = enabled
 fix 14775297 = enabled
 fix 19568958 = disabled
 fix 20923950 = enabled
 fix 21283159 = enabled
 fix 17497847 = enabled
 fix 21211629 = enabled
 fix 20819668 = disabled
 fix 20232513 = enabled
 fix 20906782 = enabled
 fix 20587527 = enabled
 fix 20914534 = disabled
 fix 20830544 = enabled
 fix 16851194 = enabled
 fix 19186783 = enabled
 fix 19653920 = enabled
 fix 21211786 = enabled
 fix 21057343 = enabled
 fix 21503478 = enabled
 fix 19808939 = disabled
 fix 21476032 = enabled
 fix 20859246 = enabled
 fix 20838633 = 2 
 fix 21639419 = enabled
 fix 20951803 = enabled
 fix 21683982 = enabled
 fix 20216500 = enabled
 fix 21614112 = enabled
 fix 20906162 = enabled
 fix 20854798 = enabled
 fix 21509656 = enabled
 fix 21833220 = enabled
 fix 21802552 = enabled
 fix 21452843 = enabled
 fix 21553593 = enabled
 fix 21093805 = enabled
 fix 16220085 = disabled
 fix 21800590 = enabled
 fix 21273039 = enabled
 fix 16750133 = enabled
 fix 22013607 = enabled
 fix 22152372 = enabled
 fix 22077191 = enabled
 fix 22123025 = enabled
 fix 16913734 = enabled
 fix 8357294 = enabled
 fix 12670904 = enabled
 fix 21979983 = enabled
 fix 22158526 = enabled
 fix 21971099 = enabled
 fix 22090662 = enabled
 fix 22149010 = disabled
 fix 21300129 = enabled
 fix 21339278 = enabled
 fix 20270511 = enabled
 fix 21424812 = enabled
 fix 22114090 = enabled
 fix 22310074 = disabled
 fix 22159570 = enabled
 fix 22272439 = enabled
 fix 22372694 = enabled
 fix 22514195 = enabled
 fix 20413540 = enabled
 fix 22520315 = enabled
 fix 22649054 = enabled
 fix 8617254 = enabled
 fix 22020067 = enabled
 fix 22864730 = enabled
 fix 21099502 = enabled
 fix 22904304 = enabled
 fix 22967807 = enabled
 fix 22879002 = enabled
 fix 23019286 = enabled
 fix 22760704 = enabled
 fix 20853506 = enabled
 fix 22540411 = disabled
 fix 22513493 = enabled
 fix 22518491 = enabled
 fix 23103096 = enabled
 fix 22143411 = enabled
 fix 23180670 = enabled
 fix 23002609 = enabled
 fix 22928015 = 1 
 fix 23210039 = enabled
 fix 23102649 = enabled
 fix 23071621 = enabled
 fix 22822245 = enabled
 fix 23136865 = enabled
 fix 22463839 = disabled
 fix 23176721 = enabled
 fix 23308385 = enabled
 fix 23223113 = enabled
 fix 22301868 = disabled
 fix 22258300 = enabled
 fix 22205301 = enabled
 fix 23514473 = 1 
 fix 23556483 = enabled
 fix 21305617 = enabled
 fix 22533539 = enabled
 fix 23596611 = enabled
 fix 23853877 = disabled
 fix 20347374 = disabled
 fix 22937293 = enabled
 fix 20228468 = disabled
 fix 23565188 = enabled
 fix 22393169 = enabled
 fix 24654471 = enabled
 fix 24845754 = enabled
 fix 25058954 = enabled
 fix 23146876 = disabled




Query Block Registry:
SEL$1 0x6bfd6f68 (PARSER) [FINAL]

:
 call(in-use=12072, alloc=65656), compile(in-use=161568, alloc=223424), execution(in-use=7392, alloc=8088)

End of Optimizer State Dump
Dumping Hints
=============
====================== END SQL Statement Dump ======================