Ulfat`s DataBase Blog

Today I decided to increase memory but before that I wanted to change sga_max_size`s value. Because in my production database configured sga_max_size to 12Gb. It means independing on busy or idle of instance state, SGA could not be more than 12GB (it is worse). The SGA_MAX_SIZE specifies the maximum size of the SGA for the lifetime of the instance. Our instance configured AMM: select name, value from v$parameter where name like 'memory%'   memory_target    32212254720 memory_max_target    32212254720 --Checking init file -bash-3.2$ more initPROD.ora| grep -i sga PROD.__sga_target=12616466432 *.sga_max_size=25769803776 *.sga_target=0 -bash-3.2$ SGA_MAX_SIZE is not dynamic value, after changing those value, you should restart instance. SQL> show parameter sga NAME                                 TYPE        VALUE ------------------...

Today I requested that while dropping user request hanged after some time. Let`s to check: -bash-3.00$ sqlplus "/as sysdba" SQL*Plus: Release 11.1.0.7.0 - Production on Wed Oct 23 15:52:36 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, OLAP, Data Mining and Real Application Testing options SQL> drop user fcjlive cascade; Checking alert log --checking alertlog -bash-3.00$ tail -50 alert_PROD.log ORA-12012: error on auto execute of job 3149 ORA-01435: user does not exist Wed Oct 23 16:02:19 2013 Errors in file /u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_j000_20447444.trc: ORA-12012: error on auto execute of job 3149 ORA-01435: user does not exist Wed Oct 23 16:04:19 2013 Errors in file /u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_j000_20447450.trc: ORA-12012: error on auto execute of job 3149 ORA-01435: user do...

Hi, today I will post interview with young beautiful woman, Oracle 10g and 11g OCM certified - Lucia Hustatyova. She is one of the seldom DBA woman which have had OCM 10g and 11g certified. After graduating from high school in Bardejov Stockel Leonard continued his studies at the University of Pavol Jozef Safarik in Kosice, the first scientific maths, later to study maths and science. Thanks opportunities in Kosice as a student she worked at various companies for part-time positions. The last six years working as a database consultant at famous company in Slovakia . Q: Lucia, when did you pass that certified exam and where did you do it? A: Oracle 10g OCM in Slovakia 2011, 11g also Slovakia but in 2012. Q: How many years have you had experience with Oracle? A: 6 years. Q: What is your job responsibility and where currently are you in charge? A: I am database admin at leader IT company - mainly practical stuff but sometimes my colleagues need consultations duri...

Example of recovery database until time. For checking after recovery I am going to create simple table with one row SQL> create user ulfet identified by ulfet; User created. SQL> grant dba to ulfet; Grant succeeded. SQL> conn ulfet/ulfet Connected. SSQL> create table test1 (id number); Table created. SQL> insert into test1 values(1); 1 row created. SQL> commit; Commit complete. Now taking backup. RMAN> backup database plus archivelog; --note date SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 13-JAN-16 11.03.34.646076 AM +04:00 --dropping table SQL> drop table ulfet.test1; Table dropped. SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------------------------------------------- 13-JAN-16 11.04.40.428868 AM +04:00 SQL> --start recovery process --firstly start...

Today while duplication database I faced strange error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 07/09/2013 16:02:16 RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed ORA-01130: database file version 11.1.0.0.0 incompatible with ORACLE version 11.0.0.0.0 ORA-01110: data file 1: '/u01/app/oracle/oradata/DUPLPROD/system01.dbf' I checked all actions and tried again, but result was same. Error happened creation control file. Let me note that I used to duplication on the same host and Oracle version 11.1.0.7.0 SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL R...

So, finally Oracle introduced Oracle database 12c (12.1.0.1). You can easily download it from oracle`s official site : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html For now only for Linux and Solaris platform`s download is available, soon for windows platform will have.

Today my friend asked me what is the different between kill session and disconnect session. After researching I found useful information and here I`m going to share briefly. Using Disconnect Session clause to disconnect the current session by destroying the dedicated server process. Using Kill Session clause let you mark a session as terminated, release locks. Example: SQL>ALTER SYSTEM DISCONNECT SESSION 'sid,serial#'; SQL>ALTER SYSTEM KILL SESSION 'sid,serial#'; For more details please refer to :  http://oracletempspace.wordpress.com/2011/04/20/example-alter-sytem-disconnect-vs-alter-system-kill-for-currently-connected-sessions/