HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle diskouota

 
suri123
Occasional Contributor

oracle diskouota

i want to allow a limited space of my oracle user how can i do it
5 REPLIES
Steven E. Protter
Exalted Contributor

Re: oracle diskouota

Shalom,

http://docs.hp.com/en/B2355-90672/ch05s02.html

For any user.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
suri123
Occasional Contributor

Re: oracle diskouota

hi
i need in oracle 8i disk space not in linux plz tell me exact command we use disk space for a particular user
Bill Hassell
Honored Contributor

Re: oracle diskouota

You limit the space required by working with your database administrator, not by setting an OS limit. This type of limit will cause a failure in Oracle which may or may not corrupt the databases. Your DBA can set limits in the Oracle configurations.


Bill Hassell, sysadmin
Steven E. Protter
Exalted Contributor

Re: oracle diskouota

I gave you a procedure for HP-UX.

Putting a quota in place without coordination with the DBA will most likely lead to Oracle locking up and crashing.

Oracle is configured to take more space when it needs it.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
B. Hulst
Trusted Contributor

Re: oracle diskouota

If oracle datafiles are set to auto-extend they will grow if there is diskspace.
The DBA can disable in Oracle the auto-extend for the datafiles. This way it will not grow.

However Oracle produces Archivelogs that could eat up diskspace. If you disable archive log creation, the Oracle is quite static, when it comes to diskspace.

Only the Oracle event logs could be growing but you could trim or rotate them every night...

Setting diskquota for oracle is not a good idea.

:)