Data Server Scripts

　　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