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!

Simple insert into table hanging

AParmNov 10 2016 — edited Nov 11 2016

Hi there,

I have a query that joins 2 tables, 1 table has 2 million records and other 1 million records, the query returns 1 record in less than 1 second, both the 2 tables being joined are accessed across a database link, despite the query running in less than a second, if I do a simple insert using the query it just hangs, and I don't understand why. The table is not locked, I have tried dropping the table before the insert and recreating it, to ensure there are no locks.

If I look at the wait events all  I a can see this

I am running 12c on Windows, the database link is to database in another pluggable database in the same container.

SQL*Net message from dblink
This post has been answered by AParm on Nov 11 2016
Jump to Answer

Comments

thatJeffSmith-Oracle

ORDS will always generate lowercase attributes. If you want to enforce case, you'll need to generate the JSON in your handler block and return that, and tell ORDS you're dealing with JSON so it doesn't try to turn your JSON...into JSON.

1 person found this helpful
User_KYPIT

Can you please try to give some example.

thatJeffSmith-Oracle

ORDS: How to Return RAW JSON Content for Your REST APIs (0 Bytes)
Hierarchical JSON with Stew Ashton & ORDS REST APIs (0 Bytes)

Olafur T

Also,
Try creating a single item GET service with

select json_arrayagg(json_object('TYPE' :object_type, 'NAME' :object_name, 'STATUS' :status)) as "{}items"
  from all_objects o
where owner = 'ORDS_METADATA'
fetch next 20 rows only
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 9 2016
Added on Nov 10 2016
#general-database-discussions
40 comments
25,036 views