Skip to Main Content

Infrastructure Software

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!

Create ORACLE instance Error (Always Free Account) Please Help me.

Orr888Mar 6 2022

I removed my "VM.Standard.A1.Flex" instance to re-create it, but I get the error:
###########################################################
oci_core_instance.generated_oci_core_instance
Error: 500-InternalError
Provider version: 4.66.0, released on 2022-03-02.
Service: Core Instance
Error Message: Out of host capacity.
OPC request ID: 7203c6124c2445990f6b26ef0f43f549/1FB323576CB619AA266C2EFC4BB5D00E/845831335171E98F4ED9C9700EAD993A
Suggestion: The service for this resource encountered an error. Please contact support for help with service: Core Instance
###########################################################
But I did not exceed "Always free" parameters for creating instance.
Please help me solve the problem.

Comments

i don't see that behavior, also on 4.1.3

monitor_session_query.jpg

Buntoro

Hi Jeff,

It seems to be program specific problem.

We have an old ETL Tools called Sagent and it seems all queries fired from that tool are coming in this one-line format.

Notice the horizontal scroll bar at the bottom.

Please don't mind the Master layout of the Session Monitor, which I adjust to be more informational with Gauge Bar and so on.

pastedImage_2.png

For the time being, I need to open another worksheet, copy and paste that line and use Ctrl + F7 to re-format.

pastedImage_4.png

Thank you for clarifying.

Regards,

Buntoro

Buntoro

Hi Jeff,

On second thought.

I need to unmark as correct.

Probably this problem happened on DML command (insert / update / delete) only.

Here is another example, query coming from user tool (PL/SQL Developer).

pastedImage_0.png

I try to dig into the query for "Active SQL" and try to execute it myself on worksheet.

Notice the SID = 2024 which I get from the above.

I thought that it will return one line, which justify why SQL Dev show single line output.

However, as you can see it is not.

pastedImage_1.png

The question still hold.

Regards,

Buntoro

you customized the report...does it do this on the original Tools > Monitor Session screen?

Buntoro

I copy the Report from the Template (All Reports - Data Dictionary Reports - Database Administration - Sessions - Sessions).

And paste it under User Defined Reports, and name it Session Browser instead.

Every time I open Tools - Monitor Sessions, it seems to be pointing out to the User Defined Reports - Session Browser (the one that I modified).

Regards,

Buntoro

thatJeffSmith-Oracle

what's the sql behind your report? compare it to mine in the screenshot up top

tools > monitor sessions going to your custom report...that would be weird. maybe something else is happening

Buntoro

Hi Jeff,

Mine is :

select replace(q.SQL_TEXT, chr(0), chr(10) || chr(13)) sql_text

  from gv$session s, v$sqltext_with_newlines q

where  s.sql_address = q.address

  and  s.sql_hash_value = q.hash_value

  and  s.sid = :SID

order by q.piece

I also tried yours too. But on detail tab produces the same result.

select replace(q.SQL_FULLTEXT,chr(0)) sql_text

  from gv$session s, gv$sql q

where  s.sql_address = q.address

  and  s.sql_hash_value = q.hash_value

  and  s.sid = :SID

FYI, if executed on Worksheet

My query will produce multiple rows result

Your query will produce single line result

Nevertheless, both produce the same single line output on Detail tab.

Regards,

Buntoro

1 - 7

Post Details

Added on Mar 6 2022
0 comments
216 views