#qualitytip - Twitter Hashtag

12 months ago

With 2 powerful keywords: "RESTART IDENTITY", and "SERIAL", I can easily handle sequences without even using the word "SEQUENCE" -- look at pix, where I create an autoincrement primary key, then empty the table and have that primary key restart from 0 #postgresql #DBA #qualitytip

fdernoncourt's tweet photo. With 2 powerful keywords: "RESTART IDENTITY", and "SERIAL", I can easily handle sequences without even using the word "SEQUENCE" -- look at pix, where I create an autoincrement primary key, then empty the table and have that primary key restart from 0
#postgresql #DBA #qualitytip https://t.co/ygFsymTiHq

0

4

1

0

255

Dear DBA Frank @fdernoncourt

over 2 years ago

Nifty SELECT to give you the breakdown between table , index and LOB sizes for one or several schemas. #orclDB #DBA #qualitytip

fdernoncourt's tweet photo. Nifty SELECT to give you the breakdown between table , index and LOB sizes for one or several schemas.
#orclDB #DBA #qualitytip https://t.co/5dA9jZUiH2

2

10

1

5

917

Dear DBA Frank @fdernoncourt

almost 3 years ago

To prepare your datapump import, get the CREATE TABLESPACE commands you require with this nifty SELECT dbms_metadata.get_ddl('TABLESPACE',TABLESPACE_NAME) from (SELECT DISTINCT TABLESPACE_NAME from dba_segments where OWNER in ('S','S2','S3')); #orclDB #DBA #qualitytip

fdernoncourt's tweet photo. To prepare your datapump import, get the CREATE TABLESPACE commands you require with this nifty
SELECT
dbms_metadata.get_ddl('TABLESPACE',TABLESPACE_NAME) from (SELECT DISTINCT TABLESPACE_NAME from dba_segments where OWNER in ('S','S2','S3'));
#orclDB #DBA #qualitytip https://t.co/YeEAl5Iis1

0

9

2

7

1K

433tips @football433tips

over 3 years ago

🙏No scam no fake whatsoever... Many have been with my VIP group since many months... Thanks my VIP. U deserved more winners... #testimonial #qualitytip #betteroddspick

Moonman4787 @moonman4787

over 3 years ago

Every single day is like this!!! BOOOoOoOoOoOoOoM

2

3

2

1

1K

0

2

1

0

509

Dear DBA Frank @fdernoncourt

about 4 years ago

After setting up #Dataguard, check it with my cool one-liner: dgmgrl / 'show configuration lag verbose' -silent It gives you info about all the #orclDB involved, any lag, the observers, FSFO, properties... #DBA #qualitytip

fdernoncourt's tweet photo. After setting up #Dataguard, check it with my cool one-liner:
dgmgrl / 'show configuration lag verbose' -silent
It gives you info about all the #orclDB involved, any lag, the observers, FSFO, properties...
#DBA #qualitytip https://t.co/KctANcTbaN

1

30

10

6

0

MAHQ @MAHQ_MI

almost 6 years ago

MAHQ QUALITY TIP TUESDAY! MAHQ will be celebrating maintaining quality with patient safety on September 17th! #patientsafety #qtt #mahq #qualitytip #patientsafetyday #qualitycare #patientcare #healthcarequality #qualitytiptuesday

MAHQ_MI's tweet photo. MAHQ QUALITY TIP TUESDAY!

MAHQ will be celebrating maintaining quality with patient safety on September 17th!

#patientsafety #qtt #mahq #qualitytip #patientsafetyday #qualitycare #patientcare #healthcarequality #qualitytiptuesday https://t.co/cdtnS4SEqA

0

7

4

0

Alyssa Spiteri @alyssa_spiteri

almost 6 years ago

MAHQ QUALITY TIP TUESDAY! MAHQ will be celebrating maintaining quality with patient safety on 9/17/2020! #patientsafety #qtt #mahq #qualitytip #patientsafetyday #qualitycare #patientcare #healthcarequality #qualitytiptuesday https://t.co/fZ24YB9XNs

0

3

1

0

Dear DBA Frank @fdernoncourt

almost 6 years ago

for DBSID in $(awk -F':' '/^#/ {next}; {print $1}' /etc/oratab) do export ORACLE_SID=$DBSID echo " for this SID: $DBSID" sqlplus -s / as sysdba <<EOF set feed off pagesize 0 echo off select name,open_mode from v\$database; EOF done #orclDB #DBA #qualitytip

0

5

4

3

0

Department of Safety & Quality Assurance, MARTA @DSQAMARTA

almost 6 years ago

#QualityTip #AnalysisParalysis #WednesdayWisdom #WednesdayTips #WednesdayThoughts #QualityAssurance #Quality #QA #Safety #StraightOuttaOurQualityBulletin #DSQA #BeSafe

DSQAMARTA's tweet photo. #QualityTip #AnalysisParalysis #WednesdayWisdom #WednesdayTips #WednesdayThoughts #QualityAssurance #Quality #QA #Safety #StraightOuttaOurQualityBulletin #DSQA #BeSafe https://t.co/UxGjlTSIG7

0

1

0

Dear DBA Frank @fdernoncourt

over 6 years ago

You can mention several TNS aliases for the same connection details (see picture). Useful for development environments (different schemas in the same database). #orclDB #DBA #qualitytip

fdernoncourt's tweet photo. You can mention several TNS aliases for the same connection details (see picture). Useful for development environments (different schemas in the same database).
#orclDB #DBA #qualitytip https://t.co/pRIHGJvixv

0

9

2

0

Dear DBA Frank @fdernoncourt

over 6 years ago

When installing #RAC (here a 12.2 2-node cluster), double-check the subnet for each interface with the subnets mentioned by cluvfy stage -pre crsinst -verbose #oracle #DBA #qualitytip

fdernoncourt's tweet photo. When installing #RAC (here a 12.2 2-node cluster), double-check the subnet for each interface with the subnets mentioned by
cluvfy stage -pre crsinst -verbose
#oracle #DBA #qualitytip https://t.co/tYuviNqgQz

0

6

2

0

Dear DBA Frank @fdernoncourt

over 6 years ago

SELECT * FROM GV$LISTENER_NETWORK ORDER BY TYPE,VALUE,INST_ID; will list all your LISTENERS and the IP addresses of the VIPs #orclDB #RAC #qualitytip

fdernoncourt's tweet photo. SELECT * FROM GV$LISTENER_NETWORK ORDER BY TYPE,VALUE,INST_ID;
will list all your LISTENERS and the IP addresses of the VIPs
#orclDB #RAC #qualitytip https://t.co/Ovn9ccmS7Q

1

21

8

7

0

Quality Urgent Care @QualityCare_TX

over 7 years ago

New Year, New Goals! https://t.co/D8HOSjEZ1X ..... #SanAntonioUrgentCare #QualityCare #QualityUrgentCare #SanAntonio #Schertz #Pleasanton #PaloAlto #WestSanAntonio #MedicalCenter #TX #UrgentCare #Gym #Fit #Workout #QualityCare #QualityTip

QualityCare_TX's tweet photo. New Year, New Goals!
https://t.co/D8HOSjEZ1X
.....
#SanAntonioUrgentCare #QualityCare #QualityUrgentCare #SanAntonio #Schertz #Pleasanton #PaloAlto #WestSanAntonio #MedicalCenter #TX #UrgentCare #Gym #Fit #Workout #QualityCare #QualityTip https://t.co/VgQNU6FuBf

0

2

0

Dear DBA Frank @fdernoncourt

over 7 years ago

SQL to generate the GRANTs on THEOWNER's objects for a _RO read-only user: SELECT 'grant SELECT ON &&theowner..'||object_name||' to &&theowner._RO ;' FROM all_objects WHERE OWNER = '&&theowner' AND object_type IN ('VIEW','TABLE','SYNONYM') ORDER BY object_type; #DBA #qualitytip

0

6

4

1

0

Quality ROBINA @Quality_Inmob

over 7 years ago

Porque nos encantan las cocinas y es una de las áreas más importantes en cada casa... les dejamos esta por aquí! #QualityTip #qualityinmobiliariarobina @AptTherapy https://t.co/00yK5OLcTs

0

1

0

Dear DBA Frank @fdernoncourt

almost 8 years ago

In #oracldb >= 12.2 use the V$diag_trace_file view to keep track of the slowness of your LOG WRITER SELECT MODIFY_TIME,TRACE_FILENAME FROM V$DIAG_TRACE_FILE WHERE TRACE_FILENAME LIKE '%lgwr%.trc' ORDER BY 1; LGWR creates these traces if a write took more than 500ms #qualitytip