Exadata General (MOSC)

MOSC Banner

query on global views hangs in database on exadata

edited Jan 17, 2016 10:00AM in Exadata General (MOSC) 2 commentsAnswered

Hi,

Any query on global views gv$ or related views hangs in Exadata database.

On all nodes, the following porcess taking lot of CPU:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

31168 oracle 20 0 109g 31m 6240 S 93.0 0.0 8851:30 oracle

2170 oracle 20 0 109g 20m 17m S 11.3 0.0 11:34.35 oracle

94337 oracle 20 0 109g 75m 37m S 11.3 0.0 13:18.86 oracle

orp722a1@pr01db01-/home/oracle: ps -ef|grep 31168

oracle 31168 1 8 2015 ? 6-03:31:44 ora_lmd0_orp722a1

Best regards,

Vishal

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center