熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Data Server Scripts

2013-11-13 15:55:10  來源: Oracle 

  Sort of oldfashion DBA/Dev or train by oldfashion DBAs so Im still craze about scripts Recently Metalink updated a list of Data Services (database) scripts
  
  For those beginners either DBAs/Devs its a good chance by reading and learning these scripts
  
  For those experts it may refresh your mind to read other experts scripts
  
  For those without the account in Metalink find a good friend of you whom has and then help you download it I think theyre openedsource
  If you really couldnt get them draw me a line and see if I could work around for you
  
  Please dont treat yourself as a Recycle bin download and read those youre really interested in
  
  Enjoy your life
  frank
  
  
  Heres a list of Metalinks scripts related to Data Services
  
  CONSTRAINTS (條限)
  Check For Foreign Key Locking Issues GSX 查外條限被鎖
  Determine An Objects Dependencies GSX 查數據對象的依屬關系
  Generate List Of Table Dependencies GSX 查數據表之間的依屬關系
  Listing Foreign Key Constraints GSX 查外條限的條限
  Report Table Constraints GSX 查數據表的條限
  Script For Capturing Table Constraints GSX 修改數據表的條限
  Script To Create SQL to Enable/Disable Table Constraints GSX 修改數據表條限的狀態
  Script To Eliminate NonUnique Rows GSX 刪去重覆的行
  Script To Generate A Delete Cascade Report GSX 紀錄串連刪除
  Script To Locate Tables W/O Primary Keys GSX 查沒有主健的數據表
  Script To Report Constraints For A User GSX 查用戶的數據表條限
  
  DBA_INFORMATION (數據庫資料)
  Create View To Display All Open Pipes GSX 查SGA上的數據管道
  Delete Commit Procedure GSX 確定刪除的程式
  List Inactive Users GSX 查非活動用戶
  Recompiling Invalid Objects Automatically Note 重新輯錄無效的數據對象
  Removing Offending Synonyms of Invalid Objects GSX 刪除無效數據對象的同義對象
  Report Dispatcher & Process Mapping Using Mts GSX 查MTS dispatchers上的O/S用戶
  Report Redo Log Information GSX 查重造紀錄的資料
  Report Sequence Values GSX 查順序鏈的資料
  Script For Creating A Data Base Schema Summary GSX 查數據格的資料
  Script To Display Files Needed To Perform Hot Backup GSX 查需要熱備份的文件
  Script to do END BACKUP on all datafiles GSX
  Script To Drop Some Or All Objects From Schema GSX
  Script to find who owns TEMP Segments in V Note
  Script To Fully Describe A Table GSX
  Script To List Programs For A User GSX
  Script To Monitor Session Idle Times GSX
  Script To Obtain Session Information GSX
  Script To Produce A Database Summary Report GSX
  Script To Provide Database Performance Overview GSX
  Script To Provide Listing Of All Database Files GSX
  Script to Rectify Differences between two tables in a Replicated Environment
  Script To Report Instance Parameters GSX
  Script To Return What Columns Have Null Values Data GSX
  Script To Show Audit Options/Audit Trail GSX
  SQL: DIAG Determining Dependency Information (Oracle) Note
  SQL Finding Objects in SYSTEM and SYS schemas Note
  Verify Stored Procedures GSX
  
  EXPORT/IMPORT
  Exporting All Tables Within a Specific Tablespace GSX
  Script To Export Data To FixedWidth Text GSX
  Script To Export User Definitions GSX
  Script To Generate Sql*Loader Control File GSX
  Script To Report Object Owners In Database GSX
  
  INDEX
  Script To Describe All Indexes In A Schema GSX
  Script To Report Information On Indexes GSX
  Script To Show Data Selectivity For A Column GSX
  
  JOB QUEUE
  Script To List Running Jobs GSX
  Script To List Submitted Jobs GSX
  
  LOCKING
  Display Locks And Give Sid And Serial # To Kill GSX
  Display Sql Text From Locks GSX
  Fully Decoded Locking Script GSX
  Low Complexity Locking Info GSX
  Report Sessions Waiting For Locks GSX
  Script To Display User Lock Information GSX
  Script To Return Medium Detail Locking Info GSX
  Viewing Locks on Objects Held by a Specific User GSX
  
  OBJECT_CREATION
  Canned Scripts To Gather Ddl For All Triggers GSX
  Generate Create Tablespace Script GSX
  Script To Generate Db Link Script GSX
  Generate Index Creation Script GSX
  Generate Object Priv Grant Script GSX
  Generate Role Creation Script GSX
  Generate Synonym Creation Script GSX
  Generate System Priv Grant Script GSX
  Generate View Creation Script GSX
  View To Show Parallel Instance Number GSX
  
  PERFORMANCE
  Create Stats For All Tables In Schema GSX
  Formatted Select Of Explain Plan Table GSX
  Mstat System Statistics /Tuning Script GSX
  Report Session & System Waits GSX
  Report Statistics For A Table GSX
  Report Tables Rows Per Datafile GSX
  Report Various Db Statistics GSX
  Rstat Reactive Performance Utility GSX
  Script To Check Tables For Statistics GSX
  Script To Provide Latch Performance Information GSX
  Script To Report Dictionary Cache Effectiveness GSX
  Script To Report File I/O Statistics GSX
  Script To Report Sga Buffer Summary GSX
  Script To Report The Instance Statistics GSX
  Script To Simplify The Use Of Explain Plan GSX
  Script To Show SGA Parameters & Statistics GSX
  Sort physical rows of a table GSX
  
  PRIVILEGES/PROFILES
  Create View To Show All User Privs GSX
  Report Privs Granted To A User GSX
  Report User Role And Profile Info GSX
  Script To Report Roles Granted To Users GSX
  Script To Show System & Object Privs For User GSX
  
  ROLLBACK_SEGMENTS
  Finding the Number of Transactions in RBS for a Specific Object GSX
  Script For Displaying Active Transactions In Roll GSX
  Script To Display Wrap Time For Rollback Segs GSX
  Script To Obtain Rollback Segment Information GSX
  
  SPACE_MANAGEMENT
  Analyzing Tablespace Usage With An OsIndependent Sql Script GSX
  Check Tables For Backup Status GSX
  Computing Table Size Note
  Count How Many Of Each Object Users Have GSX
  Get Row Count For All Tables In A Schema GSX
  Report Db Space Usage By User GSX
  Report On Space In Tablespaces GSX
  Report Size Of Stored Objects GSX
  Report Size Of Stored Objects II GSX
  Report Tables With Many Extents GSX
  Script To Calculate Blocks Needed By A Table GSX
From:http://tw.wingwit.com/Article/program/Oracle/201311/17517.html
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.