Askdba - askdba.org - AskDba.org Weblog
General Information:
Latest News:
MGMTDB: Grid Infrastructure Management Repository 23 Jul 2013 | 12:27 pm
Original Post can be viewed at MGMTDB: Grid Infrastructure Management Repository MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data. In 11g this was being sto...
12c: Exporting Database Views as Tables 22 Jul 2013 | 06:17 pm
Original Post can be viewed at 12c: Exporting Database Views as Tables Starting Oracle Database 12c, you can export view to be imported as a table. There is no need to individually export each table,...
12c: Sqlplus Displays Last Login Time For Non – Sys Users 22 Jul 2013 | 02:36 pm
Original Post can be viewed at 12c: Sqlplus Displays Last Login Time For Non – Sys Users 12c database has introduced a pretty nifty Security feature which allows you to check last login time for non-...
12c:Limiting PGA with pga_aggregate_limit 7 Jul 2013 | 05:18 pm
Original Post can be viewed at 12c:Limiting PGA with pga_aggregate_limit This is a interesting feature for Oracle DBA’s. Till now there has been no way of limiting total PGA being used by oracle inst...
12c:Specifying lock timeout for finish_redef_table 3 Jul 2013 | 11:08 am
Original Post can be viewed at 12c:Specifying lock timeout for finish_redef_table Oracle 12c database has introduced enhancement to DBMS_REDEFINITION for specifying a a lock timeout (in seconds) whic...
Openfiler on Virtualbox and 12c Oracle Flex ASM 2 Jul 2013 | 08:07 pm
Original Post can be viewed at Openfiler on Virtualbox and 12c Oracle Flex ASM Last week Oracle released 12c database and Oracle blogosphere is bustling with lot of people posting details about new v...
portmap: unrecognized service on RHEL6 22 May 2013 | 05:27 pm
Original Post can be viewed at portmap: unrecognized service on RHEL6 Quick note for people using NFS for shared storage on RAC database. Till RHEL5 we had to ensure nfs,nfslock and portmap service h...
Recovering from Lost AWS EC2 Key 13 May 2013 | 03:39 pm
Original Post can be viewed at Recovering from Lost AWS EC2 Key This article is for AWS users using EC2 instances. Summary: Please backup your AWS EC2 Key file and you will never have to go through b...
cursor: pin S wait on X 2 May 2013 | 07:22 pm
Original Post can be viewed at cursor: pin S wait on X Few weeks back thread came up on oracle-l freelist regarding ”cursor: pin S wait on X” event . Tanel Poder replied to this thread with excellent...
Moving WordPress Blog to Amazon Web Services 26 Jan 2013 | 07:31 pm
Original Post can be viewed at Moving WordPress Blog to Amazon Web Services Why I moved?Setting up AWS EC2 InstanceConfiguring EC2 InstanceMigrating WordPress DataOptimizing Webhost SetupMaking actua...