tag:blogger.com,1999:blog-13265058.post113435932636145656..comments2023-10-28T23:33:56.980+11:00Comments on Sydney Oracle Lab: PL/SQL Garbage CollectionSydOraclehttp://www.blogger.com/profile/08828771074492585943noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-13265058.post-60835747416846894012009-08-11T19:47:06.212+10:002009-08-11T19:47:06.212+10:00That will be permissions.
You will need to be gran...That will be permissions.<br />You will need to be granted select on those tables. Your DBA would be able to do that. In your own system, if you log on with<br /><br />sqlplus / as sysdba<br /><br />you should be able to<br />GRANT SELECT_CATALOG_ROLE TO user;<br /><br />and then that user will be able to run the scriptSydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-33906819754546214082009-08-10T17:07:14.217+10:002009-08-10T17:07:14.217+10:00Hi Gary,
Thanks for the code and explaination !!
...Hi Gary,<br /><br />Thanks for the code and explaination !!<br /><br />I am a newbie to Oracle PL/SQL programming.<br /><br />When I tried to execute the anonymous block it gave me the following error:<br /><br /> from v$statname a, v$mystat b<br /> *<br />ERROR at line 5:<br />ORA-06550: line 5, column 25:<br />PL/SQL: ORA-00942: table or view does not exist<br />ORA-06550: line 4, column 6:<br />PL/SQL: SQL Statement ignored<br />ORA-06550: line 11, column 33:<br />PLS-00364: loop index variable 'I' use is invalid<br />ORA-06550: line 11, column 7:<br />PL/SQL: Statement ignored<br /><br />Could you please help me with that ??<br /><br />Kind Regards<br />SamKaal Bhairavahttps://www.blogger.com/profile/03524561840920733939noreply@blogger.com