• About Me

    Maxwell Miranda
    Oracle DBA Consultant.
  • Category

  • Archives

  • My Blog Calendar

    September 2009
    M T W T F S S
    « Aug   Oct »
  • RSS Oracle Feeds

    • Flashback database to date back and forth
      Code: --------- SELECT NAME, TIME FROM v$restore_point order by time; NAME TIME ---------------------------------------- ----------------------------------- RST_PNT_20180306_1135 06-MAR-18 AM *Got flashbacked to this 6th Mar* RST_PNT_20180308_0132 08-MAR-18 AM RST_PNT_20180315_0332 15-MAR-18 AM RST_PNT […]
    • Downgrade database from Oracle to Oracle using catdwgrd.sq
      Downgrade database from Oracle to Oracle Like to know if any one successfully downgraded the database from version Oracle 12cR2 ( Release 2) to Oracle 11g Release 2 ( using manual method of catdwgrd.sql. Please share your views and inputs as we are unable to downgrade it successfully. Refereed the https://docs.oracle.com/en/databa […]
    • New user in oracle having access to all tables
      Hi, I have created a new user in oracle database as follows create new user u1 identified by u1; grant create session to u1; when I login with new user ,it has access to all tables in other schema except system and sys tables. i want to create a user who does not have access to any table on any schema. how it can be achieved? Thanks
    • Auditing userid creation, deletion and changes to roles granted.
      Is there an oracle auditing option to audit userid creation, deletion and changes made to the userid (system/object privileges granted or revoked)?
    • ORACLE SQL - Adding Results from Multiple Select Statements
      I apologize if this question is not in the correct area. I have eight select statements, each to get the sum of particular information. These are not simple queries, so I will not include them here. I have made up a simpler version (based on some code I found in a forum) as shown below. So, I have eight sums. I need a ninth sum that is the total of all eight […]
    • Cannot change undo_tablespace parameter in RAC node
      Hi, I am trying to change the undo tablespace in DB instance, unsuccessfully. Approach 1: SQL> show parameter undo NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ temp_undo_enabled boolean FALSE undo_management string AUTO undo_retention integer 900 undo_tablespace string *UNDOTBS2* SQL> SQL> ALTER SYS […]
  • Advertisements

Log Switch details

set lines 120;
set pages 999;
to_char(first_time,’YYYY-MM(MON)-DD’) day,
to_char(sum(decode(to_char(first_time,’HH24′),’00’,1,0)),’99’) “12a”,
to_char(sum(decode(to_char(first_time,’HH24′),’01’,1,0)),’99’) “1a”,
to_char(sum(decode(to_char(first_time,’HH24′),’02’,1,0)),’99’) “2a”,
to_char(sum(decode(to_char(first_time,’HH24′),’03’,1,0)),’99’) “3a”,
to_char(sum(decode(to_char(first_time,’HH24′),’04’,1,0)),’99’) “4a”,
to_char(sum(decode(to_char(first_time,’HH24′),’05’,1,0)),’99’) “5a”,
to_char(sum(decode(to_char(first_time,’HH24′),’06’,1,0)),’99’) “6a”,
to_char(sum(decode(to_char(first_time,’HH24′),’07’,1,0)),’99’) “7a”,
to_char(sum(decode(to_char(first_time,’HH24′),’08’,1,0)),’99’) “8a”,
to_char(sum(decode(to_char(first_time,’HH24′),’09’,1,0)),’99’) “9a”,
to_char(sum(decode(to_char(first_time,’HH24′),’10’,1,0)),’99’) “10a”,
to_char(sum(decode(to_char(first_time,’HH24′),’11’,1,0)),’99’) “11a”,
to_char(sum(decode(to_char(first_time,’HH24′),’12’,1,0)),’99’) “12p”,
to_char(sum(decode(to_char(first_time,’HH24′),’13’,1,0)),’99’) “1p”,
to_char(sum(decode(to_char(first_time,’HH24′),’14’,1,0)),’99’) “2p”,
to_char(sum(decode(to_char(first_time,’HH24′),’15’,1,0)),’99’) “3p”,
to_char(sum(decode(to_char(first_time,’HH24′),’16’,1,0)),’99’) “4p”,
to_char(sum(decode(to_char(first_time,’HH24′),’17’,1,0)),’99’) “5p”,
to_char(sum(decode(to_char(first_time,’HH24′),’18’,1,0)),’99’) “6p”,
to_char(sum(decode(to_char(first_time,’HH24′),’19’,1,0)),’99’) “7p”,
to_char(sum(decode(to_char(first_time,’HH24′),’20’,1,0)),’99’) “8p”,
to_char(sum(decode(to_char(first_time,’HH24′),’21’,1,0)),’99’) “9p”,
to_char(sum(decode(to_char(first_time,’HH24′),’22’,1,0)),’99’) “10p”,
to_char(sum(decode(to_char(first_time,’HH24′),’23’,1,0)),’99’) “11p”


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: