Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Profile stopped working - new one doesn't work

R o bJun 26 2014 — edited Jul 1 2014

Hi,

I'm looking for some general hints and ideas.

A 3rd party application creates a long running Insert statement. The software vendor recommended to work around the issue but setting up a SQL profile and provided a few screenshots on how to do it.

We created a SQL Profile (EM 12c, Oracle 11.2.0.3, 64bit AIX) and it did the trick (for about 2 months).

Suddenly (last week) the issue reappaered. We tried to implent the SQL profile again but it has no effect. We tried a couple of times - INSERT still long running (> 5-20min). It should be executed in less than 1 min.

We can see that the INSERT in question is executed with the SQL profile.

We do not know why the issue is back (no software update, no (obvoius) changes in database) nor do we know why reimplementing the SQL profile doesn't help.

On a different Oracle database (11.2.0.1, W2008R2 - but with less schemas) the issue does not occur at all.

Additional information:

When we implented the SQL profile the first time we had some issues getting it done. Somehow my colleague mentioned to set it up. Unfortunately he can't remeber in detail what he did differently.

The SQL statement in question is:

insert into mdsys.sdo_geom_metadata_table(sdo_OWNER, sdo_table_name, sdo_column_name, sdo_DIMINFO, sdo_SRID) select 'ROBERT_TEST2', s.synonym_name, m.column_name, m.DIMINFO, m.SRID from all_sdo_geom_metadata m, all_synonyms s where m.owner=s.table_owner and m.TABLE_NAME = s.TABLE_NAME and s.owner='ROBERT_TEST2'

Many thanks, Rob

Comments

top.gun

See the following:

Oracle Database Software Downloads | Oracle Technology Network | Oracle

Previous Database Release Software

Oracle Database 10.2 and 11.1 are no longer available for download. The software is available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition. To request access to these releases, follow the instructions in Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media) from My Oracle Support. NOTE: for Oracle Database 10.2, you should request 10.2.0.1 even if you want to install a later patch set. Once you install 10.2.0.1 you can then apply any 10.2 patch set. Similarly, for 11.1 request 11.1.0.6 which must be applied before installing 11.1.0.7. Patch sets can be downloaded from the Patches and Updates tab on My Oracle Support.

user10686033

When I go to

edelivery.oracle.com

and do a search with 10.2.0.5

I only get

Enterprise Manager Grid Control 10.2.0.5.0

Dude!

Oracle 10g database is no longer available from any legal or public Oracle sources. You have to contact Oracle sales or support.

Zoltan Kecskemethy

See e.g. this old thread

Also 10.2.0.x is not supported on Linux 6 - so likely getting hold of the media will be the easy part ;-)

Rasheed_

Directly you cannot start 10g installation on rhel 6 , before install

Edit the "/etc/redhat-release" file replacing the current release information (Red Hat Enterprise Linux Server release 6 ) with the following:

redhat-4

After installation you can reset it back .(Its just for skipping installer version check skip)

Srini Chavali-Oracle 
Rasheed_ wrote:




Directly you cannot start 10g installation on rhel 6 , before install




Edit the "/etc/redhat-release" file replacing the current release information (Red Hat Enterprise Linux Server release 6 ) with the following:


redhat-4




After installation you can reset it back .(Its just for skipping installer version check skip)

Can you point to a doc where this is the supported method ?

Rasheed_

Workaround #2: On Oracle Linux 5 and Red Hat Enterprise Linux 5, the installation will pass the operating system prerequisite checks if you change each Oracle Linux 5 and Red Hat Enterprise Linux 5 to Oracle Linux 4 and Red Hat Enterprise Linux 4 in the /etc/redhat-release file. Ensure that you replace the original values in the /etc/redhat-release file after the Oracle installation is complete.



From below oracle doc link


https://docs.oracle.com/cd/B19306_01/relnotes.102/b15659/toc.htm

Dude!

That applies to EL 5, but not EL 6. EL 6 is way too far ahead regarding software per-requisites. I'm not saying it cannot be done, but it is not supported and has a few other challenges. Perhaps in the case of the OP, the best way is to run 10g under EL 6 inside VirtualBox using OL 5.

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 29 2014
Added on Jun 26 2014
#general-database-discussions
6 comments
3,218 views