- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: how to create a database
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-24-2003 06:55 AM
тАО04-24-2003 06:55 AM
how to create a database
I have to create a database and I don't know how to set SGA dimension, how many rollback segments, redo log I have to do. Furthermore I don't know which script (e.g. catalog.sql) I have to run. After I will have to do a full import.
Could someone give to me some advice about standard setting?
thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 06:59 AM
тАО04-24-2003 06:59 AM
Re: how to create a database
Thanks
Zafar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 07:10 AM
тАО04-24-2003 07:10 AM
Re: how to create a database
I have already done it. How can I use it in my case?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 07:16 AM
тАО04-24-2003 07:16 AM
Re: how to create a database
$dbassist
(hope i am correct)
just create with minimal requirement and later you can increase the parameter, but make sure don't choose all the options which you don't require now, like it might ask you spatial data and J/SQL other.
In this case you don't have to manually run all those database scripts, I mean catproc.sql, catalog.sql and other 3-4 scripts.
Thanks
Zafar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 07:32 AM
тАО04-24-2003 07:32 AM
Re: how to create a database
I know dbassist but I don't know for example how big I have to do shared pool and so on.
I need to know reasonable value for the parameter.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 07:53 AM
тАО04-24-2003 07:53 AM
Re: how to create a database
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/toc.htm
Thanks
Zafar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 10:01 AM
тАО04-24-2003 10:01 AM
Re: how to create a database
Good basic values are:
shared_pool_size = 50m
db_block_buffers = 1000
log_buffer = 32768
processes = 50
Rollback segments can be set however you like. I would recommend starting with a 1 or 2m extent size, and tuning it after the application is running. Logs are the same way, using 500k to 1m to start, and make sure that you aren't switching more than once every 30 seconds.
The scripts that you will need to run are:
catalog.sql
catproc.sql
If you use any extra procedures (replication, advanced query, parallel query, etc) you will need to run the scripts associated with those products as well to make sure that the tables/indexes/views are loaded correctly.
Hope this helps,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 05:41 PM
тАО04-24-2003 05:41 PM
Re: how to create a database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2003 05:52 PM
тАО04-24-2003 05:52 PM
Re: how to create a database
The most information things to decide during database creation are db block size as this parameter cannot be change after database is create.But the SGA size,rollback,redo log all can be altered/changed after the database creation.
In the init.ora file there are already size mention for SGA and may be you can use the default size and changed later if cause some performace issue.
regards
mB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-25-2003 10:49 AM
тАО04-25-2003 10:49 AM
Re: how to create a database
I find a couple of logical additions could really help.
There are two keys to your long term happiness here!
Storage in the temp and system
tablespaces. Don't install them as defaults. Make system tablespace large for a production database. Non-indexed queries use temp tablespace at alarming rate.
The system tablespace holds views,triggers,database information, and other sundries to keep the Database healthy.
Most tableaspaces, and datafiles can be created/modified to grow by themselves.
This is an evil practice. (I do not recommend autoextend) make sure you have the storage you need immediately.
Plan the indexes to be on a separate drive from the datafiles,
Place the archive logs on a separate spindle. the system can go no faster than the log writer process.
Watch space evaporate. Oracle is almost a license to buy storage...
Tim