Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Set Storage space for OBIEE user folder

Received Response
42
Views
9
Comments
Anirban1
Anirban1 Rank 4 - Community Specialist
edited Aug 13, 2024 5:30PM in Oracle Analytics Cloud and Server

Hi,

We have a requirement that, adhoc users will create their own report in OBIEE but the total size of the user folder should not exceed 20 GB. Can we set that from OBIEE, so that user can create their own report but it will not exceed the SLA of storage.

Thanks

Anirban

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    There is a total size allocation to the complete catalog. Default is 5GB for the whole catalog.

    Personal space is controlled by the PersonalStorageSizeLimitMB tag in the instanceconfig.

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Christian,

    Thanks for your reply.

    Please let me know How I can change the default size from 5 GB to 40 GB.

    Also I am not able to find "PersonalStorageSizeLimitMB" tag in instanceconfig file. Do I need to add that tag for OBIEE 12c.

    Will it be set for each user, like if we have 10 users and I set as 40 mb then every user will get 40mb and the total size will be 400 mb??

    Thanks

    Anirban

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    The parameter isn't there by default but it's part of the XSD.

    <catalog>
    <ServiceInstanceQuota>
    <Enabled>true</Enabled>
    <SizeLimitMB>40960</SizeLimitMB>
    <PersonalStorageLimitMB>40</PersonalStorageLimitMB>
    </ServiceInstanceQuota>
    </catalog>

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Christine,

    Thanks for the information.

    Thanks

    Anirban

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Christine,

    <PersonalStorageLimitMB>40</PersonalStorageLimitMB>

    is it for single user or All the user limit.

    Thanks

    Anirban

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    "Christian"

    I don't understand your question. It's the limitation for a user's storage. As the XSD says: "Set the default quota for a user's home directory."

  • Gianni Ceresa
    Gianni Ceresa Mod

    As Christian said: the file says it's for every single "home" directory.

    But doesn't mean that your catalog will then be limited to <number of users> * <PersonalStorageLimitMB> because there is still the shared part of the catalog which isn't a "home" folder. But at least let you keep a control on the size of personal users' folders.

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Christian,Gianni,

    Thanks for your reply. I was confused with PersonalStorageLimitMB.

    What I understood is if I have 2 user and set PersonalStorageLimitMB=10, then each user will get 10 mb file storage.

    Thanks

    Anirban

  • Gianni Ceresa
    Gianni Ceresa Mod 
    Anirban1 wrote:What I understood is if I have 2 user and set PersonalStorageLimitMB=10, then each user will get 10 mb file storage.

    That's what the config setting comment says. I can't affirm it's the case as I never needed it, so I trust the comment in the XSD about that setting.

    So yes, it seems to be a setting to limit each individual home folder to a size. But doesn't have any impact outside to the home directly of the user.