Hi,
I created a view using 'SELECT * FROM GET_VIEWS()' query and I am able to retrieve the view names and information about the view such as the user created, the folder of the view etc.,by executing this view. If I would like to get only from specific folder, I would use a 'Where condition' to match the 'folder' column to the respective folder.
The error mentioned in question occurs when the Oracle database receives many requests in short duration and the listener goes to 'Blocked' state. In order to solve this, I would optimize my connection pool to have enough connections open to Oracle and also increase the maximum number of connections Oracle can accept.
If you are using Oracle for Cache, you can modify the Connection Pool configuration under 'Administration > Server Configuration > Cache > Connection > Connection Pool Configuration'
If you still face issues and if you are a customer with valid support user, you could raise a ticket so that our support team can help you.
Hope this helps!