Grep recursive solaris12/14/2023 > done | sqlplus -s "$constring" 2>&1 | tee -a $fname | grep -i "dropped" | wc -l | while read num_processed &1 | tee -a $fname | /usr/gnu/bin/grep -i "dropped" | wc -l | while read num_processed I’m going to assume the clue is in the error and increase the PGA aggregate limit SQL> alter system set pga_aggregate_limit=36G scope=both sid='*' Īfter this change, the script ran to the end successfully. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Īdvanced Analytics and Real Application Testing optionsįATAL : 2018.05.15-14:37:40 : f_setup: Failed to load user4 SLOB table ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMITĭisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production ORA-00604: error occurred at recursive SQL level 1 Handily there is an error message in the logfileĪLTER TABLE cf1 MINIMIZE RECORDS_PER_BLOCK See /export/home/oracle/mel/SLOB/cr_tab_and_load.out Once this change was made, I was then able to create the first schema ( yay!) but then when it came to make the remaining 15, it failed. Simplest way to this is to change the grep to point to /usr/gnu/bin/grep in this script. This is caused by the function f_is_int requiring the gnu grep command behaviour. I’m going to track the changes I make here.įATAL : 2018.05.15-14:40:57 : Usage. Kevin himself suggests that you use a small linux host to run the tool if your database is running on a non-supported operating system. This means that to get it working is not as easy as it should be. Kevin Closson’s Silly Little Oracle Benchmark not ported to Solaris.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |