|
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 |
