Very Computer

I am still working on it, but I have an example of what it can currently do.

Please look at it and give me some feedback.

http://www.oralinux.org/common/llprod.html

Are there other things I should be documenting?

Thanks

Mark Wagner

Good start!  Your sample tablespace DDL does not show options for extendable
data files, temp files, etc., so I can not tell if you have covered such
syntax.

There are tools out there that have all current syntax ready for your use.
For example, if you want to include the DDL for any version of Oracle from
7.3 - 8i (and future versions when released), and/or if you want to include
more than just the tablespaces (e.g., profiles, roles, rollback segments,
users, database links, etc), and if you have Perl, then you might want to
look at the free Perl module DDL::Oracle, available from the CPAN, and from:

    http://sourceforge.net/projects/ddl-oracle/

Richard Sutherland

Quote:> I have written a tool to document oracle databases.

> I am still working on it, but I have an example of what it can currently
do.

> Please look at it and give me some feedback.

> http://www.oralinux.org/common/llprod.html

> Are there other things I should be documenting?

> Thanks

> Mark Wagner

increase the log_buffer - 163840 is a good start, 1048576 is typical.
your db_block_size is 4096 - but your db_file_multiblock_read_count = 8
- hike it to 16
        as 64 kb / 4 kb = 16
your sort_area_size is only 64 kb - hike it up to 1048576
and the sort_area_retained_size should be half that - 524288 is good.

set your sort_multiblock_read_count = 16
I'd increase the size of the hash area
hash_area_size = 131072  to maybe 1M - it depends on if you're using
hash joins, and how much memory is available.

Your control files are on the same hard drive - in the same directory.
You're better off if they're on separate physical drives.

hth,

Paul