Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] Two questions
>Subject: [Q] Two questions
>From: vlpa_at_daleen.com
>Date: 6/17/98 11:12 GMT
>Message-id: <6m88af$rho$1_at_nnrp1.dejanews.com>
>
>Hello,
>
>I would like to know if this is true that Oracle 7.3 does not
>support table fragmentation and index fragmentation across
>sever db spaces. And if this is true how do people
>deal with large database for OLTP applications with several
>hundred concurrent connections?
>
>
>And the second question is:
>do oracle stored procedures support
>recursion (i.e. can call themselfs)
>
>
>Thanks in advance for any info.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
>
>
In ORACLE 7.3 a table/index is allocated to a particular tablespace, but a
tablespace may be made up of files on a number of different filesystems/disks.
Another method of 'striping' is to use Disk Management software that will allow
you to use parts of a number of disks to make up filesystems etc.
Oracle stored procedures do support recursion.
Hope this helps,
Rob
Received on Wed Jun 17 1998 - 17:24:05 CDT