Shulou(Shulou.com)06/01 Report--

Editor to share with you how to achieve the script to obtain database information, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article. Let's learn about it!

Demonstration of specific practices:

[oracle@rac1 ~] $sqlplus / nolog

SQL*Plus: Release 10.2.0.1.0-Production on Fri Jul 11 15:57:34 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL > conn sys/oracle as sysdba

Connected.

SQL > @ dba_snapshot_database_10g.sql

+-+

| | Snapshot Database 10g Release 2 | |

| |-+ |

| Copyright (c) 1998-2008 Jeffrey M. Hunter. All rights reserved. (www.idevelopm ent.info) |

+-+

Creating database report.

This script. Must be run as a user with SYSDBA privileges.

This process can take several minutes to complete.

Output written to: dba_snapshot_database_10g_ORCL_20080711.html

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the Partitioning, OLAP and Data Mining options

The above is all the contents of the article "how to implement the script to get database information". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.