Re: Correct way to determine freelists and freelists groups

2002-06-07 Thread Greg Moore
Are there any scripts table_access_paths.sql from www.ixora.com.au will suggest number of freelists for a table -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: Correct way to determine freelists and freelists groups

2002-06-07 Thread Jamadagni, Rajendra
Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!

RE: Correct way to determine freelists and freelists groups

2002-06-07 Thread Hamid Alavi
I try to use table_access_path.sql but got stoped at @save_sqlplus_setting and couldn't find it, do I have to save my sqlplus setting manualy or some thing else, If any body run this script can you give me a hint for running it. Thanks -Original Message- Sent: Friday, June 07, 2002 1:33

Re: Correct way to determine freelists and freelists groups

2002-06-07 Thread Suzy Vordos
Either comment out the save_sqlplus_setting script or download it from from www.ixora.com.au. Do the same for script restore_sqlplus_settings. Both scripts just save/restore your current SQL*Plus settings should another script modify them. Hamid Alavi wrote: I try to use

Re: Correct way to determine freelists and freelists groups

2002-06-07 Thread Greg Moore
I try to use table_access_path.sql but got stoped at @save_sqlplus_setting On the page where you downloaded the script, click on and read Prerequisites. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network