Exam 1z0-908 topic 1 question 70 discussion

Actual exam question from Oracle's 1z0-908

Question #: 70
Topic #: 1

You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?

A. user_variables_by_thread
B. global_variables
C. variables_by_thread
D. session_variables

Show Suggested Answer

Suggested Answer: C 🗳️

by Dhanushka at July 30, 2023, 2:53 p.m.

Comments

Submit Cancel

FelipeK

8 months ago

Selected Answer: C

root@localhost[shop]> select * from performance_schema.variables_by_thread where VARIABLE_NAME='sort_buffer_size'; +-----------+------------------+----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+------------------+----------------+ | 66 | sort_buffer_size | 262144 | | 67 | sort_buffer_size | 262144 | +-----------+------------------+----------------+ 2 rows in set (0.00 sec)

upvoted 2 times

...

Dhanushka

1 year ago

Selected Answer: C

variables_by_thread: Session system variables for each active session. An application that wants to know the session variable values for specific sessions should use this table. It includes session variables only, identified by thread ID.

upvoted 3 times

...