New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 00:24, 9 November 2019 Check Mirror Status (hist) [791 bytes] Admin (talk | contribs) (Created page with "A handy SQL contributed by Andrew R. <blockquote><pre> SELECT left(a.name,50) 'Database' , CASE b.status WHEN 0 THEN 'Suspended' WHEN 1 THEN 'Disconnected'...")
- 00:24, 9 November 2019 Querying Active Directory Members for SQL Server Databases (hist) [1,016 bytes] Admin (talk | contribs) (Created page with "This is a rather convoluted way of approaching the task required, but does also provide a degree of flexibility. I needed to write a script to obtain a list of members of use...")
- 00:23, 9 November 2019 Various-Tasks (hist) [332 bytes] Admin (talk | contribs) (Created page with "Clone Role with Securables Check Database Version Check Database Uptime Check Mirr...")
- 23:54, 8 November 2019 Creating an Oracle Database with Apex on AWS RDS (hist) [5,512 bytes] Admin (talk | contribs) (Created page with "'''Steps to create an Oracle Standard Edition Two database on AWS with APEX as an option. These notes are for Apex version 5.1.2.v1''' '''PRE-REQUISITIES''' If you don't a...")
- 23:53, 8 November 2019 SQL Server Backup Script for AWS RDS (hist) [1,157 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> DECLARE @dbs TABLE (dbname VARCHAR(50)) DECLARE @currentDB VARCHAR(50) declare @SQL1 nvarchar(3000) declare @SQL2 nvarchar(3000) declare @BUCKET nvarchar(2...")
- 23:53, 8 November 2019 Auto Refresh of Oracle DB across VPCs (hist) [7,346 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> #!/bin/ksh # # Shell script for Snapshot of Databases # Nazim Merchant # 26 Jul 2018 # # Usage script.ksh instance-name source_db_name target_db_name e.g. or...")
- 23:52, 8 November 2019 Datapump Export to S3/Glacier (hist) [5,218 bytes] Admin (talk | contribs) (Created page with "Another script that has been documented for preservation more than anything else. '''Pre-requisites''' * ec2 Instance with Oracle XE installed * Access to the RDS Databases u...")
- 23:51, 8 November 2019 Dynamic Profile Creation Script (hist) [390 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> set serveroutput on declare cursor prof is select dbms_metadata.get_ddl('PROFILE', profile) as profile from (select distinct profile from dba_...")
- 23:51, 8 November 2019 Deploy Amazon Web Services Plugin to Cloud Control (hist) [1,135 bytes] Admin (talk | contribs) (Created page with "To monitor AWS RDS Database via Cloud Control (13c), a plugin needs to be deployed on OEM. Here are some rough notes, for my own reference. '''Download Plug-in''' <blockquot...")
- 23:50, 8 November 2019 Dynamic Tablespace Creation Script (hist) [1,606 bytes] Admin (talk | contribs) (Created page with "This script generates a dynamic Tablespace Creation (with multiple datafiles) script from my target database for my RDS instance. It deals with smallfile tablespaces. <block...")
- 23:49, 8 November 2019 Create a DB Link on RDS DB (hist) [234 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> create database link test connect to <username> identified by "<password>" using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip_address>)(PORT=1521))(CONNECT...")
- 23:49, 8 November 2019 General-Tasks (hist) [648 bytes] Admin (talk | contribs) (Created page with " Creating an Oracle Database with Apex on AWS RDS Dynamic Profile Creation Script [...")
- 23:46, 8 November 2019 Disable Auto SQL Tuning Advisor (hist) [121 bytes] Admin (talk | contribs) (Created page with "<pre> select * from dba_autotask_operation EXEC dbms_auto_task_admin.disable( 'sql tuning advisor', NULL, NULL ); </pre>")
- 23:44, 8 November 2019 Check Bind Variables (hist) [289 bytes] Admin (talk | contribs) (Created page with "Here's a way you can check on what bind variable values have been parsed in a query. <blockquote><pre> SELECT a.sql_id , a.sql_text , b.name , b.value_string...")
- 23:44, 8 November 2019 Tuning-Tasks (hist) [123 bytes] Admin (talk | contribs) (Created page with " Check Bind Variables Disable Automatic SQL Tuning Advisor")
- 23:39, 8 November 2019 RMAN - Create Standby Database (hist) [1,218 bytes] Admin (talk | contribs) (Created page with "These are just rough notes for my own benefit. They are not well researched and are only posted as a reminder for myself. Had to convert a database to a physical standby usi...")
- 23:39, 8 November 2019 Resize Online Redo Logs (10g) - Rough Notes (hist) [1,822 bytes] Admin (talk | contribs) (Created page with "To resize redo log files, we have to drop and recreate them. The status of these files is critical. Files with a status of: * CURRENT - cannot/must not be dropped. To ch...")
- 23:39, 8 November 2019 READ ONLY Before RESETLOGS (11g) (hist) [427 bytes] Admin (talk | contribs) (Created page with "A new feature in Oracle 11g is that after incomplete recovery of a database, you can now open the database in read only mode before opening in resetlog mode. This now enables...")
- 23:38, 8 November 2019 Check Recovery Time (hist) [209 bytes] Admin (talk | contribs) (Created page with "It's quite useful sometimes to be able to see the timestamp associated with a Database Recovery. <blockquote><pre> SELECT to_char((max(TIME_DP)),'DD MON YYYY HH24:MI') FROM...")
- 23:38, 8 November 2019 Manually Create Standby Database from Hotbackup (9i) (hist) [490 bytes] Admin (talk | contribs) (Created page with "This is basically a "Note-To-Self". High Level Steps for Reference, are: * Copy Datafiles across. * On Target, set up env variables, password file, oratab entry etc. *...")