tag:blogger.com,1999:blog-5532576497841734741.post5175580592891429524..comments2024-01-23T13:36:22.189+01:00Comments on Joords Oracle DBA blog: Installing and Using Standby Statspack in 11g (by active Data Guard)joordsbloghttp://www.blogger.com/profile/08320570930153541164noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5532576497841734741.post-14208221569246164132011-12-23T08:15:14.188+01:002011-12-23T08:15:14.188+01:00See Statistics Package (STATSPACK) Guide [MOS 3949...See Statistics Package (STATSPACK) Guide [MOS 394937.1]<br /><br />Scripts used<br />SQL> connect / as sysdba <br />SQL> @?/rdbms/admin/spcreatejoordsbloghttps://www.blogger.com/profile/08320570930153541164noreply@blogger.comtag:blogger.com,1999:blog-5532576497841734741.post-61327481312481280132011-12-22T04:49:07.523+01:002011-12-22T04:49:07.523+01:00"The perfstat schema and statspack related ob..."The perfstat schema and statspack related objects must be present on the primary and standby prior to installing standby statspack."<br />What scripts need to be run on the Primary to have the "perfstat" schema and "statspack objects" installed? Even Metalink does not make any mention about theseSuhas Dwarakanathhttps://www.blogger.com/profile/00196851450355504290noreply@blogger.com