oradbakar.blogspot.com

oradbakar

Thursday, June 30, 2016. How to check SGA resize operations? Initial size/1024/1024 "Initial",. TARGET SIZE/1024/1024 "Target",. FINAL SIZE/1024/1024 "Final",. To char(start time,'dd-mon hh24:mi:ss') start time,. To char(end time,'dd-mon hh24:mi:ss') end time. V$sga resize ops;. Current size/1024/1024 "CURRENT SIZE",. Min size/1024/1024 "MIN SIZE",. User specified size/1024/1024 "USER SPECIFIED SIZE",. Last oper type "TYPE",. To char(LAST OPER TIME,'dd-mon hh24:mi:ss') "LAST OPER TIME". Links to this post.

http://oradbakar.blogspot.com/

OVERVIEW OF oradbakar.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORADBAKAR.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.0 out of 5 with 9 reviews

5 star

5

4 star

1

3 star

2

2 star

0

1 star

1

Hey there! Start your review of oradbakar.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT ORADBAKAR.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

20

SSL

EXTERNAL LINKS

1

SITE IP

172.217.11.33

LOAD TIME

0.469 sec

SCORE

6.2

PAGE TITLE

oradbakar | oradbakar.blogspot.com Reviews

<META> DESCRIPTION

Thursday, June 30, 2016. How to check SGA resize operations? Initial size/1024/1024 Initial,. TARGET SIZE/1024/1024 Target,. FINAL SIZE/1024/1024 Final,. To char(start time,'dd-mon hh24:mi:ss') start time,. To char(end time,'dd-mon hh24:mi:ss') end time. V$sga resize ops;. Current size/1024/1024 CURRENT SIZE,. Min size/1024/1024 MIN SIZE,. User specified size/1024/1024 USER SPECIFIED SIZE,. Last oper type TYPE,. To char(LAST OPER TIME,'dd-mon hh24:mi:ss') LAST OPER TIME. Links to this post.

<META> KEYWORDS

1 oradbakar

2 select

3 component

4 oper type

5 oper mode

6 status

7 from

8 posted by

9 kartik shingala

10 no comments

CONTENT

Page content here

KEYWORDS ON PAGE

oradbakar,select,component,oper type,oper mode,status,from,posted by,kartik shingala,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,sql startup;,df h,dev/mapper/vg bodb lv root,dev/mapper/bodb oradata oradata,begin

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

oradbakar | oradbakar.blogspot.com Reviews

https://oradbakar.blogspot.com

Thursday, June 30, 2016. How to check SGA resize operations? Initial size/1024/1024 "Initial",. TARGET SIZE/1024/1024 "Target",. FINAL SIZE/1024/1024 "Final",. To char(start time,'dd-mon hh24:mi:ss') start time,. To char(end time,'dd-mon hh24:mi:ss') end time. V$sga resize ops;. Current size/1024/1024 "CURRENT SIZE",. Min size/1024/1024 "MIN SIZE",. User specified size/1024/1024 "USER SPECIFIED SIZE",. Last oper type "TYPE",. To char(LAST OPER TIME,'dd-mon hh24:mi:ss') "LAST OPER TIME". Links to this post.

INTERNAL PAGES

oradbakar.blogspot.com

1

oradbakar: Oracle PSU VS CPU patch???

http://oradbakar.blogspot.com/2012/07/oracle-psu-vs-cpu-patch.html

Thursday, July 19, 2012. Oracle PSU VS CPU patch? 1)CPU(Critical Patch Update):(includes all critical patches). Critical Patch Update, quarterly delivered by Oracle to fix security issues. 2)PSU(Patch Set Update): (includes only "recommended" and "proactive" patches). PatchSet Update, also quarterly delivered by Oracle,it includes CPU and a bunch of other one-off patches. Subscribe to: Post Comments (Atom). There was an error in this gadget. View my complete profile. Simple theme. Powered by Blogger.

2

oradbakar: How to read data from oracle datafiles?

http://oradbakar.blogspot.com/2012/10/how-to-read-data-from-oracle-datafiles.html

Saturday, October 13, 2012. How to read data from oracle datafiles? Hexdump t1 luis1.dbf -C grep 'S'. Subscribe to: Post Comments (Atom). There was an error in this gadget. With somewhat diversified experience I am trying to put together things that may help other IT professionals. Please feel free to post questions if any. View my complete profile. Simple theme. Powered by Blogger.

3

oradbakar: What is data pump master table???

http://oradbakar.blogspot.com/2012/05/what-is-data-pump-master-table.html

Wednesday, May 9, 2012. What is data pump master table? Oracle table that is used to store information about the Data Pump job. Master table can be accessed in SQLPLUS. Not deleted if job is stopped. Deleted after job is complete or killed. Labels: oracle data pump master table. Subscribe to: Post Comments (Atom). There was an error in this gadget. With somewhat diversified experience I am trying to put together things that may help other IT professionals. Please feel free to post questions if any.

4

oradbakar: DB user activity tracking

http://oradbakar.blogspot.com/2013/08/db-user-activity-tracking.html

Monday, August 19, 2013. DB user activity tracking. Col SAMPLE TIME format a25. Col sql text format a75. Col program format a25. Col machine format a25. Col event format a30. SELECT sample time,. Substr(event,0,30) event,. Substr(program,0,25) program,. Substr(sql text,0,75) sql text. FROM gv$active session history gvash,. WHERE gvash.user id =58. AND gvs.sql id = gvash.sql id. AND gvash.inst id = gvs.inst id and sql text is not null and sample time like '31-JUN-13 %';. Subscribe to: Post Comments (Atom).

5

oradbakar: How to find out cpu cores from within oracle???

http://oradbakar.blogspot.com/2012/05/how-to-find-out-cpu-cores-from-within.html

Wednesday, May 9, 2012. How to find out cpu cores from within oracle? MAX(DECODE(STAT NAME,'NUM CPUS',VALUE,1) CPUS,. MAX(DECODE(STAT NAME,'NUM CPU CORES',VALUE,1) CPU CORES,. Max(decode(STAT NAME,'PHYSICAL MEMORY BYTES',round(VALUE/1024/1204),1) Memory MB. Labels: find out cpu cores from within oracle sqlplus. Subscribe to: Post Comments (Atom). There was an error in this gadget. View my complete profile. Simple template. Powered by Blogger.

UPGRADE TO PREMIUM TO VIEW 15 MORE

TOTAL PAGES IN THIS WEBSITE

20

OTHER SITES

oradba4all.blogspot.com

ORACLE DBA

Wednesday, 27 May 2015. Changing NLS CHARACTERSET From WE8MSWIN1252 to UTF8. Before beginning, make sure:-. There is a full backup of the database taken available. There is a backup of the current spfile (especially for RAC databases). STEP 1) INSTALL CSSCAN SCHMEA IF not Install. STEP 2) Record the SCN number,parameters at this point, Incase of restore. Check full database and archivelog back has been completed. Sqlplus '/ as sysdba'. Note the parameters- - - - - - - - - - - - - - - - - - - - - -. Once ...

oradbablog.blogspot.com

Neil's Oracle DBA blog

Neil's Oracle DBA blog. Monday, July 26, 2010. Just to show that I do keep this blog up to date I thought I'd announce that the voting for the next Oracle Scene editor will shortly be opening for all UKOUG members. I am standing for this position being the technical editor for the last 3 yrs. Posted by Neil jarvis @ 11:46 AM. Thursday, March 01, 2007. ORA-00821 Specified value of sga target is too small, needs to be at least. Resized your SGA TARGET too small and found you can’t now start your database.

oradbaeasy.wordpress.com

Mayil oracle blog

Importing and Exporting Oracle Database Using Datapump Utility. Posted by Mayilselvan Subramanian on June 11, 2009. Oracle Data pump utility enables very fast bulk data and metadata movement between Oracle databases. It provides parallel Export and Import utilities ( expdp and impdp. And Web-based Oracle Enterprise Manager Interface. Data Pump jobs can be restarted without loss of data, whether or not the stoppage was voluntary or involuntary. 8211; Client interface to the Data Pump Export utility. T...

oradbaindia.wordpress.com

ORACLE WRITES | Technical Articles by Kanchana Selvakumar

Technical Articles by Kanchana Selvakumar. Cache Fusion .contd. Client Result Cache -11gr2. Rac On One node. RMAN and block corruption. On January 4, 2014 by Kanchana Selvakumar. The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt:. A San Francisco cable car holds 60 people. This blog was viewed about 1,500. Times in 2013. If it were a cable car, it would take about 25 trips to carry that many people. Click here to see the complete report. In RAC environm...

oradbakar.blogspot.com

oradbakar

Thursday, June 30, 2016. How to check SGA resize operations? Initial size/1024/1024 "Initial",. TARGET SIZE/1024/1024 "Target",. FINAL SIZE/1024/1024 "Final",. To char(start time,'dd-mon hh24:mi:ss') start time,. To char(end time,'dd-mon hh24:mi:ss') end time. V$sga resize ops;. Current size/1024/1024 "CURRENT SIZE",. Min size/1024/1024 "MIN SIZE",. User specified size/1024/1024 "USER SPECIFIED SIZE",. Last oper type "TYPE",. To char(LAST OPER TIME,'dd-mon hh24:mi:ss') "LAST OPER TIME". Links to this post.

oradbapp.blogspot.com

O R A C L E Database & Applications

O R A C L E Database and Applications. Contribution to Oracle apps and database. Keep visiting for more updates. Wednesday, February 3, 2016. Adfgclone.pl in 12.2 failed while ohsT2PApply process. Adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. Below are the errors found in logfiles. Tmp/CLONINGCLIENT-1008723463327980977/clone asinstance start process-1337948214.log. 2015-12-02T3:10:04-06:00] [opmn] [ERROR:1] [] [internal]. SEVERE : Dec 2,...

oradbapro.blogspot.com

Oracle Adminstration

Jul 16, 2015. How to use opatch auto. OPatch auto automaticaly patch the typical Grid Infrastructure (GI) and RAC home directories with minimal intervention. OPatch auto performs many of the pre-patch checks as well as the post-patch verification. OPatch auto lies in its ability to perform end-to-end configuration patching (patching a GI or RAC home based on its configuration.) By incorporating the configuration information into the patch process. Root@v-box1 ]# $ORACLE HOME/ OPatch. Patch GI home - - - ...

oradbaro.wordpress.com

oradbaro | Focusing On Oracle Database Administration

Focusing On Oracle Database Administration. Citate care ma inspira. Etapele de pornire și oprire unei baze de date Oracle. In articolele precedente am menționat de mai multe ori modul în care este deschisă o bază de date Oracle dar nu am explicat ce presupune fiecare dintre aceste etape. Pentru cititorii care au zâmbit la imaginea de mai jos următoarele rânduri s-ar putea sa nu vina cu ceva nou, pentru cei care urmează sa se inițieze în tainele bazelor Oracle va recomanda sa citiți mai departe. 8211;&#82...

oradbas.blogspot.com

OraDBAs

Converted by Falcon Hive. DB2 Basics Lesson 2 "The DB2 Environment" (Video). This Lesson divided into two parts:. Note: If you experience any difficulties in understanding the accent you can find the transcript below. Lesson 2 Transcript: Part 1 of 2 - The DB2 Environment. Welcome to Lesson 2 of the DB2 on Campus lecture series. Today we're going to talk about the. DB2 environment, and this is part 1 of 2 parts. My name is Raul Chong and I'm the DB2 on. Slide 3: DB2 the big picture. Now is this grey box,...

oradbastuff.blogspot.com

Sfaturi Oracle / Tips and tricks OracleDBA

Sfaturi Oracle / Tips and tricks OracleDBA. You've got to have a dream. When you lose your dreams, you die. 8222;Învăţaţi, mamă, că o să plecaţi la casele voastre, şi-o să creşteţi copii şi o să trăiţi şi voi în lume printre oameni şi să vă aveţi bine cu ei". Asta e adevărata tragedie a României generației noastre. Nu așa-zisa "persecuție" a miliardarilor și a politicienilor cu televizoare la butonieră. Sau cine știe ce alte tembelisme bune de amețit poporul. Asta e, asta e țara noastră:. Vă știu pe unii...