Note: You can get this code from your database trace file also just using the following command. NLS_CHARACTERSET WE8MSWIN1252 Character setĪfter finding all the above details you can edit the below code and run it on SQL prompt. Select * from database_properties where PROPERTY_NAME='NLS_CHARACTERSET' How to check your database characterset col PROPERTY_VALUE for a20 Select l.group#,l.member,f.bytes/1024/1024 "size in MB"įrom v$logfile l, v$log f where l.group#=f.group# ġ /u01/app/oracle/oradata/ocptech/redo01.log 50ģ /u01/app/oracle/oradata/ocptech/redo03.log 50Ĥ /u01/app/oracle/oradata/ocptech/redo04.log 50Ĥ. Check your redo location and size col member for a55 u01/app/oracle/oradata/ocptech/example01.dbfģ. u01/app/oracle/oradata/ocptech/users01.dbf u01/app/oracle/oradata/ocptech/undotbs01.dbf u01/app/oracle/oradata/ocptech/sysaux01.dbf u01/app/oracle/oradata/ocptech/system01.dbf Check your Datafile Location select name from v$datafile Check your Database name select name from v$database Ģ. In the Below code, you need to change your database name, logfile group location, and datafile with the location.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |