Before executing check whether HA is deploye and take necessary precautions (cluster freeze). Consider impact on backup of the DB, full backup is required to restore data. Data changes between full backups will be lost in case of restore oracle@hostname:/oracle…
with t as (select t1.tablespace_name, round(t1.tot / 1024 / 1024, 2) tot, round(t2.free / 1024 / 1024, 2) free, round((t1.tot – t2.free) / 1024 / 1024, 2) used, round((t1.tot – t2.free) / t1.tot * 100, 2) per from (select tablespace_name,…
Ulock oracle after note shutdown during backup xhost:/dev/diskgroup # ll total 0 lrwxrwxrwx 1 root root 54 2015-12-14 14:50 dg_data -> /dev/disk/by-id/scsi-360022a11000e1c4c21965a9300000006 lrwxrwxrwx 1 root root 54 2015-12-14 14:50 dg_index -> /dev/disk/by-id/scsi-360022a11000e1c4c2196629300000007 lrwxrwxrwx 1 root root 8 2015-12-14 14:50…
oracle@xxxx01a:/oracle/app/product/11g/db/rdbms/admin> sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 – Production on Thu Sep 5 14:36:04 2013 Copyright (c) 1982, 2008, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production With the Partitioning, Oracle…
Examples Changing User Identification: Example The following statement changes the password of the user sidney (created in „Creating a Database User: Example“) second_2nd_pwd and default tablespace to the tablespace example: ALTER USER sidney IDENTIFIED BY second_2nd_pwd DEFAULT TABLESPACE example;…
-rw-r—– 1 oracle oinstall 61 Oct 4 16:00 ora11g_m000_8094.trm -rw-r—– 1 oracle oinstall 917 Oct 4 16:00 ora11g_m000_8094.trc -rw-r—– 1 oracle oinstall 62 Oct 4 16:07 ora11g_ora_23816.trm -rw-r—– 1 oracle oinstall 7149 Oct 4 16:07 ora11g_ora_23816.trc -rw-r—– 1 oracle oinstall…
Oracle Tips by Burleson Consulting Question: I need to measure the number of transactions per second on my Oracle database. Where can I find the Oracle transactions per second performance metric? Answer: First, let’s define transactions per second (TPS),…
post covers quick fix for temp tablespace issue (ORA-1652) which is to add temporary datafile and then find root cause of temp tablespace issue. Extent – An extent is a logical unit of database storage space allocation made up of a number…
Login as Oracle user $ sqlplus / as sysdba SQL> select * from v$version; The command output is similar to the following information: BANNER ——————————————————————————– Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production PL/SQL Release 11.1.0.7.0 – Production…
Data Control Language (DCL) Statements Data Control Language Statements are used to grant privileges on tables, views, sequences, synonyms, procedures to other users or roles. The DCL statements are GRANT :Use to grant privileges to other users or roles. REVOKE…
login as oracle user sqlplus „/ as sysdba“ show parameters NAME TYPE VALUE ———————————— ———– —————————— O7_DICTIONARY_ACCESSIBILITY boolean FALSE _undo_autotune boolean FALSE active_instance_count integer aq_tm_processes integer 0 archive_lag_target integer 0 asm_diskgroups string asm_diskstring string asm_power_limit integer 1 asm_preferred_read_failure_groups string Oracle…