New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 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. *...")
- 23:38, 8 November 2019 Lost spfile and pfile (hist) [199 bytes] Admin (talk | contribs) (Created page with "''Handy Tip'': If you have lost your spfile and pfile, you can recover the non-default values previously set from the database Alert Log, as these values are spooled to the al...")
- 23:37, 8 November 2019 Log Mining (10g) (hist) [1,675 bytes] Admin (talk | contribs) (Created page with "'''Please note the database parameter log_parallelism needs to be set at 1 for this to work''' In this day and age of flashback configuration, log mining almost seems like...")
- 23:37, 8 November 2019 Check Last Applied Archive Log (hist) [153 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT max(sequence#) FROM v$log_history; </pre></blockquote> OR ... <blockquote><pre> SQL> archive log list; </pre></blockquote>")
- 23:37, 8 November 2019 Foreign Archive Logs (11g) (hist) [747 bytes] Admin (talk | contribs) (Created page with "A colleague of mine recently noticed in our Fast Recovery Area (aka Flash Recovery Area) that some FOREIGN ARCHIVED LOGS were taking up space. We knew from a recent implement...")
- 23:36, 8 November 2019 Cloning Schema (11g) (hist) [4,585 bytes] Admin (talk | contribs) (Created page with "Found an interesting way to clone a schema '''in the same database''' using datapump with a database link. Could be considered a highly unsupported method, but it worked for...")
- 23:36, 8 November 2019 Available db recovery file dest (hist) [475 bytes] Admin (talk | contribs) (Created page with "A great script picked up somewhere along the way to check the available amount of db_recovery_file_dest space. <blockquote><pre> SELECT name , floor(space_limit/1024/102...")
- 23:35, 8 November 2019 Manually Create a Controlfile via SQL (hist) [2,887 bytes] Admin (talk | contribs) (Created page with "Something I no doubt cobbled together many years ago for reasons I cannot recall. Could be useful though! <pre> declare cursor log_files is select v$log.group#...")
- 23:35, 8 November 2019 Datapump Dynamic List of Tables (hist) [832 bytes] Admin (talk | contribs) (Created page with "In PeopleSoft, I needed to export out all configuration/system-owned tables as a backup each week. To achieve this, my first step was to create a view listing all these tables...")
- 23:34, 8 November 2019 Monitoring Import Job Progress (hist) [436 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT substr(sql_text, instr(sql_text,'INTO "'),30) table_name , rows_processed , round( (sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss')...")
- 23:34, 8 November 2019 Pipe Database Export to Zip (hist) [335 bytes] Admin (talk | contribs) (Created page with "Using fifo (first in first out) you can redirect your database exports through a pipe straight to zip. '''Make fifo pipe:''' mkdir fifo db.fifo '''Write the file output...")