Managing Runaway SQL Statements on Autonomous Data Warehouse ….

Consumer Group is categorized into:- 1.. High: The High database service provides the highest level of resources to each SQL statement resulting in the highest performance, but supports the fewest number of concurrent SQL statements. Any SQL statement in this service can use all the CPU and IO resources in your database. The number of concurrent … Continue reading Managing Runaway SQL Statements on Autonomous Data Warehouse ….

Connection Autonomous Database Warehouse with SQL Developer 18.3

Prerequisite:- 1..  SQL Developer 18.2 or later (In this case I am using 18.3) 2.. Client Credentials wallet 3.. Admin Password as you have set 4.. Download and invoke sqldeveloper.exe 5.. Click on + or Click New Database Connection 6 Enter given below information as you have retrieved:- Connection Name: Enter the name for this … Continue reading Connection Autonomous Database Warehouse with SQL Developer 18.3

Concurrent Request Log Files Contain Old Record For Other Requests And Appended With New Record

Scenerio:- When any type of concurrent requests or active user request were submitted, concurrent request log contains information for other requests which were executed before and appended with new log information. Application release :- 12.1.3 Database version :- 11.2.0.3 Cause :- The database has been restored several times while file system remain unchanged. The database restore … Continue reading Concurrent Request Log Files Contain Old Record For Other Requests And Appended With New Record

Attaching Block Volume Storage in Oracle Cloud Infrastructure Instance #OCI #OracleCloud

1.. First from OCI console add Block Volume Storage as follows 1.1 .. Go to Block Storage –> Click Block Volume --> Create Block Volume 2.. Fill Block Volume Storage information as follows and click Create Block Volume tab 3.. Once Block Volume is created go to Instance Tab 3.1 Click Attach Volume 3.2 Fill the … Continue reading Attaching Block Volume Storage in Oracle Cloud Infrastructure Instance #OCI #OracleCloud