Home » RDBMS Server » Server Administration » analyze full database (oracle 11.2.0.3,linux)
analyze full database [message #586769] Mon, 10 June 2013 10:27 Go to next message
vivek_k47
Messages: 14
Registered: August 2012
Location: india
Junior Member
how can i change/modify the below script to analyze full database:

DBNAME='DR01ABL'; export DBNAME;
RACDB='TRUE'; export RACDB;
ORACLE_HOME='/u02/app/oracle/product/11.2.0.3/DR01ABL'; export ORACLE_HOME;
SCHEMA='DBSNMP'; export SCHEMA;
USERNAME='sys'; export USERNAME;
TABLE_LST_FILE='/share/DBATOOLS/oracle/config/DR01ABL/ORA_DR01ABL_STATS.lst'; export TABLE_LST_FILE;

Thanks.
Re: analyze full database [message #586770 is a reply to message #586769] Mon, 10 June 2013 10:44 Go to previous messageGo to next message
BlackSwan
Messages: 22690
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

http://www.oracle.com/pls/db112/search?remark=quick_search&word=statistics

Re: analyze full database [message #586774 is a reply to message #586769] Mon, 10 June 2013 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 58859
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how can i change/modify the below script to analyze full database:


Write a new one.
This one does nothing.

Regards
Michel
Re: analyze full database [message #586903 is a reply to message #586769] Tue, 11 June 2013 10:27 Go to previous messageGo to next message
vivek_k47
Messages: 14
Registered: August 2012
Location: india
Junior Member
Please tell me what the script should contain.Thanks.
Re: analyze full database [message #586905 is a reply to message #586903] Tue, 11 June 2013 10:32 Go to previous messageGo to next message
cookiemonster
Messages: 10908
Registered: September 2008
Location: Rainy Manchester
Senior Member
That's not a script. That's a parameter file. Scripts issue commands and do things.
What tool is using that file and what is it trying to do with it?
Re: analyze full database [message #586917 is a reply to message #586905] Tue, 11 June 2013 12:44 Go to previous messageGo to next message
joy_division
Messages: 4504
Registered: February 2005
Location: East Coast USA
Senior Member
cookiemonster wrote on Tue, 11 June 2013 11:32
That's not a script. That's a parameter file.


I wouldn't even classify it as a parameter file. I'd call it an environment setup file. The .lst file "may" be a parameter file.
Re: analyze full database [message #587131 is a reply to message #586905] Wed, 12 June 2013 11:38 Go to previous messageGo to next message
vivek_k47
Messages: 14
Registered: August 2012
Location: india
Junior Member
Hi,
This is the content of a configuration file.
Re: analyze full database [message #587133 is a reply to message #587131] Wed, 12 June 2013 11:43 Go to previous message
BlackSwan
Messages: 22690
Registered: January 2009
Senior Member
>This is the content of a configuration file.
a configuration file to what exactly; since this is not a default file that get delivered by Oracle with every RDBMS installation.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1133388300346992024
Previous Topic: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script
Next Topic: How to apply grid infrastructure patch set PSU 16083653 in linux 6.4
Goto Forum:
  


Current Time: Fri Aug 22 09:31:59 CDT 2014

Total time taken to generate the page: 0.06290 seconds