- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Which datafiles will be used ??
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 01:39 PM
тАО04-12-2004 01:39 PM
Which datafiles will be used ??
Suppose I have 2 data files in a tablespace and both of them are empty. Just wondering what criteria Oracle uses to write data to these data files ?
As I have encounter a case for temporary tablespace - one data file is 4GB and the other is 2GB. One user account with 2GB file size ulimit is unable to execute the query when the temporary tablespace is empty.
Any idea ??
Cheers,
Chris,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 03:02 PM
тАО04-12-2004 03:02 PM
Re: Which datafiles will be used ??
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 03:31 PM
тАО04-12-2004 03:31 PM
Re: Which datafiles will be used ??
The error message is:
ERROR at line 1:
ORA-01114: IO error writing block to file 4 (block # 420098)
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 512001
ORA-01114: IO error writing block to file 4 (block # 420098)
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 512001
And the sql is run by cronjob. The user account is OS authenticated.
Cheers,
Chris,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 04:57 PM
тАО04-12-2004 04:57 PM
Re: Which datafiles will be used ??
Set the ulimit file limit for the user to unlimited or at least more than the
maximum datafile size.
There r two kinds of Limits Hard and Soft Limit.
Increasing the limit for a resource usually requires special privileges. Some systems allow you to lower resource limits and later increase them. These are called soft lim-
its. Once a hard limit is set the resource can not be increased.
Which oracle version ur using and what is OS.
With Regards
Hari Kumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 07:15 PM
тАО04-12-2004 07:15 PM
Re: Which datafiles will be used ??
if hpux, to change the process resource limits:
to display the soft limit for stack size:
$ ulimit -s
to set the soft limit to 'unlimited':
$ ulimit -s unlimited
to display the hard limit for stack size:
$ ulimit -Hs 8192
to increase the hard limit:
$ ulimit -Hs 8193
regards tommy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 07:48 PM
тАО04-12-2004 07:48 PM
Re: Which datafiles will be used ??
users do not write to Oracle datafiles. This is handled by the Oracle database owner, only this user needs to have access to this files, enough quotas, etc.
regards,
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2004 09:21 PM
тАО04-12-2004 09:21 PM
Re: Which datafiles will be used ??
Please check this link:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=227044
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=14213
hth.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2004 06:14 PM
тАО04-14-2004 06:14 PM
Re: Which datafiles will be used ??
Thanks for all your solutions. However, I would like to know how Oracle determines which datafile to use when handling queries / or other insert, update, delete operations.
Any related documents / resource can help ?
Many thanks,
Chris,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2004 10:08 AM
тАО04-16-2004 10:08 AM
Re: Which datafiles will be used ??
this might be outdated and there are diffrences now between Dictionary and local managed tablespaces ....
http://asktom.oracle.com/pls/ask/f?p=4950:8:832400930516336758::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2091240981476,
There are pretty good whitepapers available at http://otn.oracle.com
Hope this helps
Volker