Month: October 2020

Create sql profile and move sql profile from one database to another(part 2)

In part 1http://parwezexa.com/create-sql-profile-and-move-sql-profile-from-one-database-to-anotherpart-1/ , we have created a sql profile and demonstrated how the query was taking the effective plan path after using the sql profile . In this part we will create a staging […]

509 total views

Create sql profile and move sql profile from one database to another (part 1)

SQL Profile is a collection of information stored in the data dictionary that enables the query optimizer to create an optimal execution plan for a SQL statement.The SQL profile contains corrections for poor optimizer estimates […]

514 total views

ExaCC: GI 18C upgrade precheck at the error ‘ERROR: Patch num not specified correctly’ While Upgrading GI home to 18c from 12c

I am writing this article regrading one issue I encountered while upgrading the grid home 12c to 18c in ExaCC gen 1 cloud. The patch pre check was failing saying “ERROR: Patch num not specified […]

444 total views