Feed aggregator

Tips to Manage Work from Home

OraQA - Mon, 2021-10-25 07:40

Nowadays, people are working more from home because of COVID’19. Whether you are willing to work remotely or looking to manage your work, the following tips will help you to maintain your work and stay productive. 

From March 2020, people have started working more from home. However, companies do not have much time to look after the people who are working remotely and maintain an online environment. However, no one knows that how long this remote work will last. If you are new to this remote work lifestyle, you have to manage things so that you can have success in working from home. 

Everyone who is willing to work from home must figure out where, when, and how to work. Before you start working from home, you have to build boundaries between your personal life and work. Here are the leading tips for working from home that can make your remote work productive.

Maintaining Working Hours

Make your proper schedule and stick to it. Having clear guidelines about when and where to work, helps many remote workers in maintaining their tasks. One of the biggest advantages of remote work is flexibility when the job allows it. Sometimes you need to start working early so that you can respond to coworkers in their time zone. When you are done with it, make sure to wrap it up earlier and sleep a bit early so that the next morning you can wake up for work. 

You can also download a time tracking app to check whether you are sticking to your schedule or not. These apps also tell you that what time of day you are sticking to your schedule and when you are lacking off. 

Develop a Morning Routine

Deciding that you will sit on your chair and start working is one thing. Creating a routine that will guide you to be in the chair is another thing. A routine is more powerful than the clock. What morning tasks will indicate that you are about to start your work? It would be a cup of tea or coffee before you get to check your To-Do List. Look at your existing habits like brushing teeth or coming from a morning walk, which can act as a signal. This way you can check up on your workday instead of kicking it. A morning routine doesn’t mean having a 9 to 5 schedule, you can start your routine at another time of day as well. However, look for your existing habit and try to start your work from there.

Set Your Rules

Set some rules with the people you are at your home and with the people who are sharing work with you. For instance, if you have children who are coming from school or learning from home, they must know the rules regarding what they can or cannot do at that time. If you are sharing your work with someone who is also working from home, then you have to arrange a meeting many times and share equipment like chair and desk. 

Moreover, by setting some rules and regulations you can work easily and efficiently and this will help you in maintaining your productivity.

Arrange Breaks

If you are working with the company, you should know about their break time policy and utilize them. If you are a freelancer, give some time to yourself and walk away from your laptop and phone. 

The two 15 minutes break and a lunch hour seem to be standard break times for US employees. It is essential to take breaks and move to have blood circulation once in an hour. Furthermore, it will also allow you to take your eyes off the screen on regular basis. You can also have a micro-break of 10 to 20 seconds. 

Don’t Change Your Mind

Don’t change yourself during short breaks, especially on your meal break. However, there are apps that will allow you to set a schedule for yourself, when you lock your screen. These apps also have a pause feature that will allow you to have a 15 minute or an hour break. If you don’t need any apps in your life, then set an alarm or a timer on your phone or your computer and keep an eye on the time on the standard clock. No matter how you take breaks but make sure that after the break you start working. For example, if you’re having a 30 minute break then go to your table after 20 minutes, and walk away for 10 minutes.

Go From Home

If it is safe outside, then leave your home and move out for some time. Your body also needs movements for blood circulation. Moreover, the fresh air and nature will make you feel better and do good. You must step outside before, after, and between the working hours for a short break. 

The same advice is also for the people who are working in the office. You must leave the building for at least 10 to 15 minutes during working hours. During non-pandemic time, home-based workers can also go to cafes, libraries, and co-working places to break up the boredom of being at home. 

However, this is great but you can also move out of the house and get some fresh air and natural light. To take a break, you don’t need to go to crowded places, You can just get away from your workplace, take a break, sit in the garden, and get the picture. 

Do Ask Whatever You Need

If your organization doesn’t support work from home set up, ask for the equipment required for the work, or within the few days of realizing you need something, so that you can start the work as soon as possible. It is essential to note down whatever is required for your job to be done comfortably. 

Your essentials can be a keyboard, mouse, monitor, printer, desk, chair, and others. Organizations that work with home-based workers also have a budget for home-based workers. However, some remote organizations also allow employees to bring a consultant to evaluate their workspace. Furthermore, if you are working from home for a short time, then do ask for the necessary equipments and be ready to do acceptable compromises. Don’t order so many things that cost high, you can just order a mouse, keyboard, monitor, printer, or the things which are necessary for your work that can cost below $2000.

Have a Proper Office Space

In today’s world, remote employees need not only a proper office but also two computers, one for personal use and one for work. It is secure for the employees as it keeps your personal activities private. However, not everyone has a separate room for office use at home, so keeping two machines sometimes becomes difficult. 

Instead of two machines, you must have a desk and things which are necessary for home-based work. However, in one machine, you can also part Your hard drive and create a separate user account for personal activity. Making small differences between your work time and separate time will help your brain know, when it is time to work and when it’s not.

Have a Separate Phone Number and Good Internet

You must have a separate phone number that you can only use for contacting your clients and colleagues. For this, you don’t need to have a second mobile phone or a separate landline, you can also have another SIM card. Moreover, it can be some other services like Skype or Google Voice. Just like the other tips, having another SIM card will help you in maintaining your work life and your personal life equally. Also you need Internet with fast speed and good pings link BUYTVINTERNETPHONE

VPN Usage

Use a VPN, whenever you get connected to the network that is not in your control. It includes Wi-Fi at cafes, co-working places, Airports, libraries, hostels, and so on. However, many organizations have their own VPN that can be Used by their own employees, that access through some website where the personal information of that organization has been stored. In these cases, you also need to access the VPN at home. It would be good if you leave your VPN connected whenever it is possible because it is always safe to have it. One essential point about VPN is that if you are connected to a company’s VPN, then the company knows whatever you are doing.

Parting Thoughts

From all the above information, figure out which one suits you the best. Sometimes the answer is obvious, But the other time you might require some motivation from the other  remote-based employees. A supportive group of employees do exist, whether you find them in your organization, or online through blogs or other communication platforms, do consider them. However, you must need to shuffle your routine once and then get back to it.

The post Tips to Manage Work from Home appeared first on ORA QA.

MLOps: Extend Skipper ML Services

Andrejus Baranovski - Mon, 2021-10-25 06:44
The goal of this video is to explain Skipper from MLOps user perspective, different blocks of Skipper and how they fit together. I show how a sample set of ML services works and how you could replace it or add your own service. Skipper engine is implemented with Python, but you could add service container implemented in any language. All runs on Kubernetes.

 

CI CD Pipeline using Jenkins

Online Apps DBA - Mon, 2021-10-25 00:16

As we know, software packages are created and published  regularly, so it can be challenging  to manage all the applications .  Thus, various automation processes and tools were proposed. Jenkins ➽ Jenkins is an open-source automation tool for Continuous Integration (CI) and Continuous Deployment (CD).  Why Jenkins ➽ It is widely used open source tool that can be […]

The post CI CD Pipeline using Jenkins appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Certified Kubernetes Administrator | Day 8: K8s Ingress Controller, ConfigMap, Helm package manager, Init-Containers [CKA/D]

Online Apps DBA - Sat, 2021-10-23 07:26

 Ingress Controller ➪ A Kubernetes Ingress controller is a load balancer designed specifically for Kubernetes environments. The ingress controller will accept traffic from outside the Kubernetes network and distribute it to pods (containers) running on the platform. It can handle egress traffic within a cluster for services that need to talk to other services outside […]

The post Certified Kubernetes Administrator | Day 8: K8s Ingress Controller, ConfigMap, Helm package manager, Init-Containers [CKA/D] appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Python OOPs Concepts, Error And Exception Handling Q & A: Day 4 Live Session Review Classes and Objects

Online Apps DBA - Sat, 2021-10-23 07:15

 A class can be thought of as a ‘blueprint’ for objects. These can have their own attributes (characteristics they possess), and methods (actions they perform). Objects have member variables and have behavior associated with them.  In python, a class is created by the keyword class  An object is created using the constructor of the class. […]

The post Python OOPs Concepts, Error And Exception Handling Q & A: Day 4 Live Session Review Classes and Objects appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

DevOps for Beginners Day 4 | Docker, Ansible and Terraform

Online Apps DBA - Sat, 2021-10-23 06:58

Docker is an open-source platform based on Linux containers for developing, shipping, and running applications inside containers. We can deploy many containers simultaneously on a given host. Containers are software packages into an invisible box with everything that the application needs to run. That includes the operating system, application code, runtime, system tools, system libraries, […]

The post DevOps for Beginners Day 4 | Docker, Ansible and Terraform appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

AWS Solution Architect Interview Questions and Answers in 2021

Online Apps DBA - Fri, 2021-10-22 08:20

Are you looking  for some Solutions Architect Sample Questions to practice  for your Interview  Here is the list of  AWS Solutions Architect Interview Questions that are best for AWS Solution Architect  ➪ An AWS Solution Architect aspirant should get deep knowledge and experience with core cloud architecture concepts. Top Interview Questions will help them garnish their skill before any Interview. […]

The post AWS Solution Architect Interview Questions and Answers in 2021 appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

[Recap] Day 8: Secure Data and Application in Cloud Part-II

Online Apps DBA - Fri, 2021-10-22 08:15

What do you think of the word base? Confused!  Let’s simplify it by adding prefix Data.Let’s talk about the Database:Do you think it’s essential to secure a company database?I must say no doubt that it is a backbone of a company and a sweet spot for hackers. So it is very critical to secure a […]

The post [Recap] Day 8: Secure Data and Application in Cloud Part-II appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

[Recap] Day 2: DevOps And Other Frameworks, Roles and Responsibility, Best Practices, Automation, Adopting DevOps [DevOps for Beginners]

Online Apps DBA - Fri, 2021-10-22 08:05

DevOps is not just about relying on tools and do automation in the Projects for fast working. DevOps is a culture that an organisation have to adopt and follow. There are various DevOps frameworks that you need to understand before you adopt the process. These frameworks are project management processes already in use or were […]

The post [Recap] Day 2: DevOps And Other Frameworks, Roles and Responsibility, Best Practices, Automation, Adopting DevOps [DevOps for Beginners] appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Recover Dropped User Using Standby Database

Michael Dinh - Thu, 2021-10-21 19:18

A critical user was accidentally dropped around one week ago and will need be recovered.

Here are semi detailed steps used to flashback standby database, export user from standby, and import to primary.

============================================================
### Recover user that was deleted about week ago.
============================================================

Request Created: 14/Oct/2021 6:41 AM

DB version: 12.1.0.2.0 

==============================
### CURRENT FLASHBACK INFO:
==============================

SQL>

NAME  DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
----- -------------- --------- ----------------
ORC1  STANDBY1       MOUNTED   PHYSICAL STANDBY

 INST OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TIME RETENTION_TARGET FLASHBACK_MB EST_FLASHBACK_MB
----- -------------------- --------------------- ---------------- ------------ ----------------
    1 984681951010         04-OCT-2021 18:44:28  7200             1767000      895861

CURRENT_SCN
------------
985044762265

SQL>

==============================
### STOP STANDBY APPLY:
==============================

DGMGRL> edit database 'STANDBY1' set state='APPLY-OFF';
Succeeded.

DGMGRL>

========================================
### FLASHBACK USING TIMESTAMP FAILED:
========================================

SQL> shutdown abort;
SQL> startup mount restrict exclusive;

SQL> flashback database to timestamp TO_TIMESTAMP('2021-10-05 00:00:00','YYYY-MM-DD HH24:MI:SS');
flashback database to timestamp TO_TIMESTAMP('2021-10-05 00:00:00','YYYY-MM-DD HH24:MI:SS')
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL>

========================================
### FLASHBACK USING SCN: 
to_timestamp can't convert to SCN properly
========================================

SQL> flashback database to scn 984681951011;

========================================
### FLASHBACK WILL EVENTUALLY FAIL:
========================================

SQL> flashback database to scn 984681951011;

flashback database to scn 984681951011
*
ERROR at line 1:
ORA-38861: flashback recovery stopped before reaching recovery target

SQL> 

========================================
### CHECK ALERT LOG:
========================================

Thu Oct 14 13:59:52 2021
Errors in file /u01/app/oracle/diag/rdbms/STANDBY1/ORC1/trace/ORC1_pr00_12838.trc:
ORA-00283: recovery session canceled due to errors
ORA-38861: flashback recovery stopped before reaching recovery target
ORA-16016: archived log for thread 1 sequence# 477183 unavailable
ORA-38861: signalled during: flashback database to scn 984681951011...

========================================
### RESTORE ARCHIVELOG from alert log:
========================================

RMAN> restore archivelog logseq 477183;

========================================
### CONTINUE FLASHBACK:
========================================

SQL> flashback database to scn 984681951011;

========================================
### DO NOT OPEN READ ONLY 
WITHOUT CANCELING REDO APPLY WITHOUT ADG.
========================================

Active Data Guard enables read-only access to a physical standby database while Redo Apply is active.

SQL> recover managed standby database cancel;
SQL> alter database open read only;

========================================
### CHECK FOR DROPPED USER:
========================================

SQL> select created, username from dba_users where username='XXX';

CREATED                    USERNAME
-------------------------- --------
2008-SEP-18 20:19:33       XXX
SQL>

========================================
### USING DATAPUMP DID NOT WORK:
========================================

How To Use DataPump Export (EXPDP) To Export From Physical Standby Database (Doc ID 1356592.1)

--- For physical standby
We can execute exp in physical standby database when it is in read only
https://dbaminds.wordpress.com/2016/01/07/perform-export-expdp-from-physical-standby-and-logical-standby/

--- Use Snapshot Standby - did not test.
https://dohdatabase.com/2021/04/22/datapump-export-from-data-guard/

========================================
### EXP WORKED: PERFORMED BY CLIENT
========================================

### From STANDBY:
$ cat exp.par
file=exp.dmp
compress=n
grants=y
indexes=y
direct=y
log=exp.log
rows=y
consistent=y
owner=schema
triggers=y
constraints=y

exp userid=system parfile=exp.par
scp exp.dmp oracle@target:/home/oracle/

### From PRIMARY:
$ cat imppar
file=exp.dmp
grants=y
indexes=y
rows=y
log=imp.log
fromuser=schema
commit=n
constraints=y
compile=y

imp userid=system parfile=imp.par

========================================
### RECOVER STANDBY TO CURRENT TIME:
========================================

SQL> recover managed standby database using current logfile parallel 4 disconnect;
Media recovery complete.
SQL>

========================================
### RESTORE ARCHIVELOG TO FRA IS BEING DELETED:
========================================

Example:
Thu Oct 14 18:02:30 2021
Deleted Oracle managed file +FRA/STANDBY1/ARCHIVELOG/2021_10_14/thread_1_seq_477816.752.1085939417

Thu Oct 14 18:02:31 2021
Deleted Oracle managed file +FRA/STANDBY1/ARCHIVELOG/2021_10_14/thread_1_seq_477794.1120.1085939341

========================================
### RESTORE ARCHIVELOG TO NEW DESTINATION:
========================================

mkdir -p /ubb1/rman/ORC1/archivelog

========================================
### CHECK ALERT LOG FOR GAP SEQUENCE:
========================================

grep 'Fetching gap sequence in thread' /u01/app/oracle/diag/rdbms/STANDBY1/ORC1/trace/alert_ORC1.log

========================================
### RESOLVE ARCHIVE GAP:
========================================

Fetching gap sequence in thread 1, gap sequence 477604-477604

RMAN> run {
set archivelog destination to '/ubb1/rman/ORC1/archivelog';
restore archivelog from sequence 477604 until sequence 477604;}2> 3>

========================================
### FOR REFERENCE: 157 gap sequences
========================================

$ grep -c 'Fetching gap sequence in thread' /u01/app/oracle/diag/rdbms/STANDBY1/ORC1/trace/alert_ORC1.log
157

========================================
### RECOVER ALL ARCHIVELOG TO SAVE TIME:
========================================
 
SQL> r
  1  select PID,inst_id inst,thread#,client_process,process,status,sequence#,block#,DELAY_MINS
  2  from gv$managed_standby
  3  where BLOCK#>1
  4  and status not in ('CLOSING','IDLE')
  5  order by status desc, thread#, sequence#
  6*

                                        CLIENT                                                  DELAY
PID                       INST  THREAD# PROCESS      PROCESS   STATUS       SEQUENCE#   BLOCK#   MINS
------------------------ ----- -------- ------------ --------- ------------ --------- -------- ------
8723                         1        1 LGWR         RFS       RECEIVING       483532   119582      0
29047                        1        1 N/A          MRP0      APPLYING_LOG    477715  1545345      0

SQL>

========================================
### RESTORE ARCHIVELOG UNTIL SEQUENCE 483515:
========================================

RMAN> run {
set archivelog destination to '/ubb1/rman/ORC1/archivelog';
restore archivelog from sequence 477715 until sequence 483515;}2> 3>

ALTERNATIVE: 
set archivelog destination to '/ubb1/rman/ORC1/archivelog';
restore archivelog from sequence 477715 until sequence 483515;

========================================
### ENABLE REDO APPLY USING DGMGRL:
========================================

SQL> recover managed standby database cancel;
Media recovery complete.
SQL>

DGMGRL> show configuration

Configuration - linkdg

  Protection Mode: MaxPerformance
  Members:
  PRIMARY - Primary database
    STANDBY1 - Physical standby database 
      Error: ORA-16810: multiple errors or warnings detected for the database

    STANDBY2 - Physical standby database 
    SBY3     - Physical standby database 
      Warning: ORA-16532: Oracle Data Guard broker configuration does not exist

Fast-Start Failover: DISABLED

Configuration Status:
ERROR   (status updated 28 seconds ago)

DGMGRL> show database STANDBY1

Database - STANDBY1

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-OFF
  Transport Lag:      0 seconds (computed 0 seconds ago)
  Apply Lag:          1 minute 6 seconds (computed 0 seconds ago)
  Average Apply Rate: (unknown)
  Real Time Query:    OFF
  Instance(s):
    ORC1

Database Status:
SUCCESS

DGMGRL> edit database 'STANDBY1' set state='APPLY-ON';
Succeeded.

DGMGRL> show database STANDBY1

Database - STANDBY1

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 0 seconds ago)
  Apply Lag:          0 seconds (computed 0 seconds ago)
  Average Apply Rate: 6.01 MByte/s
  Real Time Query:    OFF
  Instance(s):
    ORC1

Database Status:
SUCCESS

DGMGRL> validate database STANDBY1;

  Database Role:     Physical standby database
  Primary Database:  PRIMARY

  Ready for Switchover:  Yes
  Ready for Failover:    Yes (Primary Running)

DGMGRL> show configuration

Configuration - linkdg

  Protection Mode: MaxPerformance
  Members:
  PRIMARY - Primary database
    STANDBY1 - Physical standby database
    STANDBY2 - Physical standby database
    SBY3     - Physical standby database
      Warning: ORA-16532: Oracle Data Guard broker configuration does not exist

Fast-Start Failover: DISABLED

Configuration Status:
WARNING   (status updated 15 seconds ago)

DGMGRL>

Q.E.D.

__ATA.cmd.push(function() { __ATA.initDynamicSlot({ id: 'atatags-26942-61720865790c7', location: 120, formFactor: '001', label: { text: 'Advertisements', }, creative: { reportAd: { text: 'Report this ad', }, privacySettings: { text: 'Privacy', } } }); });

Visit the link when the event is about to start.

Tom Kyte - Thu, 2021-10-21 18:26
Please can I get the zoom link for today's conference?
Categories: DBA Blogs

Secure Data and Application in Cloud Security: Day 7 [Recap]

Online Apps DBA - Thu, 2021-10-21 06:00

What do you understand by the term Storage? Well, I know as most of you would be thinking it’s a place to store something. That something could be anything from the national secret to scraps. The point is whether a security is required or not to protect that Storage? Absolutely Yes, Security should be the first […]

The post Secure Data and Application in Cloud Security: Day 7 [Recap] appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Azure Migrate And Cloud Migration Strategy

Online Apps DBA - Thu, 2021-10-21 05:47

Migration to the Cloud is today’s most popular trend in the IT industry, mostly due to rapid digital transformation. The trend is finding its scope all across irrespective of the size of an organization. But the real question that continues to haunt many is, ‘which is the best cloud option?’ as we have many cloud […]

The post Azure Migrate And Cloud Migration Strategy appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Azure Migrate Step-By-Step Server Setup

Online Apps DBA - Thu, 2021-10-21 05:29

Migrating to Microsoft’s Azure is the most sought option for many firms facing challenges with the on-premises infrastructure.Azure Migrate is a service provided by Microsoft, which can help your enterprise determine how on-premises workloads will perform on the azure cloud service and test its suitability. Not just that, you will also get an estimate of […]

The post Azure Migrate Step-By-Step Server Setup appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

index

Tom Kyte - Thu, 2021-10-21 00:26
Tom: I have a question regarding index. can you explain me in detail what the following means. If the index is a concatenation of multiple columns and one of the columns contains a NULL value, the row will be in the index column containing the NULL value and will be left empty. +++++++++++++++++++++++++++++++++++++++++++++ above is exactly what it says in a book. I can't even understand it's english."the row will be in the index column containing the NULL value and will be left empty" what does that mean?
Categories: DBA Blogs

Request for script to import data

Tom Kyte - Thu, 2021-10-21 00:26
Dear Ask TOM Team, Thank you for your appreciated efforts and providing the guidance to all concerned clients. My question: I have running and in production oracle DB, 11g ... and would like to import and update the data from other DB with the same structure and version, Please: 1- provide me the script to do such required import data to the running DB. 2- provide me the script to do such required export data to the running DB. Regards, Reda Eltayef
Categories: DBA Blogs

i want to export only the objects owned by given schema using EXPDP

Tom Kyte - Thu, 2021-10-21 00:26
Hi, i want to export only the objects owned by given schema using EXPDP, but unfortunately it is exporting all the objects which schema has access to. i am using below syntax. <code>expdp school/school@orcl schemas=(demo) directory=DATA_PUMP_DIR dumpfile=demo.dmp logfile=expdp.log</code> Please help. Thanks Fahd
Categories: DBA Blogs

Autonomous transactions and commit point optimization

Tom Kyte - Thu, 2021-10-21 00:26
Hi We have an application written with PL/SQL and thus with commit point optimization. However AWR reports show a lot of log file sync waits. How do autonomous transactions, which we are using for logging purposes operate with pl/sql code. Is the commit point optimization utilized? If some procedure is called which is defined as an autonomous transaction and no actual dml operations are done (which could happen in logging operations), is there still some commit handling done ? If so, what ? lh
Categories: DBA Blogs

How to calculate timestamp from an old ora_rowsn taking as a reference a current ora_rowscn timestamp_to_scn(sysdate) from DUAL

Tom Kyte - Thu, 2021-10-21 00:26
As you know, the association between an SCN and a timestamp when the SCN is generated is remembered by the database for a limited time period and an error is returned if the SCN specified for the argument to SCN_TO_TIMESTAMP is too old. Example: <code>select scn_to_timestamp(max(ora_rowscn)) from MY_TABLE</code> <i><b>ORA-08181: el numero especificado no es un numero de cambio del sistema valido ORA-06512: en "SYS.SCN_TO_TIMESTAMP", linea 1 08181. 00000 - "specified number is not a valid system change number" *Cause: supplied scn was beyond the bounds of a valid scn. *Action: use a valid scn.</b></i> Nevertheless, I can obtain the max(ora_rowscn) from MY_TABLE without any kind of error: <code> select max(ora_rowscn) from MY_TABLE MAX(ORA_ROWSCN) --------------- 99464620 </code> I would like to obtain the corresponding timestamp of this ORA_ROWSCN approximately (I don't care if it may vary some hours), <b>without using any AUDIT tool but using PL/SQL statements</b>. Does exist any relationship between the above MAX(ORA_ROWSCN) from MY_TABLE and the current ORA_ROWSCN from sysdate? <code> select timestamp_to_scn(sysdate), TO_CHAR(SYSDATE,'dd-mm-yyyy hh24:mi:ss') from dual TIMESTAMP_TO_SCN(SYSDATE) TO_CHAR(SYSDATE,'dd-mm-yyyy hh24:mi:ss') ------------------------- ---------------------------------------- 116631465 13-10-2021 12:12:02 </code> Could I calculate, using any kind of algorithm, the corresponding timestamp to <b>99464620</b> value? Thanks in advance.
Categories: DBA Blogs

Different sql id/sql text showing up in v$session

Tom Kyte - Wed, 2021-10-20 06:06
Hello! I have a particular ETL job that fires below 4 select queries on a view definition to our Oracle database - <code>select * from view where mod(id,4) = 1; select * from view where mod(id,4) = 2; select * from view where mod(id,4) = 3; select * from view where mod(id,4) = 0; </code> However when the queries start executing and I check v$session for the 4 sessions running these 4 queries, I see a common sql id showing up for all these 4 queries and the sql text for this sql id seems completely unfamiliar/unrelated to the queries that are actually being executed. So I am a bit lost as I have not come across such scenario earlier. What could this sql id be and why would it be showing up in v$session for all 4 different queries?
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator