Home » RDBMS Server » Server Administration » Script to find the database features
Script to find the database features [message #627291] Mon, 10 November 2014 13:59 Go to next message
krish96
Messages: 74
Registered: October 2012
Member
Hello Experts,

Can you please help me to run a script on each instances to find database options that are currently enabled and that can pull all the information in to html file..

Please provide me the script..


Thank you..
Re: Script to find the database features [message #627292 is a reply to message #627291] Mon, 10 November 2014 14:03 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
krish96 wrote on Mon, 10 November 2014 11:59
Hello Experts,

Can you please help me to run a script on each instances to find database options that are currently enabled and that can pull all the information in to html file..

Please provide me the script..


Thank you..



scripts are OS dependent & you decided to not provide us your details so we can not provide you any script.

post example of the database options you desire to be reported.

how does script know or decide which databases exist so they can be queried?
Re: Script to find the database features [message #627293 is a reply to message #627292] Mon, 10 November 2014 14:09 Go to previous messageGo to next message
krish96
Messages: 74
Registered: October 2012
Member
we have databases running on 9i/10g/10r2/11gr1/11gr2/12c SunSolaris 5.10 and Windows 2008r2/2012r2..

Database options like table partitioning ..e.t.c..

Re: Script to find the database features [message #627295 is a reply to message #627293] Mon, 10 November 2014 14:17 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
partitioning only exists in Enterprise edition

how does script know or decide which databases exist so they can be queried?
Re: Script to find the database features [message #627301 is a reply to message #627291] Mon, 10 November 2014 14:38 Go to previous messageGo to next message
Michel Cadot
Messages: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Options installed: v$option
Features used/not used: dba_feature_usage_statistics
Does not exist before 10g.

[Updated on: Mon, 10 November 2014 14:39]

Report message to a moderator

Re: Script to find the database features [message #627305 is a reply to message #627301] Mon, 10 November 2014 14:53 Go to previous messageGo to next message
krish96
Messages: 74
Registered: October 2012
Member
Thank you michel..
Re: Script to find the database features [message #627366 is a reply to message #627305] Tue, 11 November 2014 06:43 Go to previous message
gazzag
Messages: 994
Registered: November 2010
Location: Bristol, UK
Senior Member
DBA_REGISTRY may also be of use to you.
Previous Topic: Release storage back to Unix OS from Oracle 11g Tablespace
Next Topic: Large Trace files in every 10 minutes
Goto Forum:
  


Current Time: Tue Oct 23 02:45:29 CDT 2018