New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)
- 00:44, 9 November 2019 Use Samba to copy file to Windows (hist) [314 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> smbclient //<WINDOWSSERVERNAME>/<SHAREDIRNAME> -A myauth.auth -c "put <sourcefilename> <windowspathname><destinationfilename>" </pre></blockquote> myauth.au...")
- 00:44, 9 November 2019 Yesterday's Date (hist) [116 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> date -d '1 day ago' </pre></blockquote> <blockquote><pre> date -d 'yesterday' </pre></blockquote>")
- 00:44, 9 November 2019 Check O/S Version (hist) [138 bytes] Admin (talk | contribs) (Created page with "uname -a Also ... '''Linux:''' cat/etc/issue '''AIX:''' oslevel oslevel -r (shows technology level) oslevel -s (shows service pack}")
- 00:44, 9 November 2019 Chmod (hist) [225 bytes] Admin (talk | contribs) (Created page with "Instead of having to work out the numeric settings for chmod, the following conventions can be "literally" used: <blockquote><pre> chmod u+rwx chmod g+rwx chmod o+rwx chmod...")
- 00:41, 9 November 2019 TSM Command Line Restore (hist) [368 bytes] Admin (talk | contribs) (Created page with "To restore files through TSM command line and pick what is needed. Note: destfile not required if restoring to original source directory. <blockquote><pre> dsmc restore "/pat...")
- 00:41, 9 November 2019 Tasks (hist) [227 bytes] Admin (talk | contribs) (Created page with "TSM Command Line Restore")
- 00:38, 9 November 2019 Random Image Generator (hist) [1,187 bytes] Admin (talk | contribs) (Created page with "On my [http://www.nazimcricket.com website] I had been using a third party Javascript random image generator which scrolled through my /images folder and displayed a random im...")
- 00:38, 9 November 2019 Global Parameters (hist) [813 bytes] Admin (talk | contribs) (Created page with "New to MySQL, but will make notes for my benefit, and for the odd person who stumbles on this post via Google. I need to write a few cron scripts for a MySQL database and I do...")
- 00:37, 9 November 2019 Spooling Out (hist) [442 bytes] Admin (talk | contribs) (Created page with "Thanks to my friend LW for helping sort this one out. You can increase the verboseness (is that a word?) of a batch output logfile in MySQL, by repeating the "-v" switch....")
- 00:36, 9 November 2019 Script to Backup and Restore a MySQL Database (hist) [5,611 bytes] Admin (talk | contribs) (Created page with "'''Requirements'''<br> * Obtain a simple backup of a Production MySQL database. * Send backup to TSM Tape Storage Device. * Copy the files to a Non-Production MySQL database s...")
- 00:36, 9 November 2019 Gen-Tasks (hist) [270 bytes] Admin (talk | contribs) (Created page with " Script to Backup and Restore a MySQL Database Spooling Out === MySQL and PHP (The Perfect Match) ===...")
- 00:29, 9 November 2019 Email Results of a Database Export (hist) [2,598 bytes] Admin (talk | contribs) (Created page with "Had to write a batch script to check on the status of a nightly database export and email out the Status. Some of what I've done may not be perfect, but it does the job nice...")
- 00:29, 9 November 2019 Services Manipulation (hist) [1,371 bytes] Admin (talk | contribs) (Created page with "To stop, start or check status of a Service remotely, you can use the sc utility as follows: <blockquote><pre> sc \\servername stop ServiceName sc \\servername start Service...")
- 00:29, 9 November 2019 Count Network Connections (hist) [412 bytes] Admin (talk | contribs) (Created page with "To get a count of the number of network connections on a Windows server, you can use the following batch script: <blockquote><pre> REM list network connections and write them...")
- 00:28, 9 November 2019 Tree Directory Listing (hist) [786 bytes] Admin (talk | contribs) (Created page with "A good way to list your files and folders. '''Syntax''' <blockquote><pre> Drive:\Path Drive Letter and Directory Name /f Displays File Names in each Director...")
- 00:28, 9 November 2019 Check Server UpTime (hist) [62 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> systeminfo | find "Time" </pre></blockquote>")
- 00:28, 9 November 2019 General (hist) [285 bytes] Admin (talk | contribs) (Created page with " Email Results of a Database Export Services Manipulation Count Network Connections | Count Network Con...")
- 00:25, 9 November 2019 Check Database Uptime (hist) [93 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sqlserver_start_time FROM sys.dm_os_sys_info; </pre></blockquote>")
- 00:25, 9 November 2019 Check Database Version (hist) [55 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT @@version; </pre></blockquote>")
- 00:24, 9 November 2019 Clone Role with Securables (hist) [451 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> declare @RoleName varchar(50) = '<ROLE_NAME>' declare @Script varchar(max) = 'CREATE ROLE ' + @RoleName + char(13) select @script = @script + 'GRANT ' + p.p...")
- 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. *...")
- 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...")
- 23:33, 8 November 2019 Monitoring RMAN Job Progress (hist) [295 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sid , serial# , context , sofar , totalwork , round(sofar/totalwork*100,2) "%_Complete" FROM v$session_longops WHERE opnam...")
- 23:33, 8 November 2019 RMAN Archivelog Deletions (hist) [263 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> rman nocatalog<< DATA connect target delete noprompt archivelog until time 'SYSDATE-n'; DATA </pre></blockquote> <blockquote><pre> rman nocatalog<< DATA con...")
- 23:33, 8 November 2019 Flashback Table (10g) (hist) [2,352 bytes] Admin (talk | contribs) (Created page with "The ability to flashback transactions to a point in time is quite a handy feature. Here is how it all works .... First of all, the oracle init.ora parameter db_flashback_ret...")
- 23:32, 8 November 2019 Flashback Schema (10g) (hist) [873 bytes] Admin (talk | contribs) (Created page with "Technically there is no schema level flashback feature available. However, provided your recovery period does not include any data dictionary changes DDL) then you could actua...")
- 23:32, 8 November 2019 Flashback Row (10g) (hist) [2,586 bytes] Admin (talk | contribs) (Created page with "The ability to flashback transactions to a point in time is quite a handy feature. Here is how it all works .... First of all, the oracle init.ora parameter db_flashback_rete...")
- 23:31, 8 November 2019 Check Space Fast Recovery Area (hist) [363 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT name , floor(space_limit/1024/1024) "Size_MB" , ceil(space_used/1024/1024) "Used_MB" , floor(space_limit/1024/1024) - ceil(space_used/1...")
- 23:30, 8 November 2019 RMAN - Point in Time Duplicate (11.2.0.2.0 (hist) [1,264 bytes] Admin (talk | contribs) (Created page with "I've spent weeks struggling with a point-in-time rman duplicate where for some obscure reason the duplicate would fail to apply point-in-time logs after midnight. FINALLY -...")
- 23:29, 8 November 2019 RMAN - Diagnosing Failures (11g) (hist) [219 bytes] Admin (talk | contribs) (Created page with "The commands you can use through RMAN to list, seek advice on and in some cases repair Database Failures .. <blockquote><pre> RMAN> list failure [detail]; RMAN> advise failur...")
- 23:28, 8 November 2019 Automatic Guaranteed Restore Point (11g) (hist) [1,365 bytes] Admin (talk | contribs) (Created page with "-- Script to schedule the creation of a guaranteed restore point on a database -- and to remove the oldest guaranteed restore point when there are more than 2 -- restore point...")
- 23:27, 8 November 2019 Restore in between Upgrades (hist) [3,866 bytes] Admin (talk | contribs) (Created page with "'''Requirement''' Had to restore a database to a point-in-time from a hotbackup. Followed Steps: * Copied datafiles to target * Created a New Controlfile * Recovered using...")
- 23:27, 8 November 2019 Snapshot Standby Database (11g) (hist) [4,939 bytes] Admin (talk | contribs) (Created page with "'''Introduction''' <br> One of the best new features of Oracle 11g is the introduction of Snapshot Standby Databases. This feature allows you to take a normal Physical Standb...")
- 23:26, 8 November 2019 Recovery-Tasks (hist) [1,915 bytes] Admin (talk | contribs) (Created page with "=== Database Restores/Refreshes/Recovery === Snapshot Standby Database (11g) Restore in between Upgrades | Restore in between Upgrades...")
- 23:09, 8 November 2019 Database Size (2) (hist) [161 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT TARGET_NAME , ROUND (SUM (FILE_SIZE) / 1024 / 1024 / 1024) GB FROM MGMT$db_datafiles_all GROUP BY TARGET_NAME </pre></blockquote>")
- 23:09, 8 November 2019 Database Size (1) (hist) [1,111 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> select a.DTTM , trim(substr(a.target_name, instr(a.target_name,'.')+1,20)) HOST_NAME , trim(substr(a.target_name, 1, instr(a.target_name,'.')-1))...")
- 23:08, 8 November 2019 Clearing Alerts (hist) [421 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT 'execute em_severity.delete_current_severity(p_target_guid =>'''||sev.target_guid||''', p_metric_guid =>'''||sev.metric_guid||''' , p_key_value...")
- 23:08, 8 November 2019 Datafile Size (hist) [345 bytes] Admin (talk | contribs) (Created page with "In my case, I used the following scripts to list the datafiles incorrectly set to unlimited, i.e. growing to 32768M. <blockquote><pre> SELECT target_name , file_name...")
- 23:07, 8 November 2019 Tablespace Allocated and Used (hist) [844 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT A.RT , A.ALLOCATED , B.USED FROM (SELECT TO_CHAR(ROLLUP_TIMESTAMP,'YYYY-MM') RT , AVG(AVERAGE) ALLOCATED FROM MGMT$...")
- 23:07, 8 November 2019 User Defined Metrics (hist) [287 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT * FROM mgmt$metric_current WHERE metric_name like '%UDM%'; </pre></blockquote> <blockquote><pre> SELECT * FROM mgmt$metric_hourly WHERE target...")
- 23:06, 8 November 2019 List DBs on AIX (hist) [1,173 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> select target_name , host_name from mgmt$target where target_type='oracle_database' and host_name in (select target_name...")
- 23:06, 8 November 2019 UDM Collection Interval (hist) [581 bytes] Admin (talk | contribs) (Created page with "You may have noticed that User Defined Metrics (UDM) in Oracle Enterprise Manager (OEM) have a minimum collection time of '''5''' minutes. If you wish to change this interva...")
- 23:04, 8 November 2019 High Level Steps to Migrate Datafiles (Disk Groups) (hist) [2,038 bytes] Admin (talk | contribs) (Created page with "Just some notes for my own reference. Had to migrate all my datafiles on a database from one Disk Group (DATA) to Another (DATAR), using RMAN to copy the datafiles. '''Pre-...")
- 23:03, 8 November 2019 Check Disk Groups (hist) [108 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT NAME, HEADER_STATUS, PATH, OS_MB FROM V$ASM_DISK ORDER BY NAME; </pre></blockquote>")
- 23:01, 8 November 2019 DBLinks not in Use (hist) [264 bytes] Admin (talk | contribs) (Created page with "<pre> select db_link from dba_db_links where db_link not in (select db_link from dba_db_links where db_link in (select referen...")
- 23:00, 8 November 2019 Trigger to Startup Pluggable Databases and Services (hist) [1,196 bytes] Admin (talk | contribs) (Created page with "The following trigger starts up all pluggable databases once the container database has been started and calls a stored procedure which starts up services which have been set...")
- 23:00, 8 November 2019 Dynamically Create/Drop Restore Points (hist) [1,260 bytes] Admin (talk | contribs) (Created page with "Task Objective: To create a Guaranteed Restore Point Dynamically and remove the earlier Restore Point if more than 2 exist. <blockquote><pre> set serveroutput on declare v_k...")
- 22:58, 8 November 2019 Enable Resumable (hist) [2,781 bytes] Admin (talk | contribs) (Created page with "As a DBA one thing I've seen quite a few times is tablespaces being maxed out by large data loads, which in turn leads to the data load being rolled back and developers having...")
- 22:58, 8 November 2019 Lookup v$ Views (hist) [549 bytes] Admin (talk | contribs) (Created page with "It's often difficult to remember which v$ view contains information you might be after. One way of quickly looking up the various views, is to run a query on the v$fixed_tabl...")
- 22:57, 8 November 2019 Create User Script (hist) [1,481 bytes] Admin (talk | contribs) (Created page with "There are many ways of cloning a user account or two from one database to another. Here are a few simple SQLs to dynamically generate scripts from the source database, which c...")
- 22:57, 8 November 2019 Sys Aux Statistics (hist) [376 bytes] Admin (talk | contribs) (Created page with "Note to-self: Hardware Stats are stored in <blockquote><pre> SYS.AUX_STATS$ </pre></blockquote> To gather the statistics: <blockquote><pre> exec dbms_stats.gather_system_st...")
- 22:56, 8 November 2019 Process Details with SQL Text (hist) [965 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT s.sid , p.pid , p.spid , s.process , s.status , s.username , s.osuser , s.program , a.name , s.client_inf...")
- 22:56, 8 November 2019 Logon Audit Trigger (hist) [1,557 bytes] Admin (talk | contribs) (Created page with "This is my version of a logon audit trigger. It picks up every iteration of a logon, even to the point of when a session switches from ACTIVE/INACTIVE mode. The more convent...")
- 22:55, 8 November 2019 Object with Block Corruption (hist) [722 bytes] Admin (talk | contribs) (Created page with "Identifying which object is corrupt in a block corruption .... ORA-01578: ORACLE data block corrupted (file # 54, block # 18689) <pre> select * from dba_extents where fil...")
- 22:55, 8 November 2019 Check Generated Archivelog Sizes (hist) [854 bytes] Admin (talk | contribs) (Created page with "Script may or may not work for everyone. The difficulty with this one is that it has to get the archivelog sizes from v$archived_log which could contain duplicate rows as ind...")
- 22:55, 8 November 2019 Check Database Size (hist) [295 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sum(megabytes) FROM ( SELECT sum(bytes)/1024/1024 megabytes FROM dba_temp_files UNION SELECT sum(bytes)/1024/1024 megabytes FROM...")
- 22:54, 8 November 2019 Check Oracle Open Cursors by Session (hist) [236 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> select o.sid, o.sql_text, o.address, o.hash_value, o.user_name, s.schemaname, o.sql_id from v$open_cursor o, v$session s where o.saddr = s.saddr a...")
- 22:53, 8 November 2019 Check Oracle Blocking Locks (hist) [752 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT to_char(sysdate,'yyyy-mm-dd hh24:mi') dttm , ' --- BLOCKER --- ' , lo.session_id , lo.process , lo.os_user_name , dob.object...")
- 22:52, 8 November 2019 Check Temp Tablespace Usage (hist) [300 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT distinct s.username , s.sid , s.serial# , s.osuser , u.tablespace , u.contents , u.segtype , u.extents , u.blo...")
- 22:52, 8 November 2019 Check Undo Tablespace Usage (hist) [109 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sum(blocks) , sum(bytes)/1024/1024 FROM dba_undo_extents; </pre></blockquote>")
- 22:51, 8 November 2019 Check Database UpTime in Unix (hist) [56 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> ps -ef | grep pmon </pre></blockquote>")
- 22:51, 8 November 2019 Scripts to monitor database is up (hist) [3,555 bytes] Admin (talk | contribs) (Created page with "Scenario is I do not have access to Oracle Enterprise Manager or any other monitoring utility and I need to make sure the database is up. Simply checking pmon is not enough,...")
- 22:05, 8 November 2019 Administrative-Tasks (hist) [1,919 bytes] Admin (talk | contribs) (Created page with " Scripts to monitor database is up Check Database UpTime in Unix Check Undo Tablespace Usage | C...")
- 22:02, 8 November 2019 Linux Filesystem Alerting Script (hist) [5,788 bytes] Admin (talk | contribs) (Created page with "This convoluted beauty does a df -h on both a Production and Standby Filesystem (oracle datafile and backup directories) and warns when the threshold of 85% is exceeded and al...")
- 22:01, 8 November 2019 SQL Across Multiple Servers with Password Prompts (hist) [791 bytes] Admin (talk | contribs) (Created page with "An example of a shell script which connects to multiple unix hosted databases and runs a simple SQL. This version prompts for the username/password. <blockquote><pre> #!/bin...")
- 22:01, 8 November 2019 SQL Across Multiple Servers (hist) [601 bytes] Admin (talk | contribs) (Created page with "An example of a shell script which connects to multiple unix hosted databases and runs a simple SQL. This version emails the logfile to people on the mailing list. <blockquot...")
- 21:59, 8 November 2019 Load Multiple (over 100,000) Files (hist) [1,853 bytes] Admin (talk | contribs) (Created page with "Requirement is to load 100,000+ CSV files via SQL Loader. Files are located in an Unix directory. Initially attempted to load the files through a single controlfile and it a...")
- 21:57, 8 November 2019 Change Apex 4.0 Admin Password (hist) [1,524 bytes] Admin (talk | contribs) (Created page with "To change the Admin user password on Apex 4.0 run the script '''apxxepwd.sql'''. This will change the encrypted password stored in table apex_040000.wwv_flow_fnd_user. '''Th...")
- 21:57, 8 November 2019 Check last DML time - if available (hist) [98 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre>select scn_to_timestamp(max(ora_rowscn)) from scott.employees;</pre></blockquote>")
- 21:56, 8 November 2019 CHANGE text on the current line (hist) [907 bytes] Admin (talk | contribs) (Created page with "A very basic feature of SQL *Plus which I had forgotten through the passage of time. Documented here so I don't forget again .. You use this to change values on the current...")
- 21:55, 8 November 2019 The glogin.sql File (hist) [672 bytes] Admin (talk | contribs) (Created page with "Whenever SQL *Plus starts up, it looks for a file named glogin.sql which is usually stored under $ORACLE_HOME/sqlplus/admin. You can modify this file to store settings, like...")
- 21:55, 8 November 2019 Create Table As (hist) [197 bytes] Admin (talk | contribs) (Created page with "To create a table identical to another table, yet without any of the data, simply use the following syntax: <blockquote><pre> CREATE tableA AS (SELECT * FROM tableB WHERE 1=2...")