How to install Statspack in Oracle

App Studio offers a variety of support plans to meet your needs. A Bronze Support Plan is included by default with all App Studio plans and provides access to the Knowledge Base, documentation and forums for instant answers 24x7.

Note that personalized support through tickets and Live Chat is only available with Silver and Gold Support Plans – purchasable separately.

If you purchased a Silver or Gold App Studio Support Plan, your Support Center Account will be setup for you by our team within 48 business hours of your plan purchase. An email will be sent to you containing a password reset link, which you need to click on. Please remember to check your Spam folder in the event you do not receive your email.

IMPORTANT: Your Support Center Account is separate to any existing App Studio accounts you may have created in the App Studio Portal. Those login credentials will not work with the Support Center, you will have to be signed up for Support plan to login.

App Studio is the leading cloud-based HTML5 solution that turns print into interactive award-winning tablet and smartphone experiences.

View our Support Plans

Our support team is here to answer all your questions about Quark products including QuarkXPress and Quark Enterprise Solutions. Check out our online knowledge base, documentation site and forums for instant answers 24x7.

If you have a current maintenance plan or are within your free support period you can also contact us directly through our online chat as well as My Support where you can submit tickets and fully manage and track your support history.

If you are a Quark customer and have a current maintenance or support contract we already have your support account setup for you. Please check out our knowledge base article for details on how to get started.

Any new purchase of QuarkXPress includes 60 days of free support and access to the support portal. To get your 60 days of free support you must first register, click here to register your copy of QuarkXPress. Note that it can take 2-3 hours for your support account to activate after registering QuarkXPress. Once active, you will be notified via email.



View our Support and Maintenance Plans

Welcome to Quark's IT Help Desk your single point of contact for assistance with IT related queries. You can create a help desk ticket which will be routed to the appropriate IT Help Desk engineer to research and correct your issue.

Quark's IT Help Desk is committed to providing the support you need to make the most of your every day work experience.

To log a Help Desk ticket, please use the sign in option at the top of the page.

Thank You,

Quark IT Support

How to install Statspack in Oracle

Use these steps to install Statepack

  1. Execute the command : export Oracle_SID=qdmsprod
  2. Login into Oracle with the sys user.
  3. Create a tablespace Statspack with a size of approximately 150-250 Mb. This is used for collecting the database statistics.

    SQL>create tablespace statspack datafile ‘<datafile-path>/stats01.ora’ size 250m;
  4. Install Statspack. Execute spdrop.sql if statspack is already installed.

    SQL> @<oracle_home>/rdbms/admin/spdrop.sql
    Execute spcreate.sql to install statspack
    SQL> @<oracle_home>/rdbms/admin/spcreate.sql


    Enter the following values for the different items it prompts:

i) Password for the user perfstat – quarkdms
ii) Default Tablespace – statspack
iii) Temporary Tablespace – Any Temporary tablespace of the database

  1. Connect with the user perfstat:

    SQL> conn perfstat/quarkdms
    Execute the script spauto.sql to automate the collection of statspack statistics every hour
    SQL>@<oracle_home>/rdbms/admin/spauto.sql

Important Note: Please note the Job ID of the job.

Was this answer helpful?YesNo
Topic Information
  • Topic #: 30026-1850
  • Date Created: 11/20/2012
  • Last Modified Since: 11/20/2012
  • Viewed: 1842
Welcome Guest